Database: codebase_comments
Question: How many watchers does the path "maff_se3ue7\US7.sln" have?
SQL: SELECT T1.Watchers FROM Repo AS T1 INNER JOIN Solution AS T2 ON T1.Id = T2.RepoId WHERE T2.Path = 'maff_se3ue7US7.sln'

Database: video_games
Question: List down the record ID of records released between 2000 to 2003.
Evidence: record ID refers to game.id; released between 2000 to 2003 refers to release_year BETWEEN 2000 AND 2003
SQL: SELECT T.id FROM game_platform AS T WHERE T.release_year BETWEEN 2000 AND 2003

Database: retails
Question: Among the orders made by customers in Germany, which one of them has the highest priority in delivery? Please give its order key.
Evidence: orders refer to o_orderkey; Germany is the name of the nation which refers to n_name = 'GERMANY'; earlier orderdate have higher priority in delivery therefore MIN(o_orderdate);
SQL: SELECT T3.o_orderkey FROM nation AS T1 INNER JOIN customer AS T2 ON T1.n_nationkey = T2.c_nationkey INNER JOIN orders AS T3 ON T2.c_custkey = T3.o_custkey WHERE T1.n_name = 'GERMANY' ORDER BY T3.o_orderdate LIMIT 1

Database: food_inspection_2
Question: What is the full name of the sanitarian who inspected Amundsen High School on 2010/5/11?
Evidence: full name refers to first_name, last_name;  Amundsen High School refers to dba_name = 'AMUNDSEN HIGH SCHOOL'; on 2010/5/11 refers to inspection_date = '2010-05-11'
SQL: SELECT T1.first_name, T1.last_name FROM employee AS T1 INNER JOIN inspection AS T2 ON T1.employee_id = T2.employee_id INNER JOIN establishment AS T3 ON T2.license_no = T3.license_no WHERE T2.inspection_date = '2010-05-11' AND T3.dba_name = 'AMUNDSEN HIGH SCHOOL' AND T1.title = 'Sanitarian'

Database: world_development_indicators
Question: What country in the region of Sub-Saharan Africa has a series code of "SP.DYN.AMRT.FE"? Indicate the long name of the country
SQL: SELECT DISTINCT T3.LongName FROM SeriesNotes AS T1 INNER JOIN CountryNotes AS T2 ON T1.SeriesCode = T2.Seriescode INNER JOIN Country AS T3 ON T2.Countrycode = T3.CountryCode WHERE T3.Region = 'Sub-Saharan Africa' AND T1.SeriesCode = 'SP.DYN.AMRT.FE'

Database: authors
Question: List the title and author's name of papers published in the 2007 Neoplasia journal.
Evidence: published in the 2007 refers to Year = 2007; Neoplasia journal refers to FullName = 'Neoplasia'
SQL: SELECT T1.Title, T2.Name FROM Paper AS T1 INNER JOIN PaperAuthor AS T2 ON T1.Id = T2.PaperId INNER JOIN Journal AS T3 ON T1.JournalId = T3.Id WHERE T3.FullName = 'Neoplasia' AND T1.Year = 2007

Database: retails
Question: Indicate the name of the parts without discount.
Evidence: name of the part refers to p_name; without discount refers to l_discount = 0.0000
SQL: SELECT T3.p_name FROM partsupp AS T1 INNER JOIN lineitem AS T2 ON T1.ps_suppkey = T2.l_suppkey INNER JOIN part AS T3 ON T1.ps_partkey = T3.p_partkey WHERE T2.l_discount = 0.0000

Database: codebase_comments
Question: Show the solution path for the method "Mosa.Platform.x86.Instructions.IMul.EmitLegacy"?
Evidence: solution path refers to Path; method refers to Name; Name = 'Mosa.Platform.x86.Instructions.IMul.EmitLegacy';
SQL: SELECT T1.Path FROM Solution AS T1 INNER JOIN Method AS T2 ON T1.Id = T2.SolutionId WHERE T2.Name = 'Mosa.Platform.x86.Instructions.IMul.EmitLegacy'

Database: mental_health_survey
Question: How many respondents younger than 25 years old did participate in the survey in 2016?
Evidence: respondents' and 'users' are synonyms; younger than 25 years old refers to AnswerText(SurveyID = 2016& QuestionID = 1)< 25
SQL: SELECT COUNT(DISTINCT T1.UserID) FROM Answer AS T1 INNER JOIN Question AS T2 ON T1.QuestionID = T2.questionid WHERE T1.QuestionID = 1 AND T1.SurveyID = 2016 AND T1.AnswerText <= 25

