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
Hello there! Can you list all of the hometowns listed in this database?
assistant
SELECT DISTINCT Hometown FROM people;
human
Thank you for that information! Can you filter that list to show just the hometowns for gymnasts whose total points are more than 57.5?
assistant
SELECT DISTINCT T2.Hometown FROM gymnast AS T1 JOIN people AS T2 ON T1.Gymnast_ID = T2.People_ID WHERE T1.Total_Points > 57.5;
human
Thank you! Can you show all of the names of the gymnasts for those hometowns?
assistant
SELECT name FROM people WHERE Hometown = "Santo Domingo" OR Hometown = "Bonao" ;