text: CREATE TABLE representative (Party VARCHAR) -- What are the different parties of representative? Show the party name and the number of representatives in each party. SELECT Party, COUNT(*) FROM representative GROUP BY Party CREATE TABLE representative (Party VARCHAR) -- What is the party that has the largest number of representatives? SELECT Party, COUNT(*) FROM representative GROUP BY Party ORDER BY COUNT(*) DESC LIMIT 1 CREATE TABLE representative (Party VARCHAR) -- What parties have at least three representatives? SELECT Party FROM representative GROUP BY Party HAVING COUNT(*) >= 3 CREATE TABLE representative (State VARCHAR) -- What states have at least two representatives? SELECT State FROM representative GROUP BY State HAVING COUNT(*) >= 2 CREATE TABLE election (Name VARCHAR, Representative_ID VARCHAR); CREATE TABLE representative (Name VARCHAR, Representative_ID VARCHAR) -- List the names of representatives that have not participated in elections listed here. SELECT Name FROM representative WHERE NOT Representative_ID IN (SELECT Representative_ID FROM election) CREATE TABLE representative (Party VARCHAR, State VARCHAR) -- Show the parties that have both representatives in New York state and representatives in Pennsylvania state. SELECT Party FROM representative WHERE State = "New York" INTERSECT SELECT Party FROM representative WHERE State = "Pennsylvania" CREATE TABLE representative (Party VARCHAR) -- How many distinct parties are there for representatives? SELECT COUNT(DISTINCT Party) FROM representative