What are the names of gymnasts, ordered by their heights ascending?
SELECT T2.Name FROM gymnast AS T1 JOIN people AS T2 ON T1.Gymnast_ID  =  T2.People_ID ORDER BY T2.Height ASC
names of gymnasts = SELECT T2.Name; ordered by their heights ascending = ORDER BY T2.Height ASC; gymnasts are represented in a table that needs to be joined with a people table to get names = JOIN people AS T2 ON T1.Gymnast_ID = T2.People_ID;