target-benchmark/spider-queries huggingface dataset:
Database: wedding (tables: wedding, church)
Question: Show all church names except for those that had a wedding in year 2015.
SQL: SELECT name FROM church EXCEPT SELECT T1.name FROM church AS T1 JOIN wedding AS T2 ON T1.church_id  =  T2.church_id WHERE T2.year  =  2015
Database: wedding (tables: wedding, church)
Question: Show all church names that have hosted least two weddings.
SQL: SELECT T1.name FROM church AS T1 JOIN wedding AS T2 ON T1.church_id  =  T2.church_id GROUP BY T1.church_id HAVING count(*)  >=  2
Database: wedding (tables: people, wedding)
Question: Show the names for all females from Canada having a wedding in year 2016.
SQL: SELECT T2.name FROM wedding AS T1 JOIN people AS T2 ON T1.female_id  =  T2.people_id WHERE T1.year  =  2016 AND T2.is_male  =  'F' AND T2.country  =  'Canada'
Database: wedding (tables: wedding)
Question: How many weddings are there in year 2016?
SQL: SELECT count(*) FROM wedding WHERE YEAR  =  2016
Database: wedding (tables: church, people, wedding)
Question: Show the church names for the weddings of all people older than 30.
SQL: SELECT T4.name FROM wedding AS T1 JOIN people AS T2 ON T1.male_id  =  T2.people_id JOIN people AS T3 ON T1.female_id  =  T3.people_id JOIN church AS T4 ON T4.church_id  =  T1.church_id WHERE T2.age  >  30 OR T3.age  >  30
Database: wedding (tables: people)
Question: Show all countries and the number of people from each country.
SQL: SELECT country ,  count(*) FROM people GROUP BY country
Database: wedding (tables: wedding)
Question: How many churches have a wedding in year 2016?
SQL: SELECT COUNT (DISTINCT church_id) FROM wedding WHERE YEAR  =  2016
Database: theme_gallery (tables: artist)
Question: How many artists do we have?
SQL: SELECT count(*) FROM artist
Database: theme_gallery (tables: artist)
Question: Count the number of artists.
SQL: SELECT count(*) FROM artist
Database: theme_gallery (tables: artist)
Question: Show all artist name, age, and country ordered by the yeared they joined.
SQL: SELECT name ,  age ,  country FROM artist ORDER BY Year_Join
Database: theme_gallery (tables: artist)
Question: What are the names, ages, and countries of artists, sorted by the year they joined?
SQL: SELECT name ,  age ,  country FROM artist ORDER BY Year_Join
Database: theme_gallery (tables: artist)
Question: What are all distinct country for artists?
SQL: SELECT DISTINCT country FROM artist
Database: theme_gallery (tables: artist)
Question: Return the different countries for artists.
SQL: SELECT DISTINCT country FROM artist
Database: theme_gallery (tables: artist)
Question: Show all artist names and the year joined who are not from United States.
SQL: SELECT name ,  year_join FROM artist WHERE country != 'United States'
Database: theme_gallery (tables: artist)
Question: What are the names and year of joining for artists that do not have the country "United States"?
SQL: SELECT name ,  year_join FROM artist WHERE country != 'United States'
Database: theme_gallery (tables: artist)
Question: How many artists are above age 46 and joined after 1990?
SQL: SELECT count(*) FROM artist WHERE age  >  46 AND year_join  >  1990
Database: theme_gallery (tables: artist)
Question: Count the number of artists who are older than 46 and joined after 1990.
SQL: SELECT count(*) FROM artist WHERE age  >  46 AND year_join  >  1990
Database: theme_gallery (tables: artist)
Question: What is the average and minimum age of all artists from United States.
SQL: SELECT avg(age) ,  min(age) FROM artist WHERE country  =  'United States'
Database: theme_gallery (tables: artist)
Question: Return the average and minimum ages across artists from the United States.
SQL: SELECT avg(age) ,  min(age) FROM artist WHERE country  =  'United States'
Database: theme_gallery (tables: artist)
Question: What is the name of the artist who joined latest?
SQL: SELECT name FROM artist ORDER BY year_join DESC LIMIT 1
Database: theme_gallery (tables: artist)
Question: Return the name of the artist who has the latest join year.
SQL: SELECT name FROM artist ORDER BY year_join DESC LIMIT 1
Database: theme_gallery (tables: exhibition)
Question: How many exhibition are there in year 2005 or after?
SQL: SELECT count(*) FROM exhibition WHERE YEAR  >=  2005
Database: theme_gallery (tables: exhibition)
Question: Count the number of exhibitions that happened in or after 2005.
SQL: SELECT count(*) FROM exhibition WHERE YEAR  >=  2005
Database: theme_gallery (tables: exhibition)
Question: Show theme and year for all exhibitions with ticket prices lower than 15.
SQL: SELECT theme ,  YEAR FROM exhibition WHERE ticket_price  <  15
Database: theme_gallery (tables: exhibition)
Question: What are the theme and year for all exhibitions that have a ticket price under 15?
SQL: SELECT theme ,  YEAR FROM exhibition WHERE ticket_price  <  15
Database: theme_gallery (tables: artist, exhibition)
Question: Show all artist names and the number of exhibitions for each artist.
SQL: SELECT T2.name ,  count(*) FROM exhibition AS T1 JOIN artist AS T2 ON T1.artist_id  =  T2.artist_id GROUP BY T1.artist_id
Database: theme_gallery (tables: artist, exhibition)
Question: How many exhibitions has each artist had?
SQL: SELECT T2.name ,  count(*) FROM exhibition AS T1 JOIN artist AS T2 ON T1.artist_id  =  T2.artist_id GROUP BY T1.artist_id
Database: theme_gallery (tables: artist, exhibition)
Question: What is the name and country for the artist with most number of exhibitions?
SQL: SELECT T2.name , T2.country FROM exhibition AS T1 JOIN artist AS T2 ON T1.artist_id  =  T2.artist_id GROUP BY T1.artist_id ORDER BY count(*) DESC LIMIT 1
Database: theme_gallery (tables: artist, exhibition)
Question: Return the name and country corresponding to the artist who has had the most exhibitions.
SQL: SELECT T2.name , T2.country FROM exhibition AS T1 JOIN artist AS T2 ON T1.artist_id  =  T2.artist_id GROUP BY T1.artist_id ORDER BY count(*) DESC LIMIT 1
Database: theme_gallery (tables: artist, exhibition)
Question: Show names for artists without any exhibition.
SQL: SELECT name FROM artist WHERE artist_id NOT IN (SELECT artist_id FROM exhibition)
Database: theme_gallery (tables: artist, exhibition)
Question: What are the names of artists that have not had any exhibitions?
SQL: SELECT name FROM artist WHERE artist_id NOT IN (SELECT artist_id FROM exhibition)
Database: theme_gallery (tables: artist, exhibition)
Question: What is the theme and artist name for the exhibition with a ticket price higher than the average?
SQL: SELECT T1.theme ,  T2.name FROM exhibition AS T1 JOIN artist AS T2 ON T1.artist_id  =  T2.artist_id WHERE T1.ticket_price  >  (SELECT avg(ticket_price) FROM exhibition)
Database: theme_gallery (tables: artist, exhibition)
Question: Return the names of artists and the themes of their exhibitions that had a ticket price higher than average.
SQL: SELECT T1.theme ,  T2.name FROM exhibition AS T1 JOIN artist AS T2 ON T1.artist_id  =  T2.artist_id WHERE T1.ticket_price  >  (SELECT avg(ticket_price) FROM exhibition)
Database: theme_gallery (tables: exhibition)
Question: Show the average, minimum, and maximum ticket prices for exhibitions for all years before 2009.
SQL: SELECT avg(ticket_price) ,  min(ticket_price) ,  max(ticket_price) FROM exhibition WHERE YEAR  <  2009
Database: theme_gallery (tables: exhibition)
Question: What are the average, minimum, and maximum ticket prices for exhibitions that happened prior to 2009?
SQL: SELECT avg(ticket_price) ,  min(ticket_price) ,  max(ticket_price) FROM exhibition WHERE YEAR  <  2009
Database: theme_gallery (tables: exhibition)
Question: Show theme and year for all exhibitions in an descending order of ticket price.
SQL: SELECT theme ,  YEAR FROM exhibition ORDER BY ticket_price DESC
Database: theme_gallery (tables: exhibition)
Question: What are the themes and years for exhibitions, sorted by ticket price descending?
SQL: SELECT theme ,  YEAR FROM exhibition ORDER BY ticket_price DESC
Database: theme_gallery (tables: exhibition_record, exhibition)
Question: What is the theme, date, and attendance for the exhibition in year 2004?
SQL: SELECT T2.theme ,  T1.date ,  T1.attendance FROM exhibition_record AS T1 JOIN exhibition AS T2 ON T1.exhibition_id  =  T2.exhibition_id WHERE T2.year  =  2004
Database: theme_gallery (tables: exhibition_record, exhibition)
Question: Return the themes, dates, and attendance for exhibitions that happened in 2004.
SQL: SELECT T2.theme ,  T1.date ,  T1.attendance FROM exhibition_record AS T1 JOIN exhibition AS T2 ON T1.exhibition_id  =  T2.exhibition_id WHERE T2.year  =  2004
Database: theme_gallery (tables: artist, exhibition)
Question: Show all artist names who didn't have an exhibition in 2004.
SQL: SELECT name FROM artist EXCEPT SELECT T2.name FROM exhibition AS T1 JOIN artist AS T2 ON T1.artist_id  =  T2.artist_id WHERE T1.year  =  2004
Database: theme_gallery (tables: artist, exhibition)
Question: What are the names of artists who did not have an exhibition in 2004?
SQL: SELECT name FROM artist EXCEPT SELECT T2.name FROM exhibition AS T1 JOIN artist AS T2 ON T1.artist_id  =  T2.artist_id WHERE T1.year  =  2004
Database: theme_gallery (tables: exhibition_record, exhibition)
Question: Show the theme for exhibitions with both records of an attendance below 100 and above 500.
SQL: SELECT T2.theme FROM exhibition_record AS T1 JOIN exhibition AS T2 ON T1.exhibition_id  =  T2.exhibition_id WHERE T1.attendance  <  100 INTERSECT SELECT T2.theme FROM exhibition_record AS T1 JOIN exhibition AS T2 ON T1.exhibition_id  =  T2.exhibition_id WHERE T1.attendance  >  500
Database: theme_gallery (tables: exhibition_record, exhibition)
Question: Which themes have had corresponding exhibitions that have had attendance both below 100 and above 500?
SQL: SELECT T2.theme FROM exhibition_record AS T1 JOIN exhibition AS T2 ON T1.exhibition_id  =  T2.exhibition_id WHERE T1.attendance  <  100 INTERSECT SELECT T2.theme FROM exhibition_record AS T1 JOIN exhibition AS T2 ON T1.exhibition_id  =  T2.exhibition_id WHERE T1.attendance  >  500
Database: theme_gallery (tables: exhibition_record, exhibition)
Question: How many exhibitions have a attendance more than 100 or have a ticket price below 10?
SQL: SELECT count(*) FROM exhibition_record AS T1 JOIN exhibition AS T2 ON T1.exhibition_id  =  T2.exhibition_id WHERE T1.attendance  >  100 OR T2.ticket_price  <  10
Database: theme_gallery (tables: exhibition_record, exhibition)
Question: Count the number of exhibitions that have had an attendnance of over 100 or a ticket prices under 10.
SQL: SELECT count(*) FROM exhibition_record AS T1 JOIN exhibition AS T2 ON T1.exhibition_id  =  T2.exhibition_id WHERE T1.attendance  >  100 OR T2.ticket_price  <  10
Database: theme_gallery (tables: exhibition_record, artist, exhibition)
Question: Show all artist names with an average exhibition attendance over 200.
SQL: SELECT T3.name FROM exhibition_record AS T1 JOIN exhibition AS T2 ON T1.exhibition_id  =  T2.exhibition_id JOIN artist AS T3 ON T3.artist_id  =  T2.artist_id GROUP BY T3.artist_id HAVING avg(T1.attendance)  >  200
Database: theme_gallery (tables: exhibition_record, artist, exhibition)
Question: What are the names of artist whose exhibitions draw over 200 attendees on average?
SQL: SELECT T3.name FROM exhibition_record AS T1 JOIN exhibition AS T2 ON T1.exhibition_id  =  T2.exhibition_id JOIN artist AS T3 ON T3.artist_id  =  T2.artist_id GROUP BY T3.artist_id HAVING avg(T1.attendance)  >  200
Database: epinions_1 (tables: item)
Question: Find the id of the item whose title is "orange".
SQL: SELECT i_id FROM item WHERE title  =  "orange"
Database: epinions_1 (tables: item)
Question: List all information in the item table.
SQL: SELECT * FROM item
Database: epinions_1 (tables: review)
Question: Find the number of reviews.
SQL: SELECT count(*) FROM review
Database: epinions_1 (tables: useracct)
Question: How many users are there?
SQL: SELECT count(*) FROM useracct
Database: epinions_1 (tables: review)
Question: Find the average and maximum rating of all reviews.
SQL: SELECT avg(rating) ,  max(rating) FROM review
Database: epinions_1 (tables: review)
Question: Find the highest rank of all reviews.
SQL: SELECT min(rank) FROM review
Database: epinions_1 (tables: review)
Question: How many different users wrote some reviews?
SQL: SELECT count(DISTINCT u_id) FROM review
Database: epinions_1 (tables: review)
Question: How many different items were reviewed by some users?
SQL: SELECT count(DISTINCT i_id) FROM review
Database: epinions_1 (tables: item, review)
Question: Find the number of items that did not receive any review.
SQL: SELECT count(*) FROM item WHERE i_id NOT IN (SELECT i_id FROM review)
Database: epinions_1 (tables: useracct, review)
Question: Find the names of users who did not leave any review.
SQL: SELECT name FROM useracct WHERE u_id NOT IN (SELECT u_id FROM review)
Database: epinions_1 (tables: item, review)
Question: Find the names of goods that receive a rating of 10.
SQL: SELECT T1.title FROM item AS T1 JOIN review AS T2 ON T1.i_id  =  T2.i_id WHERE T2.rating  =  10
Database: epinions_1 (tables: item, review)
Question: Find the titles of items whose rating is higher than the average review rating of all items.
SQL: SELECT T1.title FROM item AS T1 JOIN review AS T2 ON T1.i_id  =  T2.i_id WHERE T2.rating  >  (SELECT avg(rating) FROM review)
Database: epinions_1 (tables: item, review)
Question: Find the titles of items that received any rating below 5.
SQL: SELECT T1.title FROM item AS T1 JOIN review AS T2 ON T1.i_id  =  T2.i_id WHERE T2.rating  <  5
Database: epinions_1 (tables: item, review)
Question: Find the titles of items that received both a rating higher than 8 and a rating below 5.
SQL: SELECT T1.title FROM item AS T1 JOIN review AS T2 ON T1.i_id  =  T2.i_id WHERE T2.rating  >  8 INTERSECT SELECT T1.title FROM item AS T1 JOIN review AS T2 ON T1.i_id  =  T2.i_id WHERE T2.rating  <  5
Database: epinions_1 (tables: item, review)
Question: Find the names of items whose rank is higher than 3 and whose average rating is above 5.
SQL: SELECT T1.title FROM item AS T1 JOIN review AS T2 ON T1.i_id  =  T2.i_id WHERE T2.rank  >  3 INTERSECT SELECT T1.title FROM item AS T1 JOIN review AS T2 ON T1.i_id  =  T2.i_id GROUP BY T2.i_id HAVING avg(T2.rating)  >  5
Database: epinions_1 (tables: item, review)
Question: Find the name of the item with the lowest average rating.
SQL: SELECT T1.title FROM item AS T1 JOIN review AS T2 ON T1.i_id  =  T2.i_id GROUP BY T2.i_id ORDER BY avg(T2.rating) LIMIT 1
Database: epinions_1 (tables: item)
Question: List the titles of all items in alphabetic order .
SQL: SELECT title FROM item ORDER BY title
Database: epinions_1 (tables: review, useracct)
Question: Find the name of the user who gives the most reviews.
SQL: SELECT T1.name FROM useracct AS T1 JOIN review AS T2 ON T1.u_id  =  T2.u_id GROUP BY T2.u_id ORDER BY count(*) DESC LIMIT 1
Database: epinions_1 (tables: item, review)
Question: Find the name and id of the item with the highest average rating.
SQL: SELECT T1.title ,  T1.i_id FROM item AS T1 JOIN review AS T2 ON T1.i_id  =  T2.i_id GROUP BY T2.i_id ORDER BY avg(T2.rating) DESC LIMIT 1
Database: epinions_1 (tables: item, review)
Question: Find the name and id of the good with the highest average rank.
SQL: SELECT T1.title ,  T1.i_id FROM item AS T1 JOIN review AS T2 ON T1.i_id  =  T2.i_id GROUP BY T2.i_id ORDER BY avg(T2.rank) DESC LIMIT 1
Database: epinions_1 (tables: review, useracct)
Question: For each user, return the name and the average rating of reviews given by them.
SQL: SELECT T1.name ,  avg(T2.rating) FROM useracct AS T1 JOIN review AS T2 ON T1.u_id  =  T2.u_id GROUP BY T2.u_id
Database: epinions_1 (tables: review, useracct)
Question: For each user, find their name and the number of reviews written by them.
SQL: SELECT T1.name ,  count(*) FROM useracct AS T1 JOIN review AS T2 ON T1.u_id  =  T2.u_id GROUP BY T2.u_id
Database: epinions_1 (tables: review, useracct)
Question: Find the name of the user who gave the highest rating.
SQL: SELECT T1.name FROM useracct AS T1 JOIN review AS T2 ON T1.u_id  =  T2.u_id ORDER BY T2.rating DESC LIMIT 1
Database: epinions_1 (tables: trust, useracct)
Question: Find the name of the source user with the highest average trust score.
SQL: SELECT T1.name FROM useracct AS T1 JOIN trust AS T2 ON T1.u_id  =  T2.source_u_id GROUP BY T2.source_u_id ORDER BY avg(trust) DESC LIMIT 1
Database: epinions_1 (tables: trust, useracct)
Question: Find each target user's name and average trust score.
SQL: SELECT T1.name ,  avg(trust) FROM useracct AS T1 JOIN trust AS T2 ON T1.u_id  =  T2.target_u_id GROUP BY T2.target_u_id
Database: epinions_1 (tables: trust, useracct)
Question: Find the name of the target user with the lowest trust score.
SQL: SELECT T1.name FROM useracct AS T1 JOIN trust AS T2 ON T1.u_id  =  T2.target_u_id ORDER BY trust LIMIT 1
Database: epinions_1 (tables: item, review)
Question: Find the names of the items that did not receive any review.
SQL: SELECT title FROM item WHERE i_id NOT IN (SELECT i_id FROM review)
Database: epinions_1 (tables: useracct, review)
Question: Find the number of users who did not write any review.
SQL: SELECT count(*) FROM useracct WHERE u_id NOT IN (SELECT u_id FROM review)
Database: epinions_1 (tables: item, review)
Question: Find the number of items without any review.
SQL: SELECT count(*) FROM item WHERE i_id NOT IN (SELECT i_id FROM review)
Database: riding_club (tables: player)
Question: How many players are there?
SQL: SELECT count(*) FROM player
Database: riding_club (tables: player)
Question: List the names of players in ascending order of votes.
SQL: SELECT Player_name FROM player ORDER BY Votes ASC
Database: riding_club (tables: player)
Question: What are the gender and occupation of players?
SQL: SELECT Gender ,  Occupation FROM player
Database: riding_club (tables: player)
Question: List the name and residence for players whose occupation is not "Researcher".
SQL: SELECT Player_name ,  residence FROM player WHERE Occupation != "Researcher"
Database: riding_club (tables: player)
Question: Show the names of sponsors of players whose residence is either "Brandon" or "Birtle".
SQL: SELECT Sponsor_name FROM player WHERE Residence  =  "Brandon" OR Residence  =  "Birtle"
Database: riding_club (tables: player)
Question: What is the name of the player with the largest number of votes?
SQL: SELECT Player_name FROM player ORDER BY Votes DESC LIMIT 1
Database: riding_club (tables: player)
Question: Show different occupations along with the number of players in each occupation.
SQL: SELECT Occupation ,  COUNT(*) FROM player GROUP BY Occupation
Database: riding_club (tables: player)
Question: Please show the most common occupation of players.
SQL: SELECT Occupation FROM player GROUP BY Occupation ORDER BY COUNT(*) DESC LIMIT 1
Database: riding_club (tables: player)
Question: Show the residences that have at least two players.
SQL: SELECT Residence FROM player GROUP BY Residence HAVING COUNT(*)  >=  2
Database: riding_club (tables: player_coach, coach, player)
Question: Show the names of players and names of their coaches.
SQL: SELECT T3.Player_name ,  T2.coach_name FROM player_coach AS T1 JOIN coach AS T2 ON T1.Coach_ID  =  T2.Coach_ID JOIN player AS T3 ON T1.Player_ID  =  T3.Player_ID
Database: riding_club (tables: player_coach, coach, player)
Question: Show the names of players coached by the rank 1 coach.
SQL: SELECT T3.Player_name FROM player_coach AS T1 JOIN coach AS T2 ON T1.Coach_ID  =  T2.Coach_ID JOIN player AS T3 ON T1.Player_ID  =  T3.Player_ID WHERE T2.Rank  =  1
Database: riding_club (tables: player_coach, coach, player)
Question: Show the names and genders of players with a coach starting after 2011.
SQL: SELECT T3.Player_name ,  T3.gender FROM player_coach AS T1 JOIN coach AS T2 ON T1.Coach_ID  =  T2.Coach_ID JOIN player AS T3 ON T1.Player_ID  =  T3.Player_ID WHERE T1.Starting_year  >  2011
Database: riding_club (tables: player_coach, coach, player)
Question: Show the names of players and names of their coaches in descending order of the votes of players.
SQL: SELECT T3.Player_name ,  T2.coach_name FROM player_coach AS T1 JOIN coach AS T2 ON T1.Coach_ID  =  T2.Coach_ID JOIN player AS T3 ON T1.Player_ID  =  T3.Player_ID ORDER BY T3.Votes DESC
Database: riding_club (tables: player_coach, player)
Question: List the names of players that do not have coaches.
SQL: SELECT Player_name FROM player WHERE Player_ID NOT IN (SELECT Player_ID FROM player_coach)
Database: riding_club (tables: player)
Question: Show the residences that have both a player of gender "M" and a player of gender "F".
SQL: SELECT Residence FROM player WHERE gender  =  "M" INTERSECT SELECT Residence FROM player WHERE gender  =  "F"
Database: riding_club (tables: coach, club)
Question: How many coaches does each club has? List the club id, name and the number of coaches.
SQL: SELECT T1.club_id ,  T1.club_name, count(*) FROM club AS T1 JOIN coach AS T2 ON T1.club_id  =  T2.club_id GROUP BY T1.club_id
Database: riding_club (tables: match_result, coach)
Question: How many gold medals has the club with the most coaches won?
SQL: SELECT T1.club_id ,  T1.gold FROM match_result AS T1 JOIN coach AS T2 ON T1.club_id  =  T2.club_id GROUP BY T1.club_id ORDER BY count(*) DESC LIMIT 1
Database: gymnast (tables: gymnast)
Question: How many gymnasts are there?
SQL: SELECT count(*) FROM gymnast
Database: gymnast (tables: gymnast)
Question: Count the number of gymnasts.
SQL: SELECT count(*) FROM gymnast
Database: gymnast (tables: gymnast)
Question: List the total points of gymnasts in descending order.
SQL: SELECT Total_Points FROM gymnast ORDER BY Total_Points DESC
Database: gymnast (tables: gymnast)
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
Database: gymnast (tables: gymnast)
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
Database: gymnast (tables: gymnast)
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
Database: gymnast (tables: gymnast)
Question: What is the average horizontal bar points for all gymnasts?
SQL: SELECT avg(Horizontal_Bar_Points) FROM gymnast
Database: gymnast (tables: gymnast)
Question: Return the average horizontal bar points across all gymnasts.
SQL: SELECT avg(Horizontal_Bar_Points) FROM gymnast
Database: gymnast (tables: people)
Question: What are the names of people in ascending alphabetical order?
SQL: SELECT Name FROM People ORDER BY Name ASC
Database: gymnast (tables: people)
Question: Return the names of people, ordered alphabetically.
SQL: SELECT Name FROM People ORDER BY Name ASC
Database: gymnast (tables: gymnast, people)
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
Database: gymnast (tables: gymnast, people)
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
Database: gymnast (tables: gymnast, people)
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"
Database: gymnast (tables: gymnast, people)
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"
Database: gymnast (tables: people)
Question: What is the age of the tallest person?
SQL: SELECT Age FROM people ORDER BY Height DESC LIMIT 1
Database: gymnast (tables: people)
Question: Return the age of the person with the greatest height.
SQL: SELECT Age FROM people ORDER BY Height DESC LIMIT 1
Database: gymnast (tables: people)
Question: List the names of the top 5 oldest people.
SQL: SELECT Name FROM People ORDER BY Age DESC LIMIT 5
Database: gymnast (tables: people)
Question: What are the names of the five oldest people?
SQL: SELECT Name FROM People ORDER BY Age DESC LIMIT 5