Who is the tallest gymnast?
select t2.name from gymnast as t1 join people as t2 on t1.gymnast_id = t2.people_id order by t2.height desc limit 1
How about the shortest gymnast?
select t2.name from gymnast as t1 join people as t2 on t1.gymnast_id = t2.people_id order by t2.height asc limit 1
Please show the names of gymnasts in ascending order by their heights.
select t2.name from gymnast as t1 join people as t2 on t1.gymnast_id = t2.people_id order by t2.height asc