CREATE TABLE media_types (id NUMBER, name CLOB)
CREATE TABLE invoices (id NUMBER, customer_id NUMBER, invoice_date TIME, billing_address CLOB, billing_city CLOB, billing_state CLOB, billing_country CLOB, billing_postal_code CLOB, total NUMBER)
CREATE TABLE invoice_lines (id NUMBER, invoice_id NUMBER, track_id NUMBER, unit_price NUMBER, quantity NUMBER)
CREATE TABLE artists (id NUMBER, name CLOB)
CREATE TABLE customers (id NUMBER, first_name CLOB, last_name CLOB, company CLOB, address CLOB, city CLOB, state CLOB, country CLOB, postal_code CLOB, phone CLOB, fax CLOB, email CLOB, support_rep_id NUMBER)
CREATE TABLE playlist_tracks (playlist_id NUMBER, track_id NUMBER)
CREATE TABLE albums (id NUMBER, title CLOB, artist_id NUMBER)
CREATE TABLE sqlite_sequence (name CLOB, seq CLOB)
CREATE TABLE tracks (id NUMBER, name CLOB, album_id NUMBER, media_type_id NUMBER, genre_id NUMBER, composer CLOB, milliseconds NUMBER, bytes NUMBER, unit_price NUMBER)
CREATE TABLE employees (id NUMBER, last_name CLOB, first_name CLOB, title CLOB, reports_to NUMBER, birth_date TIME, hire_date TIME, address CLOB, city CLOB, state CLOB, country CLOB, postal_code CLOB, phone CLOB, fax CLOB, email CLOB)
CREATE TABLE playlists (id NUMBER, name CLOB)
CREATE TABLE genres (id NUMBER, name CLOB)

What are the states 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