mySQL中两个表中的SELECT和SELECT COUNT

Question

is it possible to combine SELECT and SELECT COUNT in two tables that are connected with the argument JOIN?

I want to select first and last name of customers and only count the amount of orders for each customer.

The table should display first-, lastname and the amount of orders for each customer, whereas last column should be named 'Anzahl Aufträge'.

enter image description here

enter image description here

I just added two links, so you can see, how the table should look like. :)

Answer 1

You have not given details so I must guess.

Try this:

       SELECT customer.customer_id, customer.givenname, customer.surname, 
              COUNT(*) number_of_orders
         FROM customer
         JOIN order ON customer.customer_id = order.customer_id
        GROUP BY customer.customer_id, customer.givenname, customer.surname