who is the home team when tie no is less than 7 and the away team is havant & waterlooville?
CREATE TABLE table_name_24 (home_team VARCHAR, tie_no VARCHAR, away_team VARCHAR)
SELECT home_team FROM table_name_24 WHERE tie_no < 7 AND away_team = "havant & waterlooville"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_24 (home_team VARCHAR, tie_no VARCHAR, away_team VARCHAR) Question: who is the home team when tie no is less than 7 and the away team is havant & waterlooville? [/INST] SELECT home_team FROM table_name_24 WHERE tie_no < 7 AND away_team = "havant & waterlooville" </s>