What was the lifespan of Representative Harry P. O'neill from the state of Pennsylvania?
CREATE TABLE table_name_28 (lifespan VARCHAR, state VARCHAR, representative VARCHAR)
SELECT lifespan FROM table_name_28 WHERE state = "pennsylvania" AND representative = "harry p. o'neill"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_28 (lifespan VARCHAR, state VARCHAR, representative VARCHAR) Question: What was the lifespan of Representative Harry P. O'neill from the state of Pennsylvania? [/INST] SELECT lifespan FROM table_name_28 WHERE state = "pennsylvania" AND representative = "harry p. o'neill" </s>