Table: panama_city_buildings
Columns: rank
name
height_m_feet
floors
year

Question: When was the average year that the number of floors was greater than 75?
SQL: SELECT AVG("year") FROM panama_city_buildings WHERE "floors" > 75

Question: What is the average number of floors of the Venetian tower?
SQL: SELECT AVG("floors") FROM panama_city_buildings WHERE "name" = 'venetian tower'