Table: tallest_buildings_nashville
Columns: rank
name
height_ft_m
floors
year

Question: When Regions center has a rank less than 11, what is the greatest number o floors?
SQL: SELECT MAX("floors") FROM tallest_buildings_nashville WHERE "name" = 'regions center' AND "rank" < 11

Question: What is the average rank for a building with 24 floors?
SQL: SELECT AVG("rank") FROM tallest_buildings_nashville WHERE "floors" = 24

Question: What is the rank for Omni nashville hotel?
SQL: SELECT SUM("rank") FROM tallest_buildings_nashville WHERE "name" = 'omni nashville hotel'

Question: What is the greatest rank for Fifth third center?
SQL: SELECT MAX("rank") FROM tallest_buildings_nashville WHERE "name" = 'fifth third center'

Question: When a building is 292 (89) ft (m) tall, has less than 23 floors, and ranks less than 14, what is the average year?
SQL: SELECT AVG("year") FROM tallest_buildings_nashville WHERE "floors" < 23 AND "height_ft_m" = '292 (89)' AND "rank" < 14