What is the average Floor Exercise Points of gymnasts?
select avg(floor_exercise_points) from gymnast
Please show the hometowns of the gymnasts.
select t2.hometown from gymnast as t1 join people as t2 on t1.gymnast_id = t2.people_id
Please show the hometowns of all people.
select hometown from people
What are the distinct hometowns that do not have any gymnasts?
select distinct hometown from people except select distinct t2.hometown from gymnast as t1 join people as t2 on t1.gymnast_id = t2.people_id