Database: video_games
Question: Indicate the name of all adventure games.
Evidence: name of games refers to game_name; adventure games refers to game_name WHERE genre_name = 'Adventure';
SQL: SELECT T2.game_name FROM genre AS T1 INNER JOIN game AS T2 ON T1.id = T2.genre_id WHERE T1.genre_name = 'Adventure'

Database: world_development_indicators
Question: Enumerate the footnote narratives of The Bahamas under the series code SH.DTH.IMRT in the year 1984.
Evidence: narratives is Description; The Bahamas is the name of the country where Country = 'The Bahamas'
SQL: SELECT DISTINCT T1.Description FROM FootNotes AS T1 INNER JOIN Country AS T2 ON T1.Countrycode = T2.CountryCode WHERE T1.Year = 'YR1984' AND T2.ShortName = 'The Bahamas' AND T1.Seriescode = 'SH.DTH.IMRT'

Database: retail_world
Question: Give the full name of the youngest employee.
Evidence: full name = FirstName, LastName; youngest refers to latest BirthDate;
SQL: SELECT FirstName, LastName FROM Employees WHERE BirthDate = ( SELECT MAX(BirthDate) FROM Employees )

Database: beer_factory
Question: What is the name of the brand of the beer with the shortest brewed history?
Evidence: name of the brand of the beer refers to BrandName; shortest brewed history refers to MAX(FirstBrewedYear);
SQL: SELECT BrandName FROM rootbeerbrand ORDER BY FirstBrewedYear DESC LIMIT 1

Database: professional_basketball
Question: What is the maximum weight of USA all-star players?
Evidence: "USA" is the birthCountry of player;  maximum weight refers to Max(weight)
SQL: SELECT MAX(T1.weight) FROM players AS T1 INNER JOIN player_allstar AS T2 ON T1.playerID = T2.playerID WHERE T1.birthCountry = 'USA'

Database: books
Question: Identify the cost difference between Priority and Express shipping methods.
Evidence: "Priority" and "Express" are both method_name; cost difference = Subtract (Sum(cost where method_name = 'Express'), Sum(cost where method_name 'Priority'))
SQL: SELECT SUM(CASE WHEN method_name = 'Priority' THEN cost ELSE 0 END) - SUM(CASE WHEN method_name = 'Express' THEN cost ELSE 0 END) FROM shipping_method

Database: world_development_indicators
Question: What is indicator code of Rural population?
Evidence: IndicatorName = 'Rural population';
SQL: SELECT DISTINCT IndicatorCode FROM Indicators WHERE IndicatorName = 'Rural population'

Database: address
Question: How many postal points with unique post office types are there in Ohio?
Evidence: postal points refer to zip_code; unique post office types refer to type = 'Unique Post Office'; Ohio is the name of the state, in which name = 'Ohio';
SQL: SELECT COUNT(T2.zip_code) FROM state AS T1 INNER JOIN zip_data AS T2 ON T1.abbreviation = T2.state WHERE T1.name = 'Ohio' AND T2.type = 'Unique Post Office'

Database: world_development_indicators
Question: From 1975 to 1980, how much is the total amount CO2 emmission in kiloton of the the world? Indicate which year the world recorded its highest CO2 emmissions.
Evidence: from 1975 to 1980 refers to Year between 1975 and 1980; the total amount CO2 emmission in kiloton of the the world refers to sum(value where IndicatorName like 'CO2%'); the world recorded its highest CO2 emmissions refers to max(value where IndicatorName like 'CO2%')
SQL: SELECT SUM(T1.Value), T1.Year FROM Indicators AS T1 INNER JOIN Country AS T2 ON T1.CountryCode = T2.CountryCode WHERE T1.IndicatorName = 'CO2 emissions (kt)' AND T1.Year >= 1975 AND T1.Year < 1981 AND T1.CountryCode = 'WLD' AND T2.SpecialNotes = 'World aggregate.'

Database: simpson_episodes
Question: How many title's crew members are working from Casting Department?
Evidence: working from Casting Department refers to category = 'Casting Department'
SQL: SELECT COUNT(*) FROM Episode AS T1 INNER JOIN Credit AS T2 ON T1.episode_id = T2.episode_id WHERE T2.category = 'Casting Department';

Database: sales
Question: Among the employee names, what is the most common middle initial?
Evidence: most common middle initial refers to MAX(COUNT(MiddleInitial));
SQL: SELECT MiddleInitial FROM Employees GROUP BY MiddleInitial ORDER BY COUNT(MiddleInitial) DESC LIMIT 1

