CREATE TABLE invoices (billing_state VARCHAR2, billing_country VARCHAR2)

List the state in the US with the most invoices.
SELECT billing_state, COUNT(*) FROM invoices WHERE billing_country = "USA" GROUP BY billing_state ORDER BY COUNT(*) DESC LIMIT 1
SELECT "billing_state", COUNT(*) FROM "invoices" WHERE "USA" = "billing_country" GROUP BY "billing_state" ORDER BY COUNT(*) DESC FETCH FIRST 1 ROWS ONLY