Database: advertising_agencies
Question: Show all invoice ids and the number of payments for each invoice.
SQL:
SELECT invoice_id ,  count(*) FROM Payments GROUP BY invoice_id