Database: gymnast

CREATE TABLE "gymnast" (
"Gymnast_ID" int,
"Floor_Exercise_Points" real,
"Pommel_Horse_Points" real,
"Rings_Points" real,
"Vault_Points" real,
"Parallel_Bars_Points" real,
"Horizontal_Bar_Points" real,
"Total_Points" real,
PRIMARY KEY ("Gymnast_ID"),
FOREIGN KEY ("Gymnast_ID") REFERENCES "people"("People_ID")
);
CREATE TABLE "people" (
"People_ID" int,
"Name" text,
"Age" real,
"Height" real,
"Hometown" text,
PRIMARY KEY ("People_ID")
);

Question: How many gymnasts are there?
SQL: SELECT count(*) FROM gymnast

Question: Count the number of gymnasts.
SQL: SELECT count(*) FROM gymnast

Question: List the total points of gymnasts in descending order.
SQL: SELECT Total_Points FROM gymnast ORDER BY Total_Points DESC

Question: What are the total points for all gymnasts, ordered by total points descending?
SQL: SELECT Total_Points FROM gymnast ORDER BY Total_Points DESC

Question: List the total points of gymnasts in descending order of floor exercise points.
SQL: SELECT Total_Points FROM gymnast ORDER BY Floor_Exercise_Points DESC

Question: What are the total points of gymnasts, ordered by their floor exercise points descending?
SQL: SELECT Total_Points FROM gymnast ORDER BY Floor_Exercise_Points DESC

Question: What is the average horizontal bar points for all gymnasts?
SQL: SELECT avg(Horizontal_Bar_Points) FROM gymnast

Question: Return the average horizontal bar points across all gymnasts.
SQL: SELECT avg(Horizontal_Bar_Points) FROM gymnast

Question: What are the names of people in ascending alphabetical order?
SQL: SELECT Name FROM People ORDER BY Name ASC

Question: Return the names of people, ordered alphabetically.
SQL: SELECT Name FROM People ORDER BY Name ASC

Question: What are the names of gymnasts?
SQL: SELECT T2.Name FROM gymnast AS T1 JOIN people AS T2 ON T1.Gymnast_ID  =  T2.People_ID

Question: Return the names of the gymnasts.
SQL: SELECT T2.Name FROM gymnast AS T1 JOIN people AS T2 ON T1.Gymnast_ID  =  T2.People_ID

Question: What are the names of gymnasts whose hometown is not "Santo Domingo"?
SQL: SELECT T2.Name FROM gymnast AS T1 JOIN people AS T2 ON T1.Gymnast_ID  =  T2.People_ID WHERE T2.Hometown != "Santo Domingo"

Question: Return the names of gymnasts who did not grow up in Santo Domingo.
SQL: SELECT T2.Name FROM gymnast AS T1 JOIN people AS T2 ON T1.Gymnast_ID  =  T2.People_ID WHERE T2.Hometown != "Santo Domingo"

Question: What is the age of the tallest person?
SQL: SELECT Age FROM people ORDER BY Height DESC LIMIT 1

Question: Return the age of the person with the greatest height.
SQL: SELECT Age FROM people ORDER BY Height DESC LIMIT 1

Question: List the names of the top 5 oldest people.
SQL: SELECT Name FROM People ORDER BY Age DESC LIMIT 5

Question: What are the names of the five oldest people?
SQL: SELECT Name FROM People ORDER BY Age DESC LIMIT 5

Question: What is the total point count of the youngest gymnast?
SQL: SELECT T1.Total_Points FROM gymnast AS T1 JOIN people AS T2 ON T1.Gymnast_ID  =  T2.People_ID ORDER BY T2.Age ASC LIMIT 1

Question: Return the total points of the gymnast with the lowest age.
SQL: SELECT T1.Total_Points FROM gymnast AS T1 JOIN people AS T2 ON T1.Gymnast_ID  =  T2.People_ID ORDER BY T2.Age ASC LIMIT 1

