CREATE TABLE table_57718 ("Name" CLOB, "Election Year" FLOAT, "Party" CLOB, "Birth State" CLOB, "Resident State" CLOB)

What was the birth state of Charles Cotesworth Pinckney who was elected in 1808?
SELECT "Birth State" FROM table_57718 WHERE "Name" = 'charles cotesworth pinckney' AND "Election Year" = '1808'
SELECT "Birth State" FROM "table_57718" WHERE "Election Year" = '1808' AND "Name" = 'charles cotesworth pinckney'