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 NUMBER, vote_percent NUMBER, seats NUMBER, place NUMBER)

What are the life spans of representatives from New York state or Indiana state?
SELECT lifespan FROM representative WHERE state = "New York" OR state = "Indiana"
SELECT "lifespan" FROM "representative" WHERE "Indiana" = "state" OR "New York" = "state"