Database: store_1
Question: How many invoices were billed from each state?
SQL:
SELECT billing_state ,  COUNT(*) FROM invoices WHERE billing_country  =  "USA" GROUP BY billing_state;