show the maximum number of floors for all buildings?
select max ( floors ) from building
Show me the name of the building with building id 1?
select name from building where building_id = '1'
Show me the name of the building with 12 floors?
select name from building where floors = 12
Show me the average and minimum number of floors for all buildings?
select avg ( floors ), min ( floors ) from building