Table: tallest_birmingham_buildings
Columns: rank
name
height_m
height_ft
floors

Question: What is the Height (ft) of the Churchill House with a Height (m) less than 59?
SQL: SELECT COUNT("height_ft") FROM tallest_birmingham_buildings WHERE "name" = 'churchill house' AND "height_m" < 59

Question: What is the Height of the Canterbury House with 12 Floors and a Rank of 75=?
SQL: SELECT AVG("height_ft") FROM tallest_birmingham_buildings WHERE "floors" = '12' AND "rank" = '75=' AND "name" = 'canterbury house'

Question: What is the Height (m) of the 32= Rank Building with 18 Floors and Height (ft) greater than 171?
SQL: SELECT AVG("height_m") FROM tallest_birmingham_buildings WHERE "floors" = '18' AND "height_ft" > 171 AND "rank" = '32='