Database: retail_world
Question: Write the shipping company name with the telephone number of (503) 555-9931.
Evidence: telephone number of (503) 555-9931 refers to Phone = '(503) 555-9931'
SQL: SELECT CompanyName FROM Shippers WHERE Phone = '(503) 555-9931'

Database: sales_in_weather
Question: What is the most purchased products during the rainy days in June 2013 in weather station 9?
Evidence: most purchased product refers to Max(units); during the rainy day refers to codesum = RA; in June 2013 refers to SUBSTR(date, 1, 7) = '2013-06'; weather station 9 refers to station_nbr = 9; product refers to item_nbr
SQL: SELECT T1.item_nbr FROM sales_in_weather AS T1 INNER JOIN relation AS T2 ON T1.store_nbr = T2.store_nbr INNER JOIN weather AS T3 ON T2.station_nbr = T3.station_nbr WHERE T3.station_nbr = 9 AND T1.`date` LIKE '%2013-06%' AND codesum = 'RA' ORDER BY T1.units DESC LIMIT 1

Database: public_review_platform
Question: How many users have uber review votes for funny from the fans?
Evidence: users refer to user_id; review_votes_funny = 'uber';
SQL: SELECT COUNT(DISTINCT user_id) FROM Reviews WHERE review_votes_funny = 'Uber'

Database: shakespeare
Question: How many scenes are there on average in one act in Twelfth Night?
Evidence: Twelfth Night refers to Title = 'Twelfth Night'; average scene = divide(sum(Scene), count(Act))
SQL: SELECT SUM(T2.Scene) / COUNT(T2.Act) FROM works AS T1 INNER JOIN chapters AS T2 ON T1.id = T2.work_id WHERE T1.Title = 'Twelfth Night'

Database: donor
Question: For the teacher who wrote the project 'ABC Read', which city was he/she in?
Evidence: ABC Read' is the title; city refers to school_city
SQL: SELECT T2.school_city FROM essays AS T1 INNER JOIN projects AS T2 ON T1.projectid = T2.projectid WHERE T1.title = 'ABC Read'

Database: donor
Question: How many donations does the project "Look, Look, We Need a Nook!" have?
Evidence: project "Look, Look, We Need a Nook!" refers to title = 'Look, Look, We Need a Nook!'
SQL: SELECT SUM(T3.donation_total) FROM essays AS T1 INNER JOIN projects AS T2 ON T1.projectid = T2.projectid INNER JOIN donations AS T3 ON T2.projectid = T3.projectid WHERE T1.title = 'Look, Look, We Need a Nook!'

Database: social_media
Question: State the number of states in the United Kingdom.
Evidence: "United Kingdom" is the Country
SQL: SELECT COUNT(State) AS State_number FROM location WHERE Country = 'United Kingdom'

Database: european_football_1
Question: How many draw games happened on 2018/8/7 for National League?
Evidence: National League is the name of division; Date = '2018-08-07'; draw refers to FTR = 'D'; games refer to Div;
SQL: SELECT COUNT(T1.FTR) FROM matchs AS T1 INNER JOIN divisions AS T2 ON T1.Div = T2.division WHERE T2.name = 'National League' AND T1.Date = '2018-08-07' AND T1.FTR = 'D'

Database: european_football_1
Question: Which 2 Scottish teams scored 10 goals playing as a local team and in which seasons?
Evidence: local team refers to HomeTeam; Scottish means belong to the country = 'Scotland'; scored 10 goals refer to FTHG = 10, which is short name for Final-time Away-team Goals;
SQL: SELECT T1.HomeTeam FROM matchs AS T1 INNER JOIN divisions AS T2 ON T1.Div = T2.division WHERE T2.country = 'Scotland' AND T1.FTHG = 10

Database: authors
Question: What percentage of journals whose short name begins with ANN were published in the paper database in 1989?
Evidence: short name begins with ANN refers to ShortName like 'ANN%' ; percentage refers to DIVIDE(COUNT(ShortName like 'ANN%' ), COUNT(id)) * 100%;  in 1989 refers to Year = 1989
SQL: SELECT CAST((SUM(CASE WHEN T1.ShortName LIKE 'ANN%' THEN 1 ELSE 0 END)) AS REAL) * 100 / COUNT(T1.ShortName) FROM Journal AS T1 INNER JOIN Paper AS T2 ON T1.Id = T2.JournalId WHERE T2.Year = 1989

Database: movie_3
Question: Among the films that the customer RUTH MARTINEZ has rented, what is the title of the one with the highest replacement cost?
Evidence: highest replacement cost refers to Max(replacement_cost)
SQL: SELECT T4.title FROM customer AS T1 INNER JOIN rental AS T2 ON T1.customer_id = T2.customer_id INNER JOIN inventory AS T3 ON T2.inventory_id = T3.inventory_id INNER JOIN film AS T4 ON T3.film_id = T4.film_id WHERE T1.first_name = 'RUTH' AND T1.last_name = 'MARTINEZ' ORDER BY T4.replacement_cost DESC LIMIT 1

Database: soccer_2016
Question: What is the name of the team that won match ID 336000?
Evidence: name of the team refers to Team_Name; won refers to Match_Winner
SQL: SELECT T2.Team_Name FROM Match AS T1 INNER JOIN Team AS T2 ON T2.Team_Id = T1.Match_Winner WHERE T1.Match_Id = 336000

Database: legislator
Question: Give the religion of the legislator whose YouTube name is MaxineWaters.
Evidence: MaxineWaters relates to youtube
SQL: SELECT T2.religion_bio FROM `social-media` AS T1 INNER JOIN current AS T2 ON T1.bioguide = T2.bioguide_id WHERE T1.youtube = 'MaxineWaters'

Database: olympics
Question: In which Olympic Games have the largest number of women participation?
Evidence: the largest number of women participation refers to MAX(COUNT(gender = 'F')); In which Olympic Games refer to games_year;
SQL: SELECT T1.games_name FROM games AS T1 INNER JOIN games_competitor AS T2 ON T1.id = T2.games_id INNER JOIN person AS T3 ON T2.person_id = T3.id WHERE T3.gender = 'F' GROUP BY T1.games_name ORDER BY COUNT(T2.person_id) DESC LIMIT 1

Database: menu
Question: Among the menus in which the dish "Clear green turtle" had appeared, how many of them did not support taking out or booking in advance?
Evidence: Clear green turtle is a name of dish; not support taking out or booking in advance refers to call_number is null;
SQL: SELECT SUM(CASE WHEN T4.name = 'Clear green turtle' THEN 1 ELSE 0 END) FROM MenuItem AS T1 INNER JOIN MenuPage AS T2 ON T1.menu_page_id = T2.id INNER JOIN Menu AS T3 ON T2.menu_id = T3.id INNER JOIN Dish AS T4 ON T1.dish_id = T4.id WHERE T3.call_number IS NULL

Database: movies_4
Question: Provide the genre ID of the movie with the title of "The Dark Knight".
Evidence: movie with the title of "The Dark Knight" refers to title = 'The Dark Knight'
SQL: SELECT T2.genre_id FROM movie AS T1 INNER JOIN movie_genres AS T2 ON T1.movie_id = T2.movie_id WHERE T1.title = 'The Dark Knight'

Database: student_loan
Question: How many students have been absents for more than 6 months?
Evidence: absents for more than 6 months refers to month > 6
SQL: SELECT COUNT(name) FROM longest_absense_from_school WHERE month > 6

Database: soccer_2016
Question: What year was R Dravid born and the role he played?
Evidence: R Dravid refers to Player_Name = 'R Dravid'; year born refers to DOB; role refers to Role_Desc
SQL: SELECT T1.DOB, T3.Role_Desc FROM Player AS T1 INNER JOIN Player_Match AS T2 ON T1.Player_Id = T2.Player_Id INNER JOIN Rolee AS T3 ON T2.Role_Id = T3.Role_Id WHERE T1.Player_Name = 'R Dravid' GROUP BY T1.DOB, T3.Role_Desc

Database: music_tracker
Question: Which artist released singles between 1980 to 1982?
Evidence: releaseType = 'single'; between 1980 to 1982 refers to groupYear between 1980 and 1982;
SQL: SELECT artist FROM torrents WHERE groupYear BETWEEN 1980 AND 1982 AND releaseType LIKE 'single'

Database: retail_world
Question: How much per unit of Konbu does Mayumi's charge?
Evidence: Mayumi's is the name of the company; how much per unit of Konbu refers to UnitPrice where ProductName = 'Konbu';
SQL: SELECT T1.UnitPrice FROM Products AS T1 INNER JOIN Suppliers AS T2 ON T1.SupplierID = T2.SupplierID WHERE T2.CompanyName LIKE 'Mayumi%' AND T1.ProductName = 'Konbu'

Database: retail_complains
Question: What is the birth date of the youngest client?
Evidence: birth date refers to year, month, day; youngest client refers to max(year, month, day)
SQL: SELECT day, month, year FROM client ORDER BY year DESC, month DESC, day DESC LIMIT 1