Database: beer_factory
Question: Show the credit card number of Lisa Ling.
Evidence: FALSE;
SQL: SELECT DISTINCT T2.CreditCardNumber FROM customers AS T1 INNER JOIN `transaction` AS T2 ON T1.CustomerID = T2.CustomerID WHERE T1.First = 'Lisa' AND T1.Last = 'Ling'

Database: disney
Question: List the names of the directors whose films grossed over $100 million.
Evidence: films grossed over $100 million refer to movie_title where total_gross > 100000000;
SQL: SELECT DISTINCT T2.director FROM characters AS T1 INNER JOIN director AS T2 ON T1.movie_title = T2.name INNER JOIN movies_total_gross AS T3 ON T1.movie_title = T3.movie_title WHERE CAST(REPLACE(trim(T3.total_gross, '$'), ',', '') AS REAL) > 100000000

Database: music_tracker
Question: List the name of artists who have released albums and mixtape from 1980 to 1985 in "dance" genre.
Evidence: albums and mixtape refer to releaseType; from 1980 to 1985 refers to groupYear between 1980 and 1985; tag = 'dance';
SQL: SELECT COUNT(T1.artist) FROM torrents AS T1 INNER JOIN tags AS T2 ON T1.id = T2.id WHERE T2.tag = 'dance' AND T1.groupYear BETWEEN 1980 AND 1985 AND T1.releaseType LIKE 'album' OR T1.releaseType LIKE 'mixtape'

Database: synthea
Question: How many patients with care plan for 'concussion with loss of consciousness' are married?
Evidence: concussion with loss of consciousness refers to careplans.DESCRIPTION = 'Concussion with loss of consciousness'; married refers to marital = 'M';
SQL: SELECT COUNT(DISTINCT T1.patient) FROM patients AS T1 INNER JOIN careplans AS T2 ON T1.patient = T2.PATIENT WHERE T1.marital = 'M' AND T2.REASONDESCRIPTION = 'Concussion with loss of consciousness'

Database: disney
Question: List all the main characters of the movie that are comedy genre.
Evidence: Comedy refers to genre = 'Comedy'; the main character of the movie refers to hero;
SQL: SELECT T2.hero FROM movies_total_gross AS T1 INNER JOIN characters AS T2 ON T1.movie_title = T2.movie_title WHERE T1.genre = 'Comedy'

Database: regional_sales
Question: Mention the customer names and IDs which ordered total net profit of above 5000 USD through online channel.
Evidence: IDs refers to CustomerID; total net profit of above 5000 USD refers to SUM(Subtract(Unit Price, Unit Cost)) > 5000
SQL: SELECT DISTINCT `Customer Names`, CustomerID FROM ( SELECT T2.`Customer Names`, T2.CustomerID , SUM(REPLACE(T1.`Unit Price`, ',', '') - REPLACE(T1.`Unit Cost`, ',', '')) AS T FROM `Sales Orders` T1 INNER JOIN Customers T2 ON T2.CustomerID = T1._CustomerID WHERE T1.`Sales Channel` = 'Online' GROUP BY T2.CustomerID ) WHERE T > 5000

Database: image_and_language
Question: Count the image numbers that contain the "paint" object.
Evidence: image numbers that contain the "paint" object refer to IMG_ID where OBJ_CLASS = 'paint';
SQL: SELECT COUNT(DISTINCT T1.IMG_ID) FROM IMG_OBJ AS T1 INNER JOIN OBJ_CLASSES AS T2 ON T1.OBJ_CLASS_ID = T2.OBJ_CLASS_ID WHERE T2.OBJ_CLASS = 'paint'

Database: food_inspection
Question: In 2013, what are the names of the establishments with contaminated or adulterated food?
Evidence: establishments have the same meaning as businesses; contaminated or adulterated food refers to violations where description = 'Contaminated or adulterated food'; date = '2013';
SQL: SELECT T2.name FROM violations AS T1 INNER JOIN businesses AS T2 ON T1.business_id = T2.business_id WHERE STRFTIME('%Y', T1.`date`) = '2013' AND T1.description = 'Contaminated or adulterated food'

Database: soccer_2016
Question: How many games were not won by runs?
Evidence: not won by runs refers to Win_Type ! = 'runs'
SQL: SELECT SUM(CASE WHEN T2.Win_Type != 'runs' THEN 1 ELSE 0 END) FROM `Match` AS T1 INNER JOIN Win_By AS T2 ON T1.Win_Type = T2.Win_Id