target-benchmark/spider-queries huggingface dataset:
Database: cre_Theme_park (tables: tourist_attractions, photos)
Question: What is the name of the tourist attraction that is associated with the photo "game1"?
SQL: SELECT T2.Name FROM PHOTOS AS T1 JOIN TOURIST_ATTRACTIONS AS T2 ON T1.Tourist_Attraction_ID  =  T2.Tourist_Attraction_ID WHERE T1.Name  =  "game1"
Database: cre_Theme_park (tables: tourist_attractions, photos)
Question: Which tourist attraction is associated with the photo "game1"? Return its name.
SQL: SELECT T2.Name FROM PHOTOS AS T1 JOIN TOURIST_ATTRACTIONS AS T2 ON T1.Tourist_Attraction_ID  =  T2.Tourist_Attraction_ID WHERE T1.Name  =  "game1"
Database: cre_Theme_park (tables: tourist_attractions, photos)
Question: What are the names and descriptions of the photos taken at the tourist attraction "film festival"?
SQL: SELECT T1.Name ,  T1.Description FROM PHOTOS AS T1 JOIN TOURIST_ATTRACTIONS AS T2 ON T1.Tourist_Attraction_ID  =  T2.Tourist_Attraction_ID WHERE T2.Name  =  "film festival"
Database: cre_Theme_park (tables: tourist_attractions, photos)
Question: Find the names and descriptions of the photos taken at the tourist attraction called "film festival".
SQL: SELECT T1.Name ,  T1.Description FROM PHOTOS AS T1 JOIN TOURIST_ATTRACTIONS AS T2 ON T1.Tourist_Attraction_ID  =  T2.Tourist_Attraction_ID WHERE T2.Name  =  "film festival"
Database: cre_Theme_park (tables: tourist_attractions, royal_family)
Question: What are the details and ways to get to tourist attractions related to royal family?
SQL: SELECT T1.Royal_Family_Details ,  T2.How_to_Get_There FROM ROYAL_FAMILY AS T1 JOIN TOURIST_ATTRACTIONS AS T2 ON T1.Royal_Family_ID  =  T2.Tourist_Attraction_ID
Database: cre_Theme_park (tables: tourist_attractions, royal_family)
Question: Which tourist attractions are related to royal family? Tell me their details and how we can get there.
SQL: SELECT T1.Royal_Family_Details ,  T2.How_to_Get_There FROM ROYAL_FAMILY AS T1 JOIN TOURIST_ATTRACTIONS AS T2 ON T1.Royal_Family_ID  =  T2.Tourist_Attraction_ID
Database: cre_Theme_park (tables: tourist_attractions, shops)
Question: What are the details of the shops that can be accessed by walk?
SQL: SELECT T1.Shop_Details FROM SHOPS AS T1 JOIN TOURIST_ATTRACTIONS AS T2 ON T1.Shop_ID  =  T2.Tourist_Attraction_ID WHERE T2.How_to_Get_There  =  "walk"
Database: cre_Theme_park (tables: tourist_attractions, shops)
Question: Find the details of the shops that can be reached by walk.
SQL: SELECT T1.Shop_Details FROM SHOPS AS T1 JOIN TOURIST_ATTRACTIONS AS T2 ON T1.Shop_ID  =  T2.Tourist_Attraction_ID WHERE T2.How_to_Get_There  =  "walk"
Database: cre_Theme_park (tables: tourist_attractions, staff)
Question: What is the name of the staff that is in charge of the attraction named "US museum"?
SQL: SELECT T1.Name FROM STAFF AS T1 JOIN TOURIST_ATTRACTIONS AS T2 ON T1.Tourist_Attraction_ID  =  T2.Tourist_Attraction_ID WHERE T2.Name  =  "US museum"
Database: cre_Theme_park (tables: tourist_attractions, staff)
Question: Tell me the name of the staff in charge of the attraction called "US museum".
SQL: SELECT T1.Name FROM STAFF AS T1 JOIN TOURIST_ATTRACTIONS AS T2 ON T1.Tourist_Attraction_ID  =  T2.Tourist_Attraction_ID WHERE T2.Name  =  "US museum"
Database: cre_Theme_park (tables: tourist_attractions, street_markets)
Question: What are the details of the markets that can be accessed by walk or bus?
SQL: SELECT T1.Market_Details FROM Street_Markets AS T1 JOIN TOURIST_ATTRACTIONS AS T2 ON T1.Market_ID  =  T2.Tourist_Attraction_ID WHERE T2.How_to_Get_There  =  "walk" OR  T2.How_to_Get_There  =  "bus"
Database: cre_Theme_park (tables: tourist_attractions, street_markets)
Question: Find the details of all the markets that are accessible by walk or bus.
SQL: SELECT T1.Market_Details FROM Street_Markets AS T1 JOIN TOURIST_ATTRACTIONS AS T2 ON T1.Market_ID  =  T2.Tourist_Attraction_ID WHERE T2.How_to_Get_There  =  "walk" OR  T2.How_to_Get_There  =  "bus"
Database: cre_Theme_park (tables: visits, visitors)
Question: What are the visit date and details of the visitor whose detail is 'Vincent'?
SQL: SELECT T2.Visit_Date ,  T2.Visit_Details FROM VISITORS AS T1 JOIN VISITS AS T2 ON T1.Tourist_ID  =  T2.Tourist_ID WHERE T1.Tourist_Details  =  "Vincent"
Database: cre_Theme_park (tables: visits, visitors)
Question: Find the visit date and details of the tourist whose detail is 'Vincent'
SQL: SELECT T2.Visit_Date ,  T2.Visit_Details FROM VISITORS AS T1 JOIN VISITS AS T2 ON T1.Tourist_ID  =  T2.Tourist_ID WHERE T1.Tourist_Details  =  "Vincent"
Database: cre_Theme_park (tables: tourist_attractions, visits, visitors)
Question: Which tourist attractions does the visitor with detail 'Vincent' visit?
SQL: SELECT T1.Name FROM Tourist_Attractions AS T1 JOIN VISITS AS T2 ON T1.Tourist_Attraction_ID  =  T2.Tourist_Attraction_ID JOIN VISITORS AS T3 ON T2.Tourist_ID  =  T3.Tourist_ID WHERE T3.Tourist_Details  =  "Vincent"
Database: cre_Theme_park (tables: tourist_attractions, visits, visitors)
Question: Show the tourist attractions visited by the tourist whose detail is 'Vincent'.
SQL: SELECT T1.Name FROM Tourist_Attractions AS T1 JOIN VISITS AS T2 ON T1.Tourist_Attraction_ID  =  T2.Tourist_Attraction_ID JOIN VISITORS AS T3 ON T2.Tourist_ID  =  T3.Tourist_ID WHERE T3.Tourist_Details  =  "Vincent"
Database: cre_Theme_park (tables: tourist_attractions, visits, visitors)
Question: What are the names of the tourist attractions and the dates when the tourists named Vincent or Vivian visited there?
SQL: SELECT T1.Name ,  T3.Visit_Date FROM Tourist_Attractions AS T1 JOIN VISITORS AS T2 JOIN VISITS AS T3 ON T1.Tourist_Attraction_ID  =  T3.Tourist_Attraction_ID AND T2.Tourist_ID  =  T3.Tourist_ID WHERE T2.Tourist_Details  =  "Vincent" OR T2.Tourist_Details  =  "Vivian"
Database: cre_Theme_park (tables: tourist_attractions, visits, visitors)
Question: For each tourist attraction, return its name and the date when the tourists named Vincent or Vivian visited there.
SQL: SELECT T1.Name ,  T3.Visit_Date FROM Tourist_Attractions AS T1 JOIN VISITORS AS T2 JOIN VISITS AS T3 ON T1.Tourist_Attraction_ID  =  T3.Tourist_Attraction_ID AND T2.Tourist_ID  =  T3.Tourist_ID WHERE T2.Tourist_Details  =  "Vincent" OR T2.Tourist_Details  =  "Vivian"
Database: cre_Theme_park (tables: hotels)
Question: Show the average price of hotels for each star rating code.
SQL: SELECT star_rating_code ,  avg(price_range) FROM HOTELS GROUP BY star_rating_code
Database: cre_Theme_park (tables: hotels)
Question: What is the average price range of hotels for each each star rating code?
SQL: SELECT star_rating_code ,  avg(price_range) FROM HOTELS GROUP BY star_rating_code
Database: cre_Theme_park (tables: hotels)
Question: Show the average price of hotels for different pet policy.
SQL: SELECT pets_allowed_yn ,  avg(price_range) FROM HOTELS GROUP BY pets_allowed_yn
Database: cre_Theme_park (tables: hotels)
Question: What are the average prices of hotels grouped by their pet policy.
SQL: SELECT pets_allowed_yn ,  avg(price_range) FROM HOTELS GROUP BY pets_allowed_yn
Database: cre_Theme_park (tables: hotels)
Question: Show the id and star rating of each hotel, ordered by its price from low to high.
SQL: SELECT hotel_id ,  star_rating_code FROM HOTELS ORDER BY price_range ASC
Database: cre_Theme_park (tables: hotels)
Question: Find the id and star rating of each hotel and sort them in increasing order of price.
SQL: SELECT hotel_id ,  star_rating_code FROM HOTELS ORDER BY price_range ASC
Database: cre_Theme_park (tables: hotels)
Question: Show the details of the top 3 most expensive hotels.
SQL: SELECT other_hotel_details FROM HOTELS ORDER BY price_range DESC LIMIT 3
Database: cre_Theme_park (tables: hotels)
Question: What are the details of the three most expensive hotels?
SQL: SELECT other_hotel_details FROM HOTELS ORDER BY price_range DESC LIMIT 3
Database: cre_Theme_park (tables: hotels)
Question: Show the details and star ratings of the 3 least expensive hotels.
SQL: SELECT other_hotel_details ,  star_rating_code FROM HOTELS ORDER BY price_range ASC LIMIT 3
Database: cre_Theme_park (tables: hotels)
Question: What are the details and star ratings of the three hotels with the lowest price ranges?
SQL: SELECT other_hotel_details ,  star_rating_code FROM HOTELS ORDER BY price_range ASC LIMIT 3
Database: cre_Theme_park (tables: tourist_attractions)
Question: Show the transportation method most people choose to get to tourist attractions.
SQL: SELECT How_to_Get_There FROM Tourist_Attractions GROUP BY How_to_Get_There ORDER BY COUNT(*) DESC LIMIT 1
Database: cre_Theme_park (tables: tourist_attractions)
Question: Which transportation method is used the most often to get to tourist attractions?
SQL: SELECT How_to_Get_There FROM Tourist_Attractions GROUP BY How_to_Get_There ORDER BY COUNT(*) DESC LIMIT 1
Database: cre_Theme_park (tables: tourist_attractions, ref_attraction_types)
Question: Show the description and code of the attraction type most tourist attractions belong to.
SQL: SELECT T1.Attraction_Type_Description ,  T2.Attraction_Type_Code FROM Ref_Attraction_Types AS T1 JOIN Tourist_Attractions AS T2 ON T1.Attraction_Type_Code  =  T2.Attraction_Type_Code GROUP BY T2.Attraction_Type_Code ORDER BY COUNT(*) DESC LIMIT 1
Database: cre_Theme_park (tables: tourist_attractions, ref_attraction_types)
Question: Which attraction type does the most tourist attractions belong to? Tell me its  attraction type description and code.
SQL: SELECT T1.Attraction_Type_Description ,  T2.Attraction_Type_Code FROM Ref_Attraction_Types AS T1 JOIN Tourist_Attractions AS T2 ON T1.Attraction_Type_Code  =  T2.Attraction_Type_Code GROUP BY T2.Attraction_Type_Code ORDER BY COUNT(*) DESC LIMIT 1
Database: cre_Theme_park (tables: tourist_attractions)
Question: Show different ways to get to attractions and the number of attractions that can be accessed in the corresponding way.
SQL: SELECT How_to_Get_There ,  COUNT(*) FROM Tourist_Attractions GROUP BY How_to_Get_There
Database: cre_Theme_park (tables: tourist_attractions)
Question: List all the possible ways to get to attractions, together with the number of attractions accessible by these methods.
SQL: SELECT How_to_Get_There ,  COUNT(*) FROM Tourist_Attractions GROUP BY How_to_Get_There
Database: cre_Theme_park (tables: tourist_attractions, visits)
Question: Show different tourist attractions' names, ids, and the corresponding number of visits.
SQL: SELECT T1.Name ,  T2.Tourist_Attraction_ID ,   COUNT(*) FROM Tourist_Attractions AS T1 JOIN VISITS AS T2 ON T1.Tourist_Attraction_ID  =  T2.Tourist_Attraction_ID GROUP BY T2.Tourist_Attraction_ID
Database: cre_Theme_park (tables: tourist_attractions, visits)
Question: What are the name, id and the corresponding number of visits for each  tourist attraction?
SQL: SELECT T1.Name ,  T2.Tourist_Attraction_ID ,   COUNT(*) FROM Tourist_Attractions AS T1 JOIN VISITS AS T2 ON T1.Tourist_Attraction_ID  =  T2.Tourist_Attraction_ID GROUP BY T2.Tourist_Attraction_ID
Database: cre_Theme_park (tables: tourist_attractions, visits)
Question: Show the names and ids of tourist attractions that are visited at least two times.
SQL: SELECT T1.Name ,  T2.Tourist_Attraction_ID FROM Tourist_Attractions AS T1 JOIN VISITS AS T2 ON T1.Tourist_Attraction_ID  =  T2.Tourist_Attraction_ID GROUP BY T2.Tourist_Attraction_ID HAVING count(*)  >=  2
Database: cre_Theme_park (tables: tourist_attractions, visits)
Question: Which tourist attractions are visited at least twice? Give me their names and ids.
SQL: SELECT T1.Name ,  T2.Tourist_Attraction_ID FROM Tourist_Attractions AS T1 JOIN VISITS AS T2 ON T1.Tourist_Attraction_ID  =  T2.Tourist_Attraction_ID GROUP BY T2.Tourist_Attraction_ID HAVING count(*)  >=  2
Database: cre_Theme_park (tables: tourist_attractions, visits)
Question: Show the names and ids of tourist attractions that are visited at most once.
SQL: SELECT T1.Name ,  T1.Tourist_Attraction_ID FROM Tourist_Attractions AS T1 JOIN VISITS AS T2 ON T1.Tourist_Attraction_ID  =  T2.Tourist_Attraction_ID GROUP BY T2.Tourist_Attraction_ID HAVING count(*)  <=  1
Database: cre_Theme_park (tables: tourist_attractions, visits)
Question: What are the names and ids of the tourist attractions that are visited at most once?
SQL: SELECT T1.Name ,  T1.Tourist_Attraction_ID FROM Tourist_Attractions AS T1 JOIN VISITS AS T2 ON T1.Tourist_Attraction_ID  =  T2.Tourist_Attraction_ID GROUP BY T2.Tourist_Attraction_ID HAVING count(*)  <=  1
Database: cre_Theme_park (tables: locations, tourist_attractions)
Question: What are the names of tourist attractions that can be reached by walk or is at address 660 Shea Crescent?
SQL: SELECT T2.Name FROM Locations AS T1 JOIN Tourist_Attractions AS T2 ON T1.Location_ID  =  T2.Location_ID WHERE T1.Address  =  "660 Shea Crescent" OR T2.How_to_Get_There  =  "walk"
Database: cre_Theme_park (tables: locations, tourist_attractions)
Question: Find the names of the tourist attractions that is either accessible by walk or at address 660 Shea Crescent.
SQL: SELECT T2.Name FROM Locations AS T1 JOIN Tourist_Attractions AS T2 ON T1.Location_ID  =  T2.Location_ID WHERE T1.Address  =  "660 Shea Crescent" OR T2.How_to_Get_There  =  "walk"
Database: cre_Theme_park (tables: tourist_attraction_features, tourist_attractions, features)
Question: What are the names of the tourist attractions that have parking or shopping as their feature details?
SQL: SELECT T1.Name FROM Tourist_Attractions AS T1 JOIN Tourist_Attraction_Features AS T2 ON T1.tourist_attraction_id  =  T2.tourist_attraction_id JOIN Features AS T3 ON T2.Feature_ID  =  T3.Feature_ID WHERE T3.feature_Details  =  'park' UNION SELECT T1.Name FROM Tourist_Attractions AS T1 JOIN Tourist_Attraction_Features AS T2 ON T1.tourist_attraction_id  =  T2.tourist_attraction_id JOIN Features AS T3 ON T2.Feature_ID  =  T3.Feature_ID WHERE T3.feature_Details  =  'shopping'
Database: cre_Theme_park (tables: tourist_attraction_features, tourist_attractions, features)
Question: Find the tourist attractions that have parking or shopping as their feature details. What are the names of the attractions?
SQL: SELECT T1.Name FROM Tourist_Attractions AS T1 JOIN Tourist_Attraction_Features AS T2 ON T1.tourist_attraction_id  =  T2.tourist_attraction_id JOIN Features AS T3 ON T2.Feature_ID  =  T3.Feature_ID WHERE T3.feature_Details  =  'park' UNION SELECT T1.Name FROM Tourist_Attractions AS T1 JOIN Tourist_Attraction_Features AS T2 ON T1.tourist_attraction_id  =  T2.tourist_attraction_id JOIN Features AS T3 ON T2.Feature_ID  =  T3.Feature_ID WHERE T3.feature_Details  =  'shopping'
Database: cre_Theme_park (tables: locations, tourist_attractions)
Question: What are the names of tourist attractions that can be reached by bus or is at address 254 Ottilie Junction?
SQL: SELECT T2.Name FROM Locations AS T1 JOIN Tourist_Attractions AS T2 ON T1.Location_ID  =  T2.Location_ID WHERE T1.Address  =  "254 Ottilie Junction" OR T2.How_to_Get_There  =  "bus"
Database: cre_Theme_park (tables: locations, tourist_attractions)
Question: Find the names of the tourist attractions that is either accessible by bus or at address 254 Ottilie Junction.
SQL: SELECT T2.Name FROM Locations AS T1 JOIN Tourist_Attractions AS T2 ON T1.Location_ID  =  T2.Location_ID WHERE T1.Address  =  "254 Ottilie Junction" OR T2.How_to_Get_There  =  "bus"
Database: cre_Theme_park (tables: tourist_attractions, visits, visitors)
Question: What are the names of the tourist attractions Vincent and Marcelle visit?
SQL: SELECT T1.Name FROM Tourist_Attractions AS T1 JOIN VISITORS AS T2 JOIN VISITS AS T3 ON T1.Tourist_Attraction_ID  =  T3.Tourist_Attraction_ID AND T2.Tourist_ID  =  T3.Tourist_ID WHERE T2.Tourist_Details  =  "Vincent" INTERSECT SELECT T1.Name FROM Tourist_Attractions AS T1 JOIN VISITORS AS T2 JOIN VISITS AS T3 ON T1.Tourist_Attraction_ID  =  T3.Tourist_Attraction_ID AND T2.Tourist_ID  =  T3.Tourist_ID WHERE T2.Tourist_Details  =  "Marcelle"
Database: cre_Theme_park (tables: tourist_attractions, visits, visitors)
Question: Which tourist attractions do the tourists Vincent and Marcelle visit? Tell me the names of the attractions.
SQL: SELECT T1.Name FROM Tourist_Attractions AS T1 JOIN VISITORS AS T2 JOIN VISITS AS T3 ON T1.Tourist_Attraction_ID  =  T3.Tourist_Attraction_ID AND T2.Tourist_ID  =  T3.Tourist_ID WHERE T2.Tourist_Details  =  "Vincent" INTERSECT SELECT T1.Name FROM Tourist_Attractions AS T1 JOIN VISITORS AS T2 JOIN VISITS AS T3 ON T1.Tourist_Attraction_ID  =  T3.Tourist_Attraction_ID AND T2.Tourist_ID  =  T3.Tourist_ID WHERE T2.Tourist_Details  =  "Marcelle"
Database: cre_Theme_park (tables: tourist_attractions, visits, visitors)
Question: What are the names of tourist attraction that Alison visited but Rosalind did not visit?
SQL: SELECT T1.Name FROM Tourist_Attractions AS T1 JOIN VISITORS AS T2 JOIN VISITS AS T3 ON T1.Tourist_Attraction_ID  =  T3.Tourist_Attraction_ID AND T2.Tourist_ID  =  T3.Tourist_ID WHERE T2.Tourist_Details  =  "Alison" EXCEPT SELECT T1.Name FROM Tourist_Attractions AS T1 JOIN VISITORS AS T2 JOIN VISITS AS T3 ON T1.Tourist_Attraction_ID  =  T3.Tourist_Attraction_ID AND T2.Tourist_ID  =  T3.Tourist_ID WHERE T2.Tourist_Details  =  "Rosalind"
Database: cre_Theme_park (tables: tourist_attractions, visits, visitors)
Question: Find the the names of the tourist attractions that the tourist named Alison visited but Rosalind did not visit.
SQL: SELECT T1.Name FROM Tourist_Attractions AS T1 JOIN VISITORS AS T2 JOIN VISITS AS T3 ON T1.Tourist_Attraction_ID  =  T3.Tourist_Attraction_ID AND T2.Tourist_ID  =  T3.Tourist_ID WHERE T2.Tourist_Details  =  "Alison" EXCEPT SELECT T1.Name FROM Tourist_Attractions AS T1 JOIN VISITORS AS T2 JOIN VISITS AS T3 ON T1.Tourist_Attraction_ID  =  T3.Tourist_Attraction_ID AND T2.Tourist_ID  =  T3.Tourist_ID WHERE T2.Tourist_Details  =  "Rosalind"
Database: cre_Theme_park (tables: visitors, visits)
Question: How many tourists did not make any visit?
SQL: SELECT count(*) FROM Visitors WHERE Tourist_ID NOT IN ( SELECT Tourist_ID FROM Visits )
Database: cre_Theme_park (tables: visitors, visits)
Question: Count the number of tourists who did not visit any place.
SQL: SELECT count(*) FROM Visitors WHERE Tourist_ID NOT IN ( SELECT Tourist_ID FROM Visits )
Database: game_1 (tables: video_games)
Question: How many video games exist?
SQL: SELECT count(*) FROM Video_games
Database: game_1 (tables: video_games)
Question: How many video games do you have?
SQL: SELECT count(*) FROM Video_games
Database: game_1 (tables: video_games)
Question: How many video game types exist?
SQL: SELECT count(DISTINCT gtype) FROM Video_games
Database: game_1 (tables: video_games)
Question: What is the count of different game types?
SQL: SELECT count(DISTINCT gtype) FROM Video_games
Database: game_1 (tables: video_games)
Question: Show all video game types.
SQL: SELECT DISTINCT gtype FROM Video_games
Database: game_1 (tables: video_games)
Question: What are the different types of video games?
SQL: SELECT DISTINCT gtype FROM Video_games
Database: game_1 (tables: video_games)
Question: Show all video games and their types in the order of their names.
SQL: SELECT gname ,  gtype FROM Video_games ORDER BY gname
Database: game_1 (tables: video_games)
Question: What are the names of all the video games and their types in alphabetical order?
SQL: SELECT gname ,  gtype FROM Video_games ORDER BY gname
Database: game_1 (tables: video_games)
Question: Show all video games with type Collectible card game.
SQL: SELECT gname FROM Video_games WHERE gtype  =  "Collectible card game"
Database: game_1 (tables: video_games)
Question: What are the names of all video games that are collectible cards?
SQL: SELECT gname FROM Video_games WHERE gtype  =  "Collectible card game"
Database: game_1 (tables: video_games)
Question: What is the type of video game Call of Destiny.
SQL: SELECT gtype FROM Video_games WHERE gname  =  "Call of Destiny"
Database: game_1 (tables: video_games)
Question: What type of game is Call of Destiny?
SQL: SELECT gtype FROM Video_games WHERE gname  =  "Call of Destiny"
Database: game_1 (tables: video_games)
Question: How many video games have type Massively multiplayer online game?
SQL: SELECT count(*) FROM Video_games WHERE gtype  =  "Massively multiplayer online game"
Database: game_1 (tables: video_games)
Question: Count the number of video games with Massively multiplayer online game type .
SQL: SELECT count(*) FROM Video_games WHERE gtype  =  "Massively multiplayer online game"
Database: game_1 (tables: video_games)
Question: Show all video game types and the number of video games in each type.
SQL: SELECT gtype ,  count(*) FROM Video_games GROUP BY gtype
Database: game_1 (tables: video_games)
Question: What are the types of video games and how many are in each type?
SQL: SELECT gtype ,  count(*) FROM Video_games GROUP BY gtype
Database: game_1 (tables: video_games)
Question: Which game type has most number of games?
SQL: SELECT gtype FROM Video_games GROUP BY gtype ORDER BY count(*) DESC LIMIT 1
Database: game_1 (tables: video_games)
Question: What type has the most games?
SQL: SELECT gtype FROM Video_games GROUP BY gtype ORDER BY count(*) DESC LIMIT 1
Database: game_1 (tables: video_games)
Question: Which game type has least number of games?
SQL: SELECT gtype FROM Video_games GROUP BY gtype ORDER BY count(*) LIMIT 1
Database: game_1 (tables: video_games)
Question: What is the type with the fewest games?
SQL: SELECT gtype FROM Video_games GROUP BY gtype ORDER BY count(*) LIMIT 1
Database: game_1 (tables: student)
Question: Show ids for all students who live in CHI.
SQL: SELECT StuID FROM Student WHERE city_code  =  "CHI"
Database: game_1 (tables: student)
Question: What are the ids of all students who live in CHI?
SQL: SELECT StuID FROM Student WHERE city_code  =  "CHI"
Database: game_1 (tables: student)
Question: Show ids for all students who have advisor 1121.
SQL: SELECT StuID FROM Student WHERE Advisor  =  1121
Database: game_1 (tables: student)
Question: What are the ids of all students who have advisor number 1121?
SQL: SELECT StuID FROM Student WHERE Advisor  =  1121
Database: game_1 (tables: student)
Question: Show first name for all students with major 600.
SQL: SELECT Fname FROM Student WHERE Major  =  600
Database: game_1 (tables: student)
Question: What are the first names for all students who are from the major numbered 600?
SQL: SELECT Fname FROM Student WHERE Major  =  600
Database: game_1 (tables: student)
Question: Show the average, minimum, and maximum age for different majors.
SQL: SELECT major ,  avg(age) ,  min(age) ,  max(age) FROM Student GROUP BY major
Database: game_1 (tables: student)
Question: What are the average, minimum, and max ages for each of the different majors?
SQL: SELECT major ,  avg(age) ,  min(age) ,  max(age) FROM Student GROUP BY major
Database: game_1 (tables: student)
Question: Show all advisors who have at least two students.
SQL: SELECT advisor FROM Student GROUP BY advisor HAVING count(*)  >=  2
Database: game_1 (tables: student)
Question: What are the advisors
SQL: SELECT advisor FROM Student GROUP BY advisor HAVING count(*)  >=  2
Database: game_1 (tables: sportsinfo)
Question: How many sports do we have?
SQL: SELECT count(DISTINCT sportname) FROM Sportsinfo
Database: game_1 (tables: sportsinfo)
Question: How many different types of sports do we offer?
SQL: SELECT count(DISTINCT sportname) FROM Sportsinfo
Database: game_1 (tables: sportsinfo)
Question: How many students play sports?
SQL: SELECT count(DISTINCT StuID) FROM Sportsinfo
Database: game_1 (tables: sportsinfo)
Question: How many different students are involved in sports?
SQL: SELECT count(DISTINCT StuID) FROM Sportsinfo
Database: game_1 (tables: sportsinfo)
Question: List ids for all student who are on scholarship.
SQL: SELECT StuID FROM Sportsinfo WHERE onscholarship  =  'Y'
Database: game_1 (tables: sportsinfo)
Question: What are the ids for all sporty students who are on scholarship?
SQL: SELECT StuID FROM Sportsinfo WHERE onscholarship  =  'Y'
Database: game_1 (tables: student, sportsinfo)
Question: Show last names for all student who are on scholarship.
SQL: SELECT T2.Lname FROM Sportsinfo AS T1 JOIN Student AS T2 ON T1.StuID  =  T2.StuID WHERE T1.onscholarship  =  'Y'
Database: game_1 (tables: student, sportsinfo)
Question: What are the last names for all scholarship students?
SQL: SELECT T2.Lname FROM Sportsinfo AS T1 JOIN Student AS T2 ON T1.StuID  =  T2.StuID WHERE T1.onscholarship  =  'Y'