Database: customers_and_invoices
Question: Show the invoice number and the number of transactions for each invoice.
SQL:
SELECT invoice_number ,  count(*) FROM Financial_transactions GROUP BY invoice_number