SCHEMA:
CREATE TABLE invoices (billing_state VARCHAR, billing_country VARCHAR)
USER:
List the number of invoices from the US, grouped by state.

QUERY:
SELECT billing_state, COUNT(*) FROM invoices WHERE billing_country = "USA" GROUP BY billing_state