Table: quebec_buildings
Columns: rank
name
height_m_ft
floors
year

Question: Tell me the average year for rank more than 3 and 28 floors
SQL: SELECT AVG("year") FROM quebec_buildings WHERE "rank" > 3 AND "floors" = 28

Question: I want the name for rank less than 6 and year more than 1974
SQL: SELECT "name" FROM quebec_buildings WHERE "rank" < 6 AND "year" > 1974