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
tallest refers to MAX(Height); gymnast's name refers to joining the gymnast table with the people table on a common ID and then selecting the Name from the people table.