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
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: what is the least floors when the building type is residential and the sr no is 8? ### Input: CREATE TABLE table_name_79 (
    floors INTEGER,
    building_type VARCHAR,
    sr_no VARCHAR
) ### Response: SELECT MIN(floors) FROM table_name_79 WHERE building_type = "residential" AND sr_no = 8