Table: skyscrapers_lubbock
Columns: rank
name
height_ft_m
floors_stories
year_completed

Question: What year was the building with a top 3 rank and a height of 274 (84) ft (m) completed?
SQL: SELECT MAX("year_completed") FROM skyscrapers_lubbock WHERE "rank" < 3 AND "height_ft_m" = '274 (84)'

Question: How many floors are in the 274 (84) ft (m) building that is ranked number 1?
SQL: SELECT AVG("floors_stories") FROM skyscrapers_lubbock WHERE "height_ft_m" = '274 (84)' AND "rank" > 1

Question: Which is the highest ranked building with more than 15 floors?
SQL: SELECT MAX("rank") FROM skyscrapers_lubbock WHERE "floors_stories" > 15