Database: advertising_agencies
Question: How many invoices are there for each status code?
SQL:
SELECT invoice_status ,  count(*) FROM Invoices GROUP BY invoice_status