human
Schema:
election (Election_ID, Representative_ID, Date, Votes, Vote_Percent, Seats, Place)
representative (Representative_ID, Name, State, Party, Lifespan)
Please answer with SQL.
assistant
Sure, I understand.
human
List the votes of elections in descending order.
assistant
SELECT Votes FROM election ORDER BY Votes DESC
human
List the dates and vote percents of elections.
assistant
SELECT Date , Vote_Percent FROM election
human
What are the names of representatives whose party is not 'Republican'?
assistant
SELECT Name FROM Representative WHERE Party != 'Republican'
human
What are the names of representatives with more than 10000 votes in election?
assistant
SELECT T2.Name FROM election AS T1 JOIN representative AS T2 ON T1.Representative_ID = T2.Representative_ID WHERE Votes > 10000
human
What are the names of representatives and the dates of elections they participated in.
assistant
SELECT T2.Name , T1.Date FROM election AS T1 JOIN representative AS T2 ON T1.Representative_ID = T2.Representative_ID
human
List the names of representatives that have not participated in elections listed here.
assistant
SELECT Name FROM representative WHERE Representative_ID NOT IN ( SELECT Representative_ID FROM election ) ;