Database: trains
Question: How many trains with fully loaded head cars are running east?
Evidence: fully loaded refers to load_num = 3; head cars refers to position = 1
SQL: SELECT COUNT(DISTINCT T1.train_id) FROM cars AS T1 INNER JOIN trains AS T2 ON T1.train_id = T2.id WHERE T1.position = 1 AND T1.load_num = 3

Database: video_games
Question: How many games are puzzle genre?
Evidence: puzzle genre refers to genre_name = 'Puzzle'
SQL: SELECT COUNT(T1.id) FROM game AS T1 INNER JOIN genre AS T2 ON T1.genre_id = T2.id WHERE T2.genre_name = 'Puzzle'

Database: food_inspection_2
Question: Among the establishments that paid a 500 fine, what is the percentage of restaurants?
Evidence: a 500 fine refers to fine = 500; restaurant refers to facility_type = 'Restaurant'; percentage = divide(count(license_no where facility_type = 'Restaurant'), count(license_no)) * 100% where fine = 500
SQL: SELECT CAST(COUNT(CASE WHEN T1.facility_type = 'Restaurant' THEN T1.license_no END) AS REAL) * 100 / COUNT(T1.facility_type) FROM establishment AS T1 INNER JOIN inspection AS T2 ON T1.license_no = T2.license_no INNER JOIN violation AS T3 ON T2.inspection_id = T3.inspection_id WHERE T3.fine = 500

Database: beer_factory
Question: What is the average number of root beers of the brand A&W sold in a day in August, 2014?
Evidence: average = DIVIDE(SUM(COUNT(RootBeerID WHERE BrandName = 'A&W' AND SUBSTR(TransactionDate, 1, 4) = '2014' AND SUBSTR(TransactionDate, 6, 2) = '08')), 31); A&W refers to BrandName = 'A&W'; in August, 2014 refers to SUBSTR(TransactionDate, 1, 4) = '2014' AND SUBSTR(TransactionDate, 6, 2) = '08';
SQL: SELECT CAST(COUNT(T1.BrandID) AS REAL) / 31 FROM rootbeer AS T1 INNER JOIN `transaction` AS T2 ON T1.RootBeerID = T2.RootBeerID INNER JOIN rootbeerbrand AS T3 ON T1.BrandID = T3.BrandID WHERE T2.TransactionDate LIKE '2014-08%' AND T3.BrandName = 'A&W'

Database: disney
Question: List all of Wolfgang Reitherman's movies and their voice actors.
Evidence: Wolfgang Reitherman refers to director = 'Wolfgang Reitherman';
SQL: SELECT T1.name, T2.`voice-actor` FROM director AS T1 INNER JOIN `voice-actors` AS T2 ON T1.name = T2.movie WHERE T1.director = 'Wolfgang Reitherman'

Database: regional_sales
Question: What is the percentage of total orders from stores in Orange County in 2018?
Evidence: DIVIDE(COUNT(OrderNumber where County = 'Orange County' and SUBSTR(OrderDate, -2) = '18'), COUNT(OrderNumber where SUBSTR(OrderDate, -2) = '18')) as percentage;
SQL: SELECT CAST(SUM(CASE WHEN T2.County = 'Orange County' THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(T1.OrderNumber) FROM `Sales Orders` AS T1 INNER JOIN `Store Locations` AS T2 ON T2.StoreID = T1._StoreID WHERE T1.OrderDate LIKE '%/%/18'

Database: retails
Question: How many clients from Mozambique required orders with a low priority order?
Evidence: Mozambique refers to n_name = 'MOZAMBIQUE'; low priority order refers to o_orderpriority = '5-LOW'
SQL: SELECT COUNT(T1.c_custkey) FROM customer AS T1 INNER JOIN nation AS T2 ON T1.c_nationkey = T2.n_nationkey INNER JOIN orders AS T3 ON T1.c_custkey = T3.o_custkey WHERE T2.n_name = 'MOZAMBIQUE' AND T3.o_orderpriority = '5-LOW'

Database: video_games
Question: What genres are the games published by 'Agatsuma Entertainment'?
Evidence: genres refers to genre_name; 'Agatsuma Entertainment' refers to publisher_name = 'Agatsuma Entertainment';
SQL: SELECT T4.genre_name FROM publisher AS T1 INNER JOIN game_publisher AS T2 ON T1.id = T2.publisher_id INNER JOIN game AS T3 ON T2.game_id = T3.id INNER JOIN genre AS T4 ON T3.genre_id = T4.id WHERE T1.publisher_name = 'Agatsuma Entertainment'

Database: movies_4
Question: List the person IDs of the second film editors in Movie No. 12.
Evidence: second film editors refers to job = 'Second Film Editor'; Movie No. 12 refers to movie_id = 12
SQL: SELECT person_id FROM movie_crew WHERE movie_id = 12 AND job = 'Second Film Editor'