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
names of the gymnasts refers to t2.name; ascending order by their heights refers to ORDER BY t2.Height ASC; gymnast ID links gymnast table to people table refers to T1.Gymnast_ID = T2.People_ID;