SELECT billing_state, COUNT(*) FROM invoices WHERE billing_country = "USA" GROUP BY billing_state ORDER BY COUNT(*) DESC LIMIT 1
Sebutkan negara bagian di AS dengan faktur terbanyak.
CREATE TABLE invoices (billing_state VARCHAR, billing_country VARCHAR)