Which Number has a Year Start smaller than 1874, and a Year End larger than 1873?
CREATE TABLE table_name_13 (number INTEGER, year_start VARCHAR, year_end VARCHAR)
SELECT MAX(number) FROM table_name_13 WHERE year_start < 1874 AND year_end > 1873
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_13 (number INTEGER, year_start VARCHAR, year_end VARCHAR) Question: Which Number has a Year Start smaller than 1874, and a Year End larger than 1873? [/INST] SELECT MAX(number) FROM table_name_13 WHERE year_start < 1874 AND year_end > 1873 </s>