user: ### NOW ANSWER:
Question: how many "Party" are in district South Carolina 2?
Columns: ['District', 'Incumbent', 'Party', 'First elected', 'Result', 'Candidates']
Types: ['text', 'text', 'text', 'text', 'text', 'text']
Sample row: ['South Carolina 1', 'William Drayton', 'Jacksonian', '1825 ( special )', 'Re-elected', 'William Drayton (J)']
SQL:

assistant: SELECT COUNT("Party") FROM "Table" WHERE "District" = 'South Carolina 2';