Database: advertising_agencies
Question: Show agency ids and the number of clients for each agency.
SQL:
SELECT agency_id ,  count(*) FROM Clients GROUP BY agency_id