What are the life spans of representatives from New York state or Indiana state?
CREATE TABLE representative (
    Lifespan VARCHAR,
    State VARCHAR
)
SELECT Lifespan FROM representative WHERE State = "New York" OR State = "Indiana"
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: What are the life spans of representatives from New York state or Indiana state? ### Input: CREATE TABLE representative (
    Lifespan VARCHAR,
    State VARCHAR
) ### Response: SELECT Lifespan FROM representative WHERE State = "New York" OR State = "Indiana"