CREATE TABLE Financial_transactions (invoice_number VARCHAR2)

Show the invoice number and the number of transactions for each invoice.
SELECT invoice_number, COUNT(*) FROM Financial_transactions GROUP BY invoice_number
SELECT "invoice_number", COUNT(*) FROM "Financial_transactions" GROUP BY "invoice_number"