Table: magnificent_mile_buildings
Columns: name
street_address
height_feet_meters
floors
year

Question: Street Address of 980 n. michigan avenue is what name?
SQL: SELECT "name" FROM magnificent_mile_buildings WHERE "street_address" = '980 n. michigan avenue'

Question: Name of 900 north michigan, and a Year smaller than 1989 involves what lowest floors?
SQL: SELECT MIN("floors") FROM magnificent_mile_buildings WHERE "name" = '900 north michigan' AND "year" < 1989

Question: Street Address of 401 n. wabash avenue involves what name?
SQL: SELECT "name" FROM magnificent_mile_buildings WHERE "street_address" = '401 n. wabash avenue'