Table: pittsburgh_buildings
Columns: rank
name
height_ft_m
floors
year

Question: Name the height when the floors are bigger than 30 at the bny mellon center
SQL: SELECT "height_ft_m" FROM pittsburgh_buildings WHERE "floors" > 30 AND "name" = 'bny mellon center'

Question: Tell me the name for rank of 27= and years before 1964
SQL: SELECT "name" FROM pittsburgh_buildings WHERE "rank" = '27=' AND "year" < 1964

Question: Name the year for 8 rank
SQL: SELECT "year" FROM pittsburgh_buildings WHERE "rank" = '8'