Table: tallest_buildings_sa
Columns: rank
name
city
height
floors

Question: What is the average number of floors for buildings in mecca ranked above 12?
SQL: SELECT AVG("floors") FROM tallest_buildings_sa WHERE "city" = 'mecca' AND "rank" < 12

Question: What city is the lamar tower 1, ranked above 5?
SQL: SELECT "city" FROM tallest_buildings_sa WHERE "rank" < 5 AND "name" = 'lamar tower 1'

Question: What city has a building with over 57 floors?
SQL: SELECT "city" FROM tallest_buildings_sa WHERE "floors" > 57