CREATE TABLE representative (Lifespan VARCHAR, State VARCHAR)

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"