How many stadiums are there in the system?
select count(*) from stadium
What are their names?
select name from stadium
Give me their capacities.
select name, capacity from stadium
What is the average capacity?
select avg(capacity) from stadium
Show me the stadiums whose capacity is smaller than that.
select name from stadium where capacity < (select avg(capacity) from stadium)