Return the names of the gymnasts.
SELECT T2.Name FROM gymnast AS T1 JOIN people AS T2 ON T1.Gymnast_ID  =  T2.People_ID
names of the gymnasts requires joining gymnast table with people table based on Gymnast_ID and People_ID;