Database: book_1
Question: What are the names of all the clients, and how many times has each of them ordered?
SQL:
SELECT T2.name ,  count(*) FROM Orders AS T1 JOIN Client AS T2 ON T1.idClient  =  T2.idClient GROUP BY T1.idClient