Database: book_1
Question: Show all client names and the number of orders each has made.
SQL:
SELECT T2.name ,  count(*) FROM Orders AS T1 JOIN Client AS T2 ON T1.idClient  =  T2.idClient GROUP BY T1.idClient