Database: restaurant
Question: In which regions are there no African food restaurants?
Evidence: no African food restaurants refers to food_type <> 'african'
SQL: SELECT DISTINCT T2.region FROM generalinfo AS T1 INNER JOIN geographic AS T2 ON T1.city = T2.city WHERE T1.food_type != 'african'

Database: regional_sales
Question: List the order for all in-store sales along with the products sold.
Evidence: orders for all in-store sales refer to OrderNumber where Sales Channel = 'In-Store'; products refer to Product Name;
SQL: SELECT DISTINCT T1.OrderNumber, T2.`Product Name` FROM `Sales Orders` AS T1 INNER JOIN Products AS T2 ON T2.ProductID = T1._ProductID WHERE T1.`Sales Channel` = 'In-Store'

Database: sales_in_weather
Question: Which weather station does the store that sold the highest quantity of item 9 belongs to?
Evidence: item 9 refers to item_nbr = 9; sold the highest quantity refers to Max(Sum(units)); weather station refers to station_nbr
SQL: SELECT station_nbr FROM sales_in_weather AS T1 INNER JOIN relation AS T2 ON T1.store_nbr = T2.store_nbr WHERE T1.item_nbr = 9 GROUP BY T2.station_nbr ORDER BY SUM(T1.units) DESC LIMIT 1

Database: public_review_platform
Question: How many more "buffets" than "gyms" in Yelp business?
Evidence: buffets refers to category_name = 'Buffets'; gyms refers to category_name = 'Gyms'; difference = SUBTRACT(SUM(category_name = 'Buffets'), SUM(category_name = 'Gyms'));
SQL: SELECT SUM(CASE WHEN T1.category_name LIKE 'Buffets' THEN 1 ELSE 0 END) - SUM(CASE WHEN T1.category_name LIKE 'Gyms' THEN 1 ELSE 0 END) FROM Categories AS T1 INNER JOIN Business_Categories AS T2 ON T1.category_id = T2.category_id

Database: car_retails
Question: Please list all the customers that have Steve Patterson as their sales representitive.
Evidence: Steve Patterson is an employee;
SQL: SELECT t1.customerName FROM customers AS t1 INNER JOIN employees AS t2 ON t1.salesRepEmployeeNumber = t2.employeeNumber WHERE t2.firstName = 'Steve' AND t2.lastName = 'Patterson'

Database: retail_complains
Question: In the calls from the mountain division, how many are from teenage clients?
Evidence: teenage refers to age BETWEEN 12 AND 20;
SQL: SELECT COUNT(T1.age) FROM client AS T1 INNER JOIN district AS T2 ON T1.district_id = T2.district_id WHERE T1.age BETWEEN 12 AND 20 AND T2.division = 'Mountain'

Database: video_games
Question: Who is the publisher of the game 2002 FIFA World Cup?
Evidence: who is the publisher refers to publisher_name; 2002 FIFA World Cup refers to game_name = '2002 FIFA World Cup';
SQL: SELECT T2.publisher_name FROM game_publisher AS T1 INNER JOIN publisher AS T2 ON T1.publisher_id = T2.id INNER JOIN game AS T3 ON T1.game_id = T3.id WHERE T3.game_name = '2002 FIFA World Cup'

Database: cs_semester
Question: What is the average satisfying degree of the course Machine Learning Theory?
Evidence: sat refers to student's satisfaction degree with the course;
SQL: SELECT CAST(SUM(T1.sat) AS REAL) / COUNT(T1.student_id) FROM registration AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T2.name = 'Machine Learning Theory'

Database: soccer_2016
Question: In what year did SP Narine win the Orange Cap?
Evidence: year refers to Season_Year
SQL: SELECT T4.Season_Year, T4.Orange_Cap FROM Player AS T1 INNER JOIN Player_Match AS T2 ON T1.Player_Id = T2.Player_Id INNER JOIN Match AS T3 ON T2.Match_Id = T3.Match_Id INNER JOIN Season AS T4 ON T3.Season_Id = T4.Season_Id WHERE T1.Player_Name = 'SP Narine' GROUP BY T4.Season_Year, T4.Orange_Cap

Database: university
Question: Which university had the highest reputation in 2012?
Evidence: had the highest reputation refers to MAX(score), in 2012 refers to year = 2012; which university refers to university_name;
SQL: SELECT T2.university_name FROM university_ranking_year AS T1 INNER JOIN university AS T2 ON T1.university_id = T2.id WHERE T1.year = 2012 ORDER BY T1.score DESC LIMIT 1

Database: professional_basketball
Question: What is the percentage of players who attended Auburn University and won an "All-Defensive Second Team" award?
Evidence: Auburn University refers to college = 'Auburn'; won an "All-Defensive Second Team" award refers to award = 'All-Defensive Second Team'; percentage = divide(count(playerID where award = 'All-Defensive Second Team'), count(playerID)) where college = 'Auburn' * 100%
SQL: SELECT CAST(SUM(CASE WHEN T2.award = 'All-Defensive Second Team' THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(*) FROM players AS T1 INNER JOIN awards_players AS T2 ON T1.playerID = T2.playerID WHERE T1.college = 'Auburn'

Database: talkingdata
Question: How many app users belong to the category of Securities?
SQL: SELECT COUNT(T1.app_id) FROM app_labels AS T1 INNER JOIN label_categories AS T2 ON T2.label_id = T1.label_id WHERE T2.category = 'Securities'

Database: cars
Question: List the name of the cars with model year 1975.
Evidence: name of the car refers to car_name; model year 1975 refers to model_year = 1975
SQL: SELECT T1.car_name FROM data AS T1 INNER JOIN production AS T2 ON T1.ID = T2.ID WHERE T2.model_year = 1975

Database: simpson_episodes
Question: Write down the award ID, award name and winner for character named "Homer simpson 20".
Evidence: "Homer simpson 20" is the character; "Winner" is the result; award name refers to award
SQL: SELECT T1.award_id, T1.award, T1.person FROM Award AS T1 INNER JOIN Character_Award AS T2 ON T1.award_id = T2.award_id WHERE T2.character = 'Homer Simpson' AND T1.result = 'Winner';

Database: music_tracker
Question: Which album title and tag that millie jackson released in 1980?
Evidence: millie jackson is an artist; album title refers to groupName where releaseType = 'album'; groupYear = 1980;
SQL: SELECT T1.groupName, T2.tag FROM torrents AS T1 INNER JOIN tags AS T2 ON T1.id = T2.id WHERE T1.groupYear = 1980 AND T1.artist LIKE 'millie jackson' AND T1.releaseType LIKE 'album'

Database: sales
Question: Give the full name of the customer who bought the most amount of products.
Evidence: full name of the customer = FirstName, MiddleInitial, LastName; most amount of products refers to MAX(MULTIPLY(Quantity, Price));
SQL: SELECT T3.FirstName, T3.MiddleInitial, T3.LastName FROM Products AS T1 INNER JOIN Sales AS T2 ON T1.ProductID = T2.ProductID INNER JOIN Customers AS T3 ON T2.CustomerID = T3.CustomerID ORDER BY T2.Quantity * T1.Price DESC LIMIT 1

Database: bike_share_1
Question: What is the average coldest temperature for the zip code of 94301 and what stations are within the zip code? Include the latitude and longitude as well.
Evidence: coldest temperature refers to min_temperature_f; average coldest temperature refers = AVG(min_temperature_f); stations refers to name; latitude refers to lat; longitude refers to long;
SQL: SELECT AVG(T3.min_temperature_f), T1.long, T1.lat FROM station AS T1 INNER JOIN trip AS T2 ON T2.start_station_name = T1.name INNER JOIN weather AS T3 ON T3.zip_code = T2.zip_code WHERE T3.zip_code = 94301

Database: video_games
Question: What are the three largest numbers of games sold?
Evidence: 3 largest numbers of games sold refers to game_name where MAX(num_sales) LIMIT 3;
SQL: SELECT T.game_platform_id, SUM(T.num_sales) * 100000 FROM region_sales AS T GROUP BY game_platform_id ORDER BY SUM(T.num_sales) * 100000 DESC LIMIT 3

Database: talkingdata
Question: What is the phone brand of the device model "坚果手机"?
SQL: SELECT phone_brand FROM phone_brand_device_model2 WHERE device_model = '坚果手机'