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
how many people are there
assistant
SELECT COUNT( * ) FROM people;
human
how many are under age 21
assistant
SELECT COUNT( * ) FROM people WHERE Age < 21;
human
how many are from same hometown | Santo Domingo is the only hometown where more than 1 person is from. There are 5 people from the hometown San Domingo. | what is the name of people ID 2
assistant
SELECT Name FROM people WHERE People_ID = 2 ;