Show the invoice number and the number of transactions for each invoice.
CREATE TABLE Financial_transactions (invoice_number VARCHAR)
SELECT invoice_number, COUNT(*) FROM Financial_transactions GROUP BY invoice_number
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Financial_transactions (invoice_number VARCHAR) Question: Show the invoice number and the number of transactions for each invoice. [/INST] SELECT invoice_number, COUNT(*) FROM Financial_transactions GROUP BY invoice_number </s>