Database: video_games
Question: What is the diffrence between the number of games produced by Culture Brain that can be played on SNES and DS?
Evidence: difference = SUBTRACT(SUM(platform_name = 'SNES'), SUM(platform_name = 'DS')); SNES refers to platform_name = SNES ; DS refers to platform_name = 'DS' ;
SQL: SELECT COUNT(CASE WHEN T1.platform_name = 'SNES' THEN T3.game_id ELSE NULL END) - COUNT(CASE WHEN T1.platform_name = 'DS' THEN T3.game_id ELSE NULL END) FROM platform AS T1 INNER JOIN game_platform AS T2 ON T1.id = T2.platform_id INNER JOIN game_publisher AS T3 ON T2.game_publisher_id = T3.id INNER JOIN publisher AS T4 ON T3.publisher_id = T4.id WHERE T4.publisher_name = 'Culture Brain'

Database: movielens
Question: How many movies from the USA which user rating is less than 3?
SQL: SELECT COUNT(T1.movieid) FROM u2base AS T1 INNER JOIN movies AS T2 ON T1.movieid = T2.movieid WHERE T2.country = 'USA' AND T1.rating < 3

Database: retail_complains
Question: Write down the date received of complaints sent via Fax.
Evidence: sent via Fax refers to Submitted via = 'Fax'
SQL: SELECT T1.`Date received` FROM callcenterlogs AS T1 INNER JOIN events AS T2 ON T1.`Complaint ID` = T2.`Complaint ID` WHERE T2.`Submitted via` = 'Fax'

Database: disney
Question: Which movie is the character Robin Hood in?
Evidence: Robin Hood is the main character of the movie which refers to hero = 'Robin Hood'; movie refers to movie_title;
SQL: SELECT movie_title FROM characters WHERE hero = 'Robin Hood'

Database: retail_complains
Question: How many times does the consumer have no dispute over a non-timely response from the company?
Evidence: no dispute refers to Consumer disputed? = 'No'; non-timely response refers to Timely response? = 'No'
SQL: SELECT COUNT(`Timely response?`) FROM events WHERE `Timely response?` = 'No' AND `Consumer disputed?` = 'No'

Database: trains
Question: How many cars on a train that runs in the east direction have a flat roof?
Evidence: flat roof refers to roof = 'flat'
SQL: SELECT SUM(CASE WHEN T1.roof = 'flat' THEN 1 ELSE 0 END)as count FROM cars AS T1 INNER JOIN trains AS T2 ON T1.train_id = T2.id WHERE T2.direction = 'east'

Database: university
Question: Please list the names of the universities with a score in teaching of over 90 in 2011.
Evidence: in 2011 refers to year 2011; in teaching refers to  criteria_name = 'Teaching'; score in teaching of over 90 refers to score > 90; 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 > 90

Database: soccer_2016
Question: Which team wins the toss during the match ID 336011, and can you tell me whether they decided to bat or field?
Evidence: wins the toss refers to Toss_Winner; whether they decided to bat or field refers to Toss_Name
SQL: SELECT T2.Toss_Name, T1.Toss_Decide, T1.Toss_Winner FROM `Match` AS T1 INNER JOIN Toss_Decision AS T2 ON T1.Toss_Decide = T2.Toss_Id WHERE T1.Match_Id = '336011'

Database: regional_sales
Question: What is the average land area of ​​the cities in which stores that purchased products for a unit price of 998.30 are located?
Evidence: average land area = Divide (Sum(Land Area), Count(Land Area))
SQL: SELECT AVG(T2.`Land Area`) FROM `Sales Orders` AS T1 INNER JOIN `Store Locations` AS T2 ON T2.StoreID = T1._StoreID WHERE T1.`Unit Price` = '998.30'

Database: legislator
Question: What is the contact form of the legislator named Rick Crawford?
SQL: SELECT T2.contact_form FROM current AS T1 INNER JOIN `current-terms` AS T2 ON T1.bioguide_id = T2.bioguide WHERE T1.official_full_name = 'Rick Crawford'

