Database: talkingdata
Question: How many male users use the Galaxy Ace Plus model?
Evidence: male refers to gender = 'M'; Galaxy Ace Plus refers to device_model = 'Galaxy Ace Plus';
SQL: SELECT COUNT(T1.device_id) FROM gender_age AS T1 INNER JOIN phone_brand_device_model2 AS T2 ON T1.device_id = T2.device_id WHERE T2.device_model = 'Galaxy Ace Plus' AND T1.gender = 'M'

Database: menu
Question: What is the ID of the menu with the most number of dishes?
Evidence: most number of dishes refers to MAX(COUNT(dish_count));
SQL: SELECT id FROM Menu ORDER BY dish_count DESC LIMIT 1

Database: airline
Question: List the tail number of flights that flew on August 17, 2018.
Evidence: tail number refers to TAIL_NUM; on August 17, 2018 refers to FL_DATE = '2018/8/17';
SQL: SELECT TAIL_NUM FROM Airlines WHERE FL_DATE = '2018/8/17' GROUP BY TAIL_NUM

Database: regional_sales
Question: From 2018 to 2020, which year did the George Lewis group have the highest number of orders?
Evidence: George Lewis refers to Sales Team; the highest number of orders refers to MAX(COUNT(OrderNumber)); which year from 2018 to 2020 refers to SUBSTR(OrderDate, -2) IN ('18', '19', '20') GROUP BY SUBSTR(OrderDate, -2);
SQL: SELECT SUBSTR(T1.OrderDate, -2, 2) FROM `Sales Orders` AS T1 INNER JOIN `Sales Team` AS T2 ON T2.SalesTeamID = T1._SalesTeamID WHERE T2.`Sales Team` = 'George Lewis' GROUP BY SUBSTR(T1.OrderDate, -2, 2) ORDER BY COUNT(T1.OrderNumber) DESC LIMIT 1

Database: superstore
Question: Among the customers from Houston, Texas, what is the total profit of their orders in the Central region?
Evidence: customers from Houston, Texas refers to State = 'Texas' and City = 'Houston'; total profit = sum(Profit)
SQL: SELECT SUM(T2.Profit) FROM people AS T1 INNER JOIN central_superstore AS T2 ON T1.`Customer ID` = T2.`Customer ID` INNER JOIN product AS T3 ON T3.`Product ID` = T2.`Product ID` WHERE T1.City = 'Houston' AND T1.State = 'Texas' AND T2.Region = 'Central'

Database: simpson_episodes
Question: Among the episodes which have star score less than 8, how many episodes were aired in 2009?
Evidence: star score less than 8 refers to stars < 8; aired in 2009 refers to air_date LIKE '2009%'
SQL: SELECT COUNT(DISTINCT T2.episode_id) FROM Episode AS T1 INNER JOIN Vote AS T2 ON T2.episode_id = T1.episode_id WHERE strftime('%Y', T1.air_date) = '2009' AND T2.stars < 8;

Database: university
Question: What is the ID of the Publications Rank criteria?
Evidence: Publications Rank criteria refers to criteria_name = 'Publications Rank';
SQL: SELECT id FROM ranking_criteria WHERE criteria_name = 'Publications Rank'

Database: cookbook
Question: Give the name of the most widely used ingredient.
Evidence: the most widely used ingredient refers to MAX(COUNT(ingredient_id))
SQL: SELECT T1.name FROM Ingredient AS T1 INNER JOIN Quantity AS T2 ON T1.ingredient_id = T2.ingredient_id GROUP BY T1.name ORDER BY COUNT(T1.name) DESC LIMIT 1

Database: codebase_comments
Question: What is the solution path for method number 3?
Evidence: solution path refers to Path; method number refers to Method_100k.Id; Method_100k.Id = 3;
SQL: SELECT T1.Path FROM Solution AS T1 INNER JOIN Method AS T2 ON T1.Id = T2.SolutionId WHERE T2.Id = 3

Database: world
Question: What city has the highest population?
Evidence: highest population refers to MAX(Population);
SQL: SELECT Name FROM City ORDER BY Population DESC LIMIT 1

