Table: spencer_building
Columns: name
street_address
years_as_tallest
height_m_ft
floors

Question: What name has 100 w. pender st. as the address?
SQL: SELECT "name" FROM spencer_building WHERE "street_address" = '100 w. pender st.'

Question: How many floors have 207 w. hastings st. as the address?
SQL: SELECT COUNT("floors") FROM spencer_building WHERE "street_address" = '207 w. hastings st.'

Question: What is the height m/ft where 207 w. hastings st. is the address?
SQL: SELECT "height_m_ft" FROM spencer_building WHERE "street_address" = '207 w. hastings st.'