hi. what is the average capacity of the stadiums?
select avg ( capacity ) from stadium
and how many stadiums are there whose capacity is smaller than the average capacity?
select count ( * ) from stadium where capacity < ( select avg ( capacity ) from stadium )
what are their names?
select name from stadium where capacity < ( select avg ( capacity ) from stadium )