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! Can you show me a list of all of the hometowns?
assistant
SELECT Hometown FROM people;
human
Thank you! Can you filter this list ot show only the hometowns that have both people older than 23 years of age and people younger than 20 years of age?
assistant
SELECT Hometown FROM people WHERE Age > 23 INTERSECT SELECT Hometown FROM people WHERE Age < 20 ;