How many floors does each building name have?
select name, floors from building
What is the average?
select avg(floors) from building
Give statistics about the avg, max, and min.
select avg(floors), max(floors), min(floors) from building