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"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE representative (Lifespan VARCHAR, State VARCHAR) Question: What are the life spans of representatives from New York state or Indiana state? [/INST] SELECT Lifespan FROM representative WHERE State = "New York" OR State = "Indiana" </s>