Question: What is the average age of all gymnasts?
SQL: SELECT avg(T2.Age) FROM gymnast AS T1 JOIN people AS T2 ON T1.Gymnast_ID  =  T2.People_ID

Question: Return the average age across all gymnasts.
SQL: SELECT avg(T2.Age) FROM gymnast AS T1 JOIN people AS T2 ON T1.Gymnast_ID  =  T2.People_ID

Question: What are the distinct hometowns of gymnasts with total points more than 57.5?
SQL: 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

Question: Give the different hometowns of gymnasts that have a total point score of above 57.5.
SQL: 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

Question: What are the hometowns of gymnasts and the corresponding number of gymnasts?
SQL: SELECT T2.Hometown ,  COUNT(*) FROM gymnast AS T1 JOIN people AS T2 ON T1.Gymnast_ID  =  T2.People_ID GROUP BY T2.Hometown

Question: How many gymnasts are from each hometown?
SQL: SELECT T2.Hometown ,  COUNT(*) FROM gymnast AS T1 JOIN people AS T2 ON T1.Gymnast_ID  =  T2.People_ID GROUP BY T2.Hometown

Question: What is the most common hometown of gymnasts?
SQL: SELECT T2.Hometown FROM gymnast AS T1 JOIN people AS T2 ON T1.Gymnast_ID  =  T2.People_ID GROUP BY T2.Hometown ORDER BY COUNT(*) DESC LIMIT 1

Question: Return the hometown that is most common among gymnasts.
SQL: SELECT T2.Hometown FROM gymnast AS T1 JOIN people AS T2 ON T1.Gymnast_ID  =  T2.People_ID GROUP BY T2.Hometown ORDER BY COUNT(*) DESC LIMIT 1

Question: What are the hometowns that are shared by at least two gymnasts?
SQL: SELECT T2.Hometown FROM gymnast AS T1 JOIN people AS T2 ON T1.Gymnast_ID  =  T2.People_ID GROUP BY T2.Hometown HAVING COUNT(*)  >=  2

Question: Give the hometowns from which two or more gymnasts are from.
SQL: SELECT T2.Hometown FROM gymnast AS T1 JOIN people AS T2 ON T1.Gymnast_ID  =  T2.People_ID GROUP BY T2.Hometown HAVING COUNT(*)  >=  2

Question: List the names of gymnasts in ascending order by their heights.
SQL: SELECT T2.Name FROM gymnast AS T1 JOIN people AS T2 ON T1.Gymnast_ID  =  T2.People_ID ORDER BY T2.Height ASC

Question: What are the names of gymnasts, ordered by their heights ascending?
SQL: SELECT T2.Name FROM gymnast AS T1 JOIN people AS T2 ON T1.Gymnast_ID  =  T2.People_ID ORDER BY T2.Height ASC

Question: List the distinct hometowns that are not associated with any gymnast.
SQL: 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

Question: From which hometowns did no gymnasts come from?
SQL: 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

Question: Show the hometowns shared by people older than 23 and younger than 20.
SQL: SELECT Hometown FROM people WHERE Age  >  23 INTERSECT SELECT Hometown FROM people WHERE Age  <  20

Question: From which hometowns did both people older than 23 and younger than 20 come from?
SQL: SELECT Hometown FROM people WHERE Age  >  23 INTERSECT SELECT Hometown FROM people WHERE Age  <  20

Question: How many distinct hometowns did these people have?
SQL: SELECT count(DISTINCT Hometown) FROM people

Question: Count the number of different hometowns of these people.
SQL: SELECT count(DISTINCT Hometown) FROM people

Question: Show the ages of gymnasts in descending order of total points.
SQL: SELECT T2.Age FROM gymnast AS T1 JOIN people AS T2 ON T1.Gymnast_ID  =  T2.People_ID ORDER BY T1.Total_Points DESC

Question: What are the ages of the gymnasts, ordered descending by their total points?
SQL: SELECT T2.Age FROM gymnast AS T1 JOIN people AS T2 ON T1.Gymnast_ID  =  T2.People_ID ORDER BY T1.Total_Points DESC