CREATE TABLE table_name_74 (birth_state VARCHAR2, name VARCHAR2, election_year VARCHAR2)

What was the birth state of Charles Cotesworth Pinckney who was elected in 1808?
SELECT birth_state FROM table_name_74 WHERE name = "charles cotesworth pinckney" AND election_year = 1808
SELECT "birth_state" FROM "table_name_74" WHERE "charles cotesworth pinckney" = "name" AND "election_year" = 1808