Database: retail_complains
Question: Among the calls from California, what percentage are priority 1?
Evidence: California refers to state = 'California'; percentage = MULTIPLY(DIVIDE(SUM(priority = 1), COUNT("Complaint ID"), 1.0));
SQL: SELECT CAST(SUM(CASE WHEN T1.priority = 1 THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(T1.priority) FROM callcenterlogs AS T1 INNER JOIN client AS T2 ON T1.`rand client` = T2.client_id INNER JOIN district AS T3 ON T2.district_id = T3.district_id INNER JOIN state AS T4 ON T3.state_abbrev = T4.StateCode WHERE T4.State = 'California'

Database: movie_3
Question: Which category is the most common?
Evidence: most common category refers to MAX(COUNT(category.name))
SQL: SELECT T.name FROM ( SELECT T2.name, COUNT(T2.name) AS num FROM film_category AS T1 INNER JOIN category AS T2 ON T1.category_id = T2.category_id GROUP BY T2.name ) AS T ORDER BY T.num DESC LIMIT 1

Database: world_development_indicators
Question: What portion of the nations in Latin America and the Caribbean had more than 50% of their land used for agriculture in 1961?
Evidence: portion = divide(count(CountryName where Year = '1961' and Value>50), count(CountryName))*100%; nations in Latin America and the Caribbean refers to region = 'Latin America & Caribbean';  more than 50% of their land used for agriculture refers to value where indicatorname = 'Agricultural land (% of land area)'>50; in 1961 refers to Year = '1961'
SQL: SELECT CAST(SUM(CASE WHEN T1.Value > 50 THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(T2.CountryCode) FROM Indicators AS T1 INNER JOIN Country AS T2 ON T1.CountryCode = T2.CountryCode WHERE T1.Year = 1961 AND T2.Region = 'Latin America & Caribbean' AND indicatorname = 'Agricultural land (% of land area)'

Database: retails
Question: Among the products that have a retail price greater than 1,000, how many products were shipped via ship?
Evidence: products refer to l_partkey; retail price greater than 1,000 refers to p_retailprice > 1000; shipped via ship refers to l_shipmode = 'SHIP';
SQL: SELECT COUNT(T1.ps_suppkey) 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 T3.p_retailprice > 1000 AND T2.l_shipmode = 'SHIP'

Database: movie_3
Question: List the names of the customers from India.
Evidence: "India" is the country; name refers to first_name, last_name
SQL: SELECT T4.first_name, T4.last_name FROM country AS T1 INNER JOIN city AS T2 ON T1.country_id = T2.country_id INNER JOIN address AS T3 ON T2.city_id = T3.city_id INNER JOIN customer AS T4 ON T3.address_id = T4.address_id WHERE T1.country = 'India'

Database: retail_world
Question: Who is the newest hired employee? Give the full name.
Evidence: newest hired refers to latest HireDate; full name = FirstName, LastName;
SQL: SELECT FirstName, LastName FROM Employees WHERE HireDate = ( SELECT MAX(HireDate) FROM Employees )

Database: student_loan
Question: How many students have absences of no more than 3 months?
Evidence: absences of no more than 3 months refers to month < 3;
SQL: SELECT COUNT(name) FROM longest_absense_from_school WHERE month < 3

Database: public_review_platform
Question: How many active businesses of city are underrated?
Evidence: active businesses refers to active = 'true'; underrated refers to review_count = 'Low';
SQL: SELECT COUNT(business_id) FROM Business WHERE review_count LIKE 'Low' AND active LIKE 'TRUE'

Database: retail_complains
Question: What was the detailed issue did Mr Gunner Omer Fuller complain about?
Evidence: detailed issue refers to Sub-issue; Mr refers to sex = 'Male';
SQL: SELECT T2.`Sub-issue` FROM client AS T1 INNER JOIN events AS T2 ON T1.client_id = T2.Client_ID WHERE T1.first = 'Gunner' AND T1.middle = 'Omer' AND T1.last = 'Fuller' AND T1.sex = 'Male'

Database: movie
Question: List the height and net worth of actors starred in Three Men and a Little Lady.
Evidence: Three Men and a Little Lady refers to Title = 'Three Men and a Little Lady'
SQL: SELECT T3.`Height (Inches)`, T3.NetWorth FROM movie AS T1 INNER JOIN characters AS T2 ON T1.MovieID = T2.MovieID INNER JOIN actor AS T3 ON T3.ActorID = T2.ActorID WHERE T1.Title = 'Three Men and a Little Lady'

Database: retails
Question: How many orders were shipped in 1998?
Evidence: orders refer to l_orderkey; shipped in 1998 refers to year(l_shipdate) = 1998;
SQL: SELECT COUNT(l_orderkey) FROM lineitem WHERE STRFTIME('%Y', l_shipdate) = '1998'