Database: college_completion
Question: What's the average number of graduates for Central Alabama Community College in the 3 consecutive years from 2011 to 2013?
Evidence: graduates refers to grad_cohort; Central Alabama Community College refers to chronname = 'Central Alabama Community College'; average number of graduates for 3 consecutive years = DIVIDE(SUM(SUM(grad_cohort WHERE year = 2011), SUM(grad_cohort WHERE year = 2012), SUM(grad_cohort WHERE year = 2013)), 3);
SQL: SELECT AVG(T2.grad_cohort) FROM institution_details AS T1 INNER JOIN institution_grads AS T2 ON T2.unitid = T1.unitid WHERE T1.chronname = 'Central Alabama Community College' AND T2.year IN (2011, 2012, 2013) AND T2.gender = 'B' AND T2.race = 'X'

Database: social_media
Question: Please list the texts of all the tweets in French posted by male users.
Evidence: "French" is the language and refers to Lang = 'fr'; male user refers to Gender = 'Male'
SQL: SELECT T1.text FROM twitter AS T1 INNER JOIN user AS T2 ON T1.UserID = T2.UserID WHERE T2.Gender = 'Male' AND T1.Lang = 'fr'

Database: retails
Question: What is the average number of items shipped each day in April of 1994?
Evidence: AVG(l_linenumber) where l_shipdate between '1994-01-01' and '1994-01-30';
SQL: SELECT AVG(l_linenumber) FROM lineitem WHERE l_shipdate BETWEEN '1994-01-01' AND '1994-01-30'

Database: professional_basketball
Question: What is the percentage of the teams who had post season (playoff) were ranked number 1?
Evidence: had post season (play off) refers to playoff is not null; percentage = Divide (Count(Team where rank = 1, Count(Team))) * 100
SQL: SELECT CAST(SUM(CASE WHEN rank = 1 THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(name) FROM teams

Database: movie_platform
Question: What's of rating on the movie "Innocence Unprotected" by the user who created the movie list "250 Favourite Films"?
Evidence: Innocence Unprotected' is movie_title; '250 Favourite Films' is list_title; rating refers to rating_score;
SQL: SELECT T1.rating_score FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id INNER JOIN lists AS T3 ON T3.user_id = T1.user_id WHERE T2.movie_title = 'Innocence Unprotected' AND T3.list_title = '250 Favourite Films'

Database: menu
Question: How many menus were used in Dutcher House?
Evidence: Dutcher House refers to location = 'Dutcher House';
SQL: SELECT COUNT(*) FROM Menu WHERE location = 'Dutcher House'

Database: movie_3
Question: Name the most recent movie rented by Dorothy Taylor.
Evidence: movie name refers to title; the most recent refers to max(rental_date)
SQL: SELECT T4.title FROM customer AS T1 INNER JOIN rental AS T2 ON T1.customer_id = T2.customer_id INNER JOIN inventory AS T3 ON T2.inventory_id = T3.inventory_id INNER JOIN film AS T4 ON T3.film_id = T4.film_id WHERE T1.first_name = 'DOROTHY' AND T1.last_name = 'TAYLOR' ORDER BY T2.rental_date DESC LIMIT 1

Database: video_games
Question: Provide the release year of record ID 1 to 10.
Evidence: record ID 1 to 10 refers to game.id BETWEEN 1 AND 10
SQL: SELECT T.release_year FROM game_platform AS T WHERE T.id BETWEEN 1 AND 10

Database: cookbook
Question: Provide the ingredients and maximum quantities of the recipe which can serve 7 people.
Evidence: can serve 7 people refers to servings = 7
SQL: SELECT T3.name, T2.max_qty FROM Recipe AS T1 INNER JOIN Quantity AS T2 ON T1.recipe_id = T2.recipe_id INNER JOIN Ingredient AS T3 ON T3.ingredient_id = T2.ingredient_id WHERE T1.servings = 7

Database: donor
Question: How many students will be impacted for the Fit Firsties! Project?
Evidence: how many students refers to students_reached; Fit Firsties! project refers to title = 'Fit Firsties!'
SQL: SELECT T2.students_reached FROM essays AS T1 INNER JOIN projects AS T2 ON T1.projectid = T2.projectid WHERE T1.title LIKE 'Fit Firsties!'