Database: advertising_agencies
Question: How many clients does each agency have?
SQL:
SELECT agency_id ,  count(*) FROM Clients GROUP BY agency_id