Database: store_1
Question: List the number of invoices from the US, grouped by state.
SQL:
SELECT billing_state ,  COUNT(*) FROM invoices WHERE billing_country  =  "USA" GROUP BY billing_state;