CREATE TABLE representative (Representative_ID NUMBER, Name CLOB, State CLOB, Party CLOB, Lifespan CLOB)
CREATE TABLE election (Election_ID NUMBER, Representative_ID NUMBER, Date CLOB, Votes FLOAT, Vote_Percent FLOAT, Seats FLOAT, Place FLOAT)

What are the different parties of representative? Show the party name and the number of representatives in each party. Plot them as pie chart.
SELECT Party, COUNT(*) FROM representative GROUP BY Party
SELECT "Party", COUNT(*) FROM "representative" GROUP BY "Party"