Which Number has a Home Club of broomstones, and a Year End smaller than 1999?
CREATE TABLE table_name_79 (number INTEGER, home_club VARCHAR, year_end VARCHAR)
SELECT MIN(number) FROM table_name_79 WHERE home_club = "broomstones" AND year_end < 1999
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_79 (number INTEGER, home_club VARCHAR, year_end VARCHAR) Question: Which Number has a Home Club of broomstones, and a Year End smaller than 1999? [/INST] SELECT MIN(number) FROM table_name_79 WHERE home_club = "broomstones" AND year_end < 1999 </s>