Table: tallest_buildings_nashville_2
Columns: name
street_address
years_as_tallest
height_ft_m
floors

Question: During what years did the tallest building, located at 211 Union Street, have less than 31 floors?
SQL: SELECT "years_as_tallest" FROM tallest_buildings_nashville_2 WHERE "floors" < 31 AND "street_address" = '211 union street'

Question: What is the average number of floors at 170 Fourth Avenue North?
SQL: SELECT AVG("floors") FROM tallest_buildings_nashville_2 WHERE "street_address" = '170 fourth avenue north'

Question: What is the address of the Life & Casualty Tower?
SQL: SELECT "street_address" FROM tallest_buildings_nashville_2 WHERE "name" = 'life & casualty tower'