What is the average height of all people?
select avg(height) from people
How about the average height of gymnasts?
select avg(t2.height) from gymnast as t1 join people as t2 on t1.gymnast_id = t2.people_id
How old is the tallest among all people?
select age from people order by height desc limit 1