Schema: CREATE TABLE representative (Lifespan VARCHAR, State VARCHAR)
Question: What are the life spans of representatives from New York state or Indiana state?
SQL: SELECT Lifespan FROM representative WHERE State = "New York" OR State = "Indiana"