CREATE TABLE party (party_id DECIMAL, year DECIMAL, party TEXT, governor TEXT, lieutenant_governor TEXT, comptroller TEXT, attorney_general TEXT, us_senate TEXT)
CREATE TABLE county (county_id DECIMAL, county_name TEXT, population DECIMAL, zip_code TEXT)
CREATE TABLE election (election_id DECIMAL, counties_represented TEXT, district DECIMAL, delegate TEXT, party DECIMAL, first_elected DECIMAL, committee TEXT)

Count the total number of counties.
SELECT COUNT(*) FROM county
SELECT COUNT(*) FROM "county"