Table: uk_tallest_buildings
Columns: rank
name
city
region
height_m
height_ft
floors
estimated_completion

Question: what's the height (ft) with name being leadenhall building
SQL: SELECT "height_ft" FROM uk_tallest_buildings WHERE "name" = 'Leadenhall Building'

Question: what's the height (ft) with name being 52-54 lime street
SQL: SELECT "height_ft" FROM uk_tallest_buildings WHERE "name" = '52-54 Lime Street'

Question:  how many city with name being providence tower
SQL: SELECT COUNT("city") FROM uk_tallest_buildings WHERE "name" = 'Providence Tower'