Database: movie_3
Question: Calculate the total amount paid by Stephanie Mitchell for film rentals in June 2005.
Evidence: the total amount = sum(amount); in June 2005 refers to payment_date like '2005-06%'
SQL: SELECT SUM(T1.amount) FROM payment AS T1 INNER JOIN customer AS T2 ON T1.customer_id = T2.customer_id WHERE T2.first_name = 'STEPHANIE' AND T2.last_name = 'MITCHELL' AND SUBSTR(T1.payment_date, 1, 7) = '2005-06'

Database: professional_basketball
Question: From 1960 to 1970, what is the total point of all-star players who are still alive?
Evidence: from 1960 to 1970 refers to season_id between 1960 and 1970; still alive refers to deathDate = '0000-00-00'
SQL: SELECT SUM(T2.points) FROM players AS T1 INNER JOIN player_allstar AS T2 ON T1.playerID = T2.playerID WHERE T2.season_id BETWEEN 1960 AND 1970 AND T1.deathDate = '0000-00-00'

Database: sales
Question: Sum up the number sales ids handled by employees called Morningstar, Heather and Dean.
Evidence: SUM = ADD(SUM(SalesID WHERE FirstName = 'Morningstar'), SUM(SalesID WHERE FirstName = 'Heather'), SUM(SalesID WHERE FirstName = 'Dean'));
SQL: SELECT SUM(IIF(T2.FirstName = 'Morningstar', 1, 0)) + SUM(IIF(T2.FirstName = 'Heather', 1, 0)) + SUM(IIF(T2.FirstName = 'Dean', 1, 0)) AS num FROM Sales AS T1 INNER JOIN Employees AS T2 ON T1.SalesPersonID = T2.EmployeeID

Database: menu
Question: Provide the sponsor and event of the menu which includes Cerealine with Milk.
Evidence: Cerealine with Milk is a name of dish;
SQL: SELECT T3.name, T3.event 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 T4.name = 'Cerealine with Milk'

Database: soccer_2016
Question: How many matches did Team 10 play in 2012?
Evidence: Team 10 refers to Team_1 = 10 OR Team_2 = 10; in 2012 refers to SUBSTR(Match_Date, 1, 4) = '2012'
SQL: SELECT SUM(CASE WHEN Team_1 = 10 OR Team_2 = 10 THEN 1 ELSE 0 END) FROM `Match` WHERE SUBSTR(Match_Date, 1, 4) = '2012'

Database: world_development_indicators
Question: What country have its data estimated based on regression?
Evidence: what country refers to LongName; have its data estimated based on regression refers to description = 'Estimates are based on regression.'
SQL: SELECT DISTINCT T1.ShortName FROM Country AS T1 INNER JOIN CountryNotes AS T2 ON T1.CountryCode = T2.Countrycode WHERE T2.Description = 'Estimates are based on regression.'

Database: student_loan
Question: What is the employment and payment status of student110?
Evidence: employment status is mentioned in unemployment; unemployed.name = 'student110' means the student is unemployed; if 'student110' can not be found in unemployed.name, it means the student is employed; payment status is mentioned in no_payment_due; bool = 'pos' means the student has payment due; bool = 'neg' means the student has no payment due; student110 is a name of student;
SQL: SELECT T1.bool FROM no_payment_due AS T1 INNER JOIN unemployed AS T2 ON T1.name = T2.name WHERE T1.name = 'student110'

Database: superstore
Question: What category does the item ordered by Katherine Murray on 11/4/2018 in the South region belong to?
Evidence: ordered by Katherine Murray refers to "Customer Name" = 'Katherine Murray'; on 11/4/2018 refers to "Order Date" = Date('2018-11-04');
SQL: SELECT DISTINCT T3.Category FROM south_superstore AS T1 INNER JOIN people AS T2 ON T1.`Customer ID` = T2.`Customer ID` INNER JOIN product AS T3 ON T3.`Product ID` = T1.`Product ID` WHERE T2.`Customer Name` = 'Katherine Murray' AND T1.`Order Date` = '2018-11-04' AND T2.Region = 'South'

Database: mental_health_survey
Question: How many different answers did the question "Describe the conversation you had with your previous employer about your mental health, including their reactions and actions taken to address your mental health issue/questions." get?
SQL: SELECT COUNT(DISTINCT T1.AnswerText) FROM Answer AS T1 INNER JOIN Question AS T2 ON T1.QuestionID = T2.questionid WHERE T2.questiontext LIKE 'Describe the conversation you had with your previous employer about your mental health, including their reactions and actions taken to address your mental health issue/questions.'

