what is the least floors when the building type is residential and the sr no is 8?
CREATE TABLE table_name_79 (floors INTEGER, building_type VARCHAR, sr_no VARCHAR)
SELECT MIN(floors) FROM table_name_79 WHERE building_type = "residential" AND sr_no = 8
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_79 (floors INTEGER, building_type VARCHAR, sr_no VARCHAR) Question: what is the least floors when the building type is residential and the sr no is 8? [/INST] SELECT MIN(floors) FROM table_name_79 WHERE building_type = "residential" AND sr_no = 8 </s>