Database: advertising_agencies
Question: How many payments are there for each invoice?
SQL:
SELECT invoice_id ,  count(*) FROM Payments GROUP BY invoice_id