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 life spans of all representatives
assistant
SELECT Lifespan FROM representative;
human
what are the life spans of representatives from New York?
assistant
SELECT Lifespan FROM representative WHERE State = "New York" ;