Table: shanghai_buildings
Columns: rank
name
height_m_ft
floors
year

Question: What is the number of floors for the Citic Square?
SQL: SELECT AVG("floors") FROM shanghai_buildings WHERE "name" = 'citic square'

Question: What is the height for the Shanghai World Plaza?
SQL: SELECT "height_m_ft" FROM shanghai_buildings WHERE "name" = 'shanghai world plaza'