Table: mumbai_buildings
Columns: sr_no
name
locale
height
floors
building_type

Question: what is the name when the sr no is less than 74 and floors is more than 36?
SQL: SELECT "name" FROM mumbai_buildings WHERE "sr_no" < 74 AND "floors" > 36

Question: how many times is the building type residential and the locale yashodham?
SQL: SELECT COUNT("sr_no") FROM mumbai_buildings WHERE "building_type" = 'residential' AND "locale" = 'yashodham'

Question: what is the least floors when the building type is residential and the sr no is 8?
SQL: SELECT MIN("floors") FROM mumbai_buildings WHERE "building_type" = 'residential' AND "sr_no" = 8

Question: what is the height when the locale is nepean sea road, floors is more than 30 and sr no is 58?
SQL: SELECT "height" FROM mumbai_buildings WHERE "locale" = 'nepean sea road' AND "floors" > 30 AND "sr_no" = 58

Question: what is the name that had 46 floors?
SQL: SELECT "name" FROM mumbai_buildings WHERE "floors" = 46