List the number of invoices from the US, grouped by state.
CREATE TABLE invoices (billing_state VARCHAR, billing_country VARCHAR)
SELECT billing_state, COUNT(*) FROM invoices WHERE billing_country = "USA" GROUP BY billing_state
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE invoices (billing_state VARCHAR, billing_country VARCHAR) Question: List the number of invoices from the US, grouped by state. [/INST] SELECT billing_state, COUNT(*) FROM invoices WHERE billing_country = "USA" GROUP BY billing_state </s>