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 tall is Nadia Caba Rodríguez?
select height from people where name = 'Nadia caba Rodríguez'
Great, can you list the names of the 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