Database: talkingdata
Question: List down the app IDs under the category of game-Rowing .
SQL: SELECT T2.app_id FROM label_categories AS T1 INNER JOIN app_labels AS T2 ON T1.label_id = T2.label_id WHERE T1.category = 'game-Rowing'

Database: soccer_2016
Question: Provide the names and birthdates of players who have left-arm fast skills.
Evidence: player's name refers to Player_Name; birthdate refers to DOB; have left-arm fast skills refers to Bowling_skill = 'Left-arm fast'
SQL: SELECT T1.Player_Name, T1.DOB FROM Player AS T1 INNER JOIN Bowling_Style AS T2 ON T2.Bowling_Id = T1.Bowling_skill WHERE T2.Bowling_skill = 'Left-arm fast'

Database: social_media
Question: What is the code of Gwynedd State?
Evidence: code refers to StateCode
SQL: SELECT DISTINCT StateCode FROM location WHERE State = 'Gwynedd'

Database: menu
Question: Among the menus that include milk, what is the menu page id of the menu that has the highest price?
Evidence: milk is a name of dish; highest price refers to MAX(price);
SQL: SELECT T1.menu_page_id FROM MenuItem AS T1 INNER JOIN Dish AS T2 ON T2.id = T1.dish_id WHERE T2.name = 'Milk' ORDER BY T1.price DESC LIMIT 1

Database: retails
Question: Among all the customers, what is the percentage of the customer's nation being Germany?
Evidence: DIVIDE(COUNT(c_custkey when n_name = 'GERMANY'), COUNT(c_custkey)) as percentage;
SQL: SELECT CAST(SUM(IIF(T2.n_name = 'GERMANY', 1, 0)) AS REAL) * 100 / COUNT(T1.c_custkey) FROM customer AS T1 INNER JOIN nation AS T2 ON T1.c_nationkey = T2.n_nationkey

Database: public_review_platform
Question: Among the Yelp_Businesses in Arizona, how many of them do not provide alcohol?
Evidence: Arizona refers to state = 'AZ'; do not provide alcohol refers to attribute_name = 'Alcohol' and attribute_value = 'none'
SQL: SELECT COUNT(T2.business_id) FROM Attributes AS T1 INNER JOIN Business_Attributes AS T2 ON T1.attribute_id = T2.attribute_id INNER JOIN Business AS T3 ON T2.business_id = T3.business_id WHERE T1.attribute_name LIKE 'Alcohol' AND T2.attribute_value LIKE 'none' AND T3.state LIKE 'AZ'

Database: talkingdata
Question: What are the categories of the top 2 oldest events?
Evidence: oldest event refers to MIN(timestamp);
SQL: SELECT T4.category FROM events_relevant AS T1 INNER JOIN app_events_relevant AS T2 ON T1.event_id = T2.event_id INNER JOIN app_labels AS T3 ON T3.app_id = T2.app_id INNER JOIN label_categories AS T4 ON T3.label_id = T4.label_id ORDER BY T1.timestamp LIMIT 2

Database: talkingdata
Question: How many users used Vivo Xplay3S model?
Evidence: Vivo Xplay3S model refers to phone_brand = 'vivo' AND device_model = 'Xplay3S';
SQL: SELECT COUNT(device_id) FROM phone_brand_device_model2 WHERE device_model = 'Xplay3S' AND phone_brand = 'vivo'

Database: public_review_platform
Question: How is the "noise level" for the only Yelp business in “Mesa” which got a "Uber" review count?
Evidence: "Noise Level" is the attribute_name; 'Mesa' is the name of city
SQL: SELECT T3.attribute_name FROM Business AS T1 INNER JOIN Business_Attributes AS T2 ON T1.business_id = T2.business_id INNER JOIN Attributes AS T3 ON T2.attribute_id = T3.attribute_id WHERE T1.city = 'Mesa' AND T1.review_count = 'Uber' AND T3.attribute_name = 'Noise Level'

Database: airline
Question: Provide the number of airplanes that landed on Oakland Airport on 2018/8/7.
Evidence: landed on refers to DEST; Oakland Airport refers to Description which contains 'Oakland'; on 2018/8/7 refers to FL_DATE = '2018/8/7';
SQL: SELECT SUM(CASE WHEN T1.Description LIKE '%Oakland%' THEN 1 ELSE 0 END) AS count FROM Airports AS T1 INNER JOIN Airlines AS T2 ON T1.Code = T2.DEST WHERE T2.FL_DATE = '2018/8/7'

Database: soccer_2016
Question: How many of the matches are Superover?
Evidence: are Superover refers to win_type = 'wickets';
SQL: SELECT SUM(CASE WHEN T2.win_type = 'wickets' THEN 1 ELSE 0 END) FROM `Match` AS T1 INNER JOIN Win_By AS T2 ON T1.Win_Type = T2.Win_Id

Database: world
Question: Provide the name, capital city and its official language of the country with the highest life expectancy.
Evidence: capital city refers to Capital; official language refers to IsOfficial = 'T'; highest life expectancy refers to MAX(LifeExpectancy);
SQL: SELECT T1.Name, T1.Capital, T2.Language FROM Country AS T1 INNER JOIN CountryLanguage AS T2 ON T1.Code = T2.CountryCode INNER JOIN City AS T3 ON T1.Code = T3.CountryCode WHERE T2.IsOfficial = 'T' ORDER BY T1.LifeExpectancy DESC LIMIT 1

Database: retail_world
Question: Among the product lists in order ID 10337, write down the product names and suppliers which had the highest in reorder level.
Evidence: suppliers refers to CompanyName; highest in reorder level refers to Max(ReorderLevel)
SQL: SELECT T2.ProductName, T1.CompanyName FROM Suppliers AS T1 INNER JOIN Products AS T2 ON T1.SupplierID = T2.SupplierID INNER JOIN `Order Details` AS T3 ON T2.ProductID = T3.ProductID WHERE T3.OrderID = 10337 ORDER BY T2.ReorderLevel DESC LIMIT 1

Database: world_development_indicators
Question: State the currency of Malaysia and what are the indicator code used by this country in 1970?
Evidence: Malaysia is the name of the country; currency refers to CurrencyUnit; Year = '1970';
SQL: SELECT T1.currencyunit, T2.IndicatorCode FROM Country AS T1 INNER JOIN Indicators AS T2 ON T1.CountryCode = T2.CountryCode WHERE T1.TableName = 'Malaysia' AND T2.Year = 1970

Database: movie_platform
Question: Please list the names of the films released in 2003 among the films scored by user 2941 .
Evidence: released in 2003 refers to movie_release_year = 2003; user 2941 refers to user_id = 2941; film refers to movie;
SQL: SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T2.movie_release_year = 2003 AND T1.user_id = 2941

Database: donor
Question: What is the average amount of donations by people who donated in the project "Recording Rockin' Readers"
Evidence: average amount of donations = divide(sum(donation_to_project), count(donor_acctid)); project "Recording Rockin' Readers" refers to title = 'Recording Rockin' Readers'
SQL: SELECT AVG(T3.donation_to_project) 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 = 'Recording Rockin'' Readers'

Database: regional_sales
Question: Name the products via wholesale channel of the store under Pacific/Honolulu time zone.
Evidence: products refers to Product Name; via wholesale channel refers to Sales Channel = 'Wholesale'
SQL: SELECT T FROM ( SELECT DISTINCT CASE  WHEN T3.`Time Zone` = 'Pacific/Honolulu' AND T2.`Sales Channel` = 'Wholesale' THEN T1.`Product Name` ELSE NULL END AS T FROM Products T1 INNER JOIN `Sales Orders` T2 ON T2._ProductID = T1.ProductID INNER JOIN `Store Locations` T3 ON T3.StoreID = T2._StoreID ) WHERE T IS NOT NULL

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

Database: food_inspection_2
Question: Please list the full names of the sanitarians who did at least one inspection in May, 2010.
Evidence: full name refers to first_name, last_name; in May 2010 refers to inspection_date like '2010-05%'; sanitarian refers to title = 'Sanitarian'
SQL: SELECT DISTINCT T1.first_name, T1.last_name FROM employee AS T1 INNER JOIN inspection AS T2 ON T1.employee_id = T2.employee_id WHERE strftime('%Y-%m', T2.inspection_date) = '2010-05' AND T1.title = 'Sanitarian'

Database: human_resources
Question: Mention the employee's full name and performance status who got the lowest in salary per year.
Evidence: full name = firstname, lastname; the lowest salary refers to MIN(salary)
SQL: SELECT firstname, lastname, performance FROM employee ORDER BY salary ASC LIMIT 1