Table: tallest_buildings_sd
Columns: rank
name
height_feet_m
floors
year

Question: which year holds rank 2?
SQL: SELECT MAX("year") FROM tallest_buildings_sd WHERE "rank" = '2'

Question: with name meridian condominiums what is number of floors?
SQL: SELECT AVG("floors") FROM tallest_buildings_sd WHERE "name" = 'meridian condominiums'

Question: with rank of 31 what is the year?
SQL: SELECT COUNT("year") FROM tallest_buildings_sd WHERE "rank" = '31'