CREATE TABLE invoices (billing_state VARCHAR2, billing_country VARCHAR2)

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