human
Schema:
gymnast (Gymnast_ID, Floor_Exercise_Points, Pommel_Horse_Points, Rings_Points, Vault_Points, Parallel_Bars_Points, Horizontal_Bar_Points, Total_Points)
people (People_ID, Name, Age, Height, Hometown)
Please answer with SQL.
assistant
Sure, I understand.
human
What is the average Floor Exercise Points of gymnasts?
assistant
SELECT AVG ( Floor_Exercise_Points ) FROM gymnast;
human
Please show the hometowns of the gymnasts.
assistant
SELECT T2.Hometown FROM gymnast AS T1 JOIN people AS T2 ON T1.Gymnast_ID = T2.People_ID;
human
Please show the hometowns of all people.
assistant
SELECT Hometown FROM people;
human
What are the distinct hometowns that do not have any gymnasts?
assistant
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 ;