which # / county is correct for year less than 1981 and chalmers as location?
CREATE TABLE table_name_90 (_number___county VARCHAR, year_joined VARCHAR, location VARCHAR)
SELECT _number___county FROM table_name_90 WHERE year_joined < 1981 AND location = "chalmers"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_90 (_number___county VARCHAR, year_joined VARCHAR, location VARCHAR) Question: which # / county is correct for year less than 1981 and chalmers as location? [/INST] SELECT _number___county FROM table_name_90 WHERE year_joined < 1981 AND location = "chalmers" </s>