Who is the tallest?
select name from people order by height desc limit 1
Who is the oldest gymnast?
select t2.name from gymnast as t1 join people as t2 on t1.gymnast_id = t2.people_id order by age desc limit 1
Please show the top 5 oldest gymnasts.
select t2.name from gymnast as t1 join people as t2 on t1.gymnast_id = t2.people_id order by age desc limit 5
How about the top 5 oldest people?
select name from people order by age desc limit 5