What are the names of gymnasts?
SELECT T2.Name FROM gymnast AS T1 JOIN people AS T2 ON T1.Gymnast_ID  =  T2.People_ID
names of gymnasts refers to joining gymnast table with people table on Gymnast_ID = People_ID and selecting Name from the people table;