Database: synthea
Question: What are the full names of the patients who started taking Yaz 28 Day Pack in 2011?
Evidence: full name refers to first, last; Yaz 28 Day Pack refers to DESCRIPTION = 'Yaz 28 Day Pack' from medications; started taking in 2011 refers to START like '2011%';
SQL: SELECT DISTINCT T1.first, T1.last, T1.suffix FROM patients AS T1 INNER JOIN medications AS T2 ON T1.patient = T2.PATIENT WHERE T2.DESCRIPTION = 'Yaz 28 Day Pack' AND strftime('%Y', T2.START) = '2011'

Database: beer_factory
Question: List the brand IDs of the beers whose star rating is more than 3.
Evidence: star rating is more than 3 refers to StarRating > 3;
SQL: SELECT BrandID FROM rootbeerreview WHERE StarRating > 3

Database: beer_factory
Question: What is the description of the root beer brand A&W?
Evidence: A&W refers to BrandName = 'A&W';
SQL: SELECT Description FROM rootbeerbrand WHERE BrandName = 'A&W'

Database: menu
Question: What is the average number of dishes per menu in the Souper de Luxe menus? Identify what is the name of the dish that appeared the most in all of its menus.
Evidence: average number of dishes per menu = DIVIDE(COUNT(dish_id), COUNT(menu_page_id)); Souper de Luxe is a name of menu; dish that appeared the most in all of its menus refers to MAX(COUNT(dish_id));
SQL: SELECT COUNT(*), T1.dish_id 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.name = 'Souper de Luxe' GROUP BY T3.id ORDER BY COUNT(T1.dish_id) DESC LIMIT 1

Database: superstore
Question: What is the original price of the "Black Avery Flip-Chart Easel Binder"?
Evidence: "Black Avery Flip-Chart Easel Binder" is the "Product Name"; original price = divide(Sales, subtract(1, Discount))
SQL: SELECT T1.Sales / (1 - T1.Discount) FROM central_superstore AS T1 INNER JOIN product AS T2 ON T1.`Product ID` = T2.`Product ID` WHERE T2.`Product Name` = 'Blackstonian Pencils'

Database: beer_factory
Question: Which brewery does the most purchased root beer in 2016 belong to?
Evidence: most purchased root beer refers to MAX(COUNT(BrandID)); in 2016 refers to PurchaseDate > = '2016-01-01' AND PurchaseDate < = '2016-12-31';
SQL: SELECT T2.BreweryName FROM rootbeer AS T1 INNER JOIN rootbeerbrand AS T2 ON T1.BrandID = T2.BrandID WHERE T1.PurchaseDate BETWEEN '2016-01-01' AND '2016-12-31' GROUP BY T2.BrandID ORDER BY COUNT(T1.BrandID) DESC LIMIT 1

Database: social_media
Question: How many tweets have been posted on Wednesday?
Evidence: "Wednesday" is the Weekday
SQL: SELECT COUNT(TweetID) FROM twitter WHERE Weekday = 'Wednesday'

Database: legislator
Question: Current legislator Sherrod Brown has been in the Democrat party during how many terms that he has served?
SQL: SELECT COUNT(*) FROM current AS T1 INNER JOIN `current-terms` AS T2 ON T1.bioguide_id = T2.bioguide WHERE T1.official_full_name = 'Sherrod Brown' AND T2.party = 'Democrat'

Database: retail_world
Question: How many orders were made by the customers in Ireland.
Evidence: in Ireland refers to Country = 'Ireland';
SQL: SELECT COUNT(T2.OrderID) FROM Customers AS T1 INNER JOIN Orders AS T2 ON T1.CustomerID = T2.CustomerID WHERE T1.Country = 'Ireland'

Database: superstore
Question: How many orders purchased by Aaron Bergman have been delivered with the slowest shipping speed?
Evidence: slowest shipping speed refers to "Ship Mode" = 'Standard Class'
SQL: SELECT COUNT(*) FROM people AS T1 INNER JOIN central_superstore AS T2 ON T1.`Customer ID` = T2.`Customer ID` WHERE T1.`Customer Name` = 'Aaron Bergman' AND T2.`Ship Mode` = 'Standard Class'