Database: advertising_agencies
Question: Show the agency ids and the number of staff in each agent?
SQL:
SELECT agency_id ,  count(*) FROM Staff GROUP BY agency_id