Table: sf_buildings
Columns: rank
name
height_ft_m
floors
year

Question: What is the average amount of floors of the building that is ranked larger than 30, a year prior to 1977 and an address of 100 Van Ness Avenue?
SQL: SELECT AVG("floors") FROM sf_buildings WHERE "rank" > 30 AND "year" < 1977 AND "name" = '100 van ness avenue'

Question: What is the name of the building that has more than 31 floors and built prior to 1964?
SQL: SELECT "name" FROM sf_buildings WHERE "floors" > 31 AND "year" < 1964