user: ### NOW ANSWER:
Question: What was the birth state of Charles Cotesworth Pinckney who was elected in 1808?
Columns: ['Name', 'Election Year', 'Party', 'Birth State', 'Resident State']
Types: ['text', 'real', 'text', 'text', 'text']
Sample row: ['Charles Cotesworth Pinckney', 1804.0, 'Federalist', 'Lost South Carolina', 'Lost South Carolina']
SQL:

assistant: SELECT "Birth State" FROM "Table" WHERE "Name" = 'Charles Cotesworth Pinckney' AND "Election Year" = 1808.0;