Table: old_state_house
Columns: name
street_address
years_as_tallest
height_ft_m
floors

Question: What is the name of a building that has 52 floors?
SQL: SELECT "name" FROM old_state_house WHERE "floors" = 52

Question: How many floors does the Custom House Tower have?
SQL: SELECT COUNT("floors") FROM old_state_house WHERE "name" = 'custom house tower'

Question: How many floors does the building on 800 Boylston Street have?
SQL: SELECT MAX("floors") FROM old_state_house WHERE "street_address" = '800 boylston street'

Question: What is the street address for the Prudential Tower building?
SQL: SELECT "street_address" FROM old_state_house WHERE "name" = 'prudential tower'

Question: There is a building at 800 Boylston Street, how many floors does it have?
SQL: SELECT SUM("floors") FROM old_state_house WHERE "street_address" = '800 boylston street'