Database: advertising_agencies
Question: Show all client ids and the number of invoices for each client.
SQL:
SELECT client_id ,  count(*) FROM Invoices GROUP BY client_id