Database: public_review_platform
Question: How many Yelp_Business in Anthem are under the category of "Food"?
Evidence: in Anthem refers to city = 'Anthem'; the category of "Food" refers to category_name = 'Food'
SQL: SELECT COUNT(T3.business_id) FROM Categories AS T1 INNER JOIN Business_Categories AS T2 ON T1.category_id = T2.category_id INNER JOIN Business AS T3 ON T2.business_id = T3.business_id WHERE T1.category_name LIKE 'Food' AND T3.city LIKE 'Anthem'

Database: retail_complains
Question: What is the average age of Norwalk clients?
Evidence: average age = AVG(age); Norwalk refers to city = 'Norwalk';
SQL: SELECT CAST(SUM(T1.age) AS REAL) / COUNT(T1.age) AS average FROM client AS T1 INNER JOIN district AS T2 ON T1.district_id = T2.district_id WHERE T2.city = 'Norwalk'

Database: video_games
Question: What is the total number of games sold in region ID 1?
Evidence: total number of games sold = MULTIPLY(SUM(num_sales), 100000);
SQL: SELECT SUM(T.num_sales * 100000) FROM region_sales AS T WHERE T.region_id = 1

Database: books
Question: What is the full name of customer with email ckupis4@tamu.edu?
Evidence: "ckupis4@tamu.edu" is the email of customer; full name refers to first_name, last_name
SQL: SELECT first_name, last_name FROM customer WHERE email = 'ckupis4@tamu.edu'

Database: olympics
Question: Give the name of the tallest athlete from Sweden.
Evidence: the tallest athlete refers to id where MAX(height); from Sweden refers to region_name = 'Sweden'; name refers to full_name;
SQL: SELECT T3.full_name FROM noc_region AS T1 INNER JOIN person_region AS T2 ON T1.id = T2.region_id INNER JOIN person AS T3 ON T2.person_id = T3.id WHERE T1.region_name = 'Sweden' ORDER BY T3.height DESC LIMIT 1

Database: movie_3
Question: The actor Dan Harris played in a 77 minute film with replacement cost of 9.99, what was the rating for that film?
Evidence: 77 min film refers to length = 77
SQL: SELECT T3.rating FROM actor AS T1 INNER JOIN film_actor AS T2 ON T1.actor_id = T2.actor_id INNER JOIN film AS T3 ON T2.film_id = T3.film_id WHERE T1.first_name = 'DAN' AND T1.last_name = 'HARRIS' AND T3.length = 77 AND T3.replacement_cost = '9.99'

Database: food_inspection_2
Question: What is the result of the February 24, 2010 inspection involving the employee named "Arnold Holder"?
Evidence: February 24, 2010 refers to inspection_date = '2010-02-24'
SQL: SELECT DISTINCT T2.results FROM employee AS T1 INNER JOIN inspection AS T2 ON T1.employee_id = T2.employee_id WHERE T2.inspection_date = '2010-02-24' AND T1.first_name = 'Arnold' AND T1.last_name = 'Holder'

Database: food_inspection_2
Question: What is the percentage of restaurants that paid a fine of 250 among all establishments?
Evidence: a fine of 250 refers to fine = 250; percentage = divide(sum(license_no where fine = 250), count(license_no)) * 100%
SQL: SELECT CAST(COUNT(CASE WHEN T3.fine = 250 THEN T1.license_no END) AS REAL) * 100 / COUNT(T1.license_no) FROM establishment AS T1 INNER JOIN inspection AS T2 ON T1.license_no = T2.license_no INNER JOIN violation AS T3 ON T2.inspection_id = T3.inspection_id WHERE T1.facility_type = 'Restaurant'

Database: food_inspection
Question: In the violations in 2014, how many of them have a low risk category?
Evidence: in 2014 refers to year(date) = 2014; risk_category = 'Low Risk';
SQL: SELECT COUNT(risk_category) FROM violations WHERE STRFTIME('%Y', `date`) = '2014' AND risk_category = 'Low Risk'

Database: computer_student
Question: Please list the IDs of the teachers who have advised more than 4 others to teach.
Evidence: teachers refers to p_id_dummy; have advised more than 4 others refers to count(advisedBy.p_id) > 4
SQL: SELECT p_id_dummy FROM advisedBy GROUP BY p_id_dummy HAVING COUNT(p_id_dummy) > 4

Database: movie_platform
Question: How many movies registered on Mubi are directed by Hong Sang-soo?
Evidence: Hong Sang-soo is the name of director;
SQL: SELECT COUNT(movie_id) FROM movies WHERE director_name = 'Hong Sang-soo'

Database: university
Question: What are the names of the universities that got 98 in teaching in 2011?
Evidence: in 2011 refers to year 2011; that got 98 refers to score = 98; in teaching refers to criteria_name = 'Teaching'; name of university refers to university_name
SQL: SELECT T3.university_name FROM ranking_criteria AS T1 INNER JOIN university_ranking_year AS T2 ON T1.id = T2.ranking_criteria_id INNER JOIN university AS T3 ON T3.id = T2.university_id WHERE T1.criteria_name = 'Teaching' AND T2.year = 2011 AND T2.score = 98

Database: language_corpus
Question: In the Catalan language, which biwords pair appeared the most in this language/page?
Evidence: biwords pair refers to w1st.word w2nd.word; appeared the most refers to max(occurrences)
SQL: SELECT w1st, w2nd FROM biwords WHERE occurrences = ( SELECT MAX(occurrences) FROM biwords )

Database: movie
Question: Which movie had the biggest budget? Give the name of the movie.
Evidence: biggest budget refers to max(Budget); name of the movie refers to Title
SQL: SELECT Title FROM movie ORDER BY Budget DESC LIMIT 1

Database: european_football_1
Question: How many teams playing in divisions in Greece have ever scored 4 or more goals?
Evidence: teams include both HomeTeam and AwayTeam; country = 'Greece'; scored 4 or more goals refer to FTAG≥4, which is short name for Final-time Away-team Goals;
SQL: SELECT COUNT(DISTINCT CASE WHEN T1.FTHG >= 4 THEN HomeTeam ELSE NULL end) + COUNT(DISTINCT CASE WHEN T1.FTAG >= 4 THEN AwayTeam ELSE NULL end) FROM matchs AS T1 INNER JOIN divisions AS T2 ON T1.Div = T2.division WHERE T2.country = 'Greece'

Database: retail_world
Question: How many boxes of 'Pavlova' did Northwind sell?
Evidence: 'Pavlova' is a ProductName
SQL: SELECT COUNT(T2.Quantity) FROM Products AS T1 INNER JOIN `Order Details` AS T2 ON T1.ProductID = T2.ProductID WHERE T1.ProductName = 'Pavlova'

Database: olympics
Question: List down the games ID of games held in Tokyo.
Evidence: Tokyo refers to city_name = 'Tokyo';
SQL: SELECT T1.games_id FROM games_city AS T1 INNER JOIN city AS T2 ON T1.city_id = T2.id WHERE T2.city_name = 'Tokyo'

Database: bike_share_1
Question: What is the location coordinates of the bike station from which the bike for the trip that last the longest was borrowed?
Evidence: location coordinates refers to (lat, long); bike that was borrowed the longest refers to MAX(duration);
SQL: SELECT T2.lat, T2.long FROM trip AS T1 INNER JOIN station AS T2 ON T2.name = T1.start_station_name WHERE T1.duration = ( SELECT MAX(T1.duration) FROM trip AS T1 INNER JOIN station AS T2 ON T2.name = T1.start_station_name )

Database: soccer_2016
Question: List the name of England players.
Evidence: England players refers to Country_Name = 'England'
SQL: SELECT T1.Player_Name FROM Player AS T1 INNER JOIN Country AS T2 ON T1.Country_Name = T2.Country_ID WHERE T2.Country_Name = 'England'

Database: cookbook
Question: Which recipe is more beneficial in wound healing, "Raspberry Chiffon Pie" or "Fresh Apricot Bavarian"?
Evidence: Raspberry Chiffon Pie and Fresh Apricot Bavarian are title; vitamin_c is higher refers to MAX(vitamin_c)
SQL: SELECT DISTINCT CASE WHEN CASE WHEN T2.title = 'Raspberry Chiffon Pie' THEN T1.vitamin_c END > CASE WHEN T2.title = 'Fresh Apricot Bavarian' THEN T1.vitamin_c END THEN 'Raspberry Chiffon Pie' ELSE 'Fresh Apricot Bavarian' END AS "vitamin_c is higher" FROM Nutrition T1 INNER JOIN Recipe T2 ON T2.recipe_id = T1.recipe_id

Database: chicago_crime
Question: Give the FBI code description of case No.JB134191.
Evidence: case No.JB134191 refers to case_number = 'JB134191'
SQL: SELECT description FROM Crime AS T1 INNER JOIN FBI_Code AS T2 ON T1.fbi_code_no = T2.fbi_code_no WHERE T1.case_number = 'JB134191'