Database: human_resources
Question: Who is the employee with the highest salary? Specify his/her full name.
Evidence: the highest salary refers to MAX(salary); full name = firstname, lastname
SQL: SELECT firstname, lastname FROM employee WHERE CAST(REPLACE(SUBSTR(salary, 4), ',', '') AS REAL) = ( SELECT MAX(CAST(REPLACE(SUBSTR(salary, 4), ',', '') AS REAL)) FROM employee )

Database: superstore
Question: What are the names of the products that were ordered by Alejandro Grove?
Evidence: ordered by Alejandro Grove refers to "Customer Name" = 'Alejandro Grove'; names of the products refers to "Product Name"
SQL: SELECT DISTINCT T3.`Product Name` FROM west_superstore AS T1 INNER JOIN people AS T2 ON T1.`Customer ID` = T2.`Customer ID` INNER JOIN product AS T3 ON T3.`Product ID` = T1.`Product ID` WHERE T2.`Customer Name` = 'Alejandro Grove'

Database: beer_factory
Question: Among all the root beers sold in 2014, what is the percentage of the root beers produced by the brewery AJ Stephans Beverages?
Evidence: sold in 2014 refers to SUBSTR(TransactionDate, 1, 4) = '2014'; percentage = DIVIDE(MULTIPLY(SUM(BreweryName = 'AJ Stephans Beverages'), 1.0), COUNT(RootBeerID)) WHERE SUBSTR(TransactionDate, 1, 4) = '2014'; AJ Stephans Beverages refers to BreweryName = 'AJ Stephans Beverages';
SQL: SELECT CAST(COUNT(CASE WHEN T3.BreweryName = 'AJ Stephans Beverages' THEN 1 ELSE NULL END) AS REAL) * 100 / COUNT(T1.BrandID) FROM rootbeer AS T1 INNER JOIN `transaction` AS T2 ON T1.RootBeerID = T2.RootBeerID INNER JOIN rootbeerbrand AS T3 ON T1.BrandID = T3.BrandID WHERE T2.TransactionDate LIKE '2014%'

Database: retail_complains
Question: Please list the full names of all the male clients in the Pacific division.
Evidence: full names = first, middle, last; male refers to sex = 'Male';
SQL: SELECT T1.first, T1.middle, T1.last FROM client AS T1 INNER JOIN district AS T2 ON T1.district_id = T2.district_id WHERE T2.division = 'Pacific' AND T1.sex = 'Male'

Database: book_publishing_company
Question: For each publisher, state the type of titles they published order by the publisher name.
Evidence: publisher name refers to pub_name
SQL: SELECT DISTINCT T2.pub_name, T1.type FROM titles AS T1 INNER JOIN publishers AS T2 ON T1.pub_id = T2.pub_id ORDER BY T2.pub_name

Database: movie_3
Question: Give the postal code for the address No.65.
Evidence: address no. 65 refers to address_id = 65
SQL: SELECT postal_code FROM address WHERE address_id = 65

Database: talkingdata
Question: Among the users who are above 20, how many users use device model of ELIFE E7 Mini?
Evidence: above 20 refers to age > 20;
SQL: SELECT COUNT(T1.device_id) FROM gender_age AS T1 INNER JOIN phone_brand_device_model2 AS T2 ON T1.device_id = T2.device_id WHERE T2.device_model = 'ELIFE E7 Mini' AND T1.age > 20

Database: cookbook
Question: How many cups of 1% lowfat milk should be added to no.1436 recipe?
Evidence: 1% lowfat milk is a name of an ingredient; no.1436 recipe refers to recipe_id = 1436; max_qty = min_qty
SQL: SELECT COUNT(*) FROM Ingredient AS T1 INNER JOIN Quantity AS T2 ON T1.ingredient_id = T2.ingredient_id WHERE T1.name = '1% lowfat milk' AND T2.unit = 'cup(s)' AND T2.recipe_id = 1436

Database: synthea
Question: How many types of medication have been prescribed to Mr. Major D'Amore since his visit to the hospital?
Evidence: types of medications refers to medications.DESCRIPTION;
SQL: SELECT COUNT(DISTINCT T2.DESCRIPTION) FROM patients AS T1 INNER JOIN medications AS T2 ON T1.patient = T2.PATIENT WHERE T1.first = 'Major' AND T1.last = 'D''Amore'

Database: food_inspection_2
Question: Please list the names of taverns that paid a $100 fine upon inspection.
Evidence: name refers to dba_name; tavern refers to facility_type = 'Tavern'; a $100 fine refers to fine = 100
SQL: SELECT DISTINCT T1.dba_name 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 = 'Tavern' AND T3.fine = 100

Database: software_company
Question: List down the customer's reference ID with true response.
Evidence: reference ID refers to REFID;
SQL: SELECT REFID FROM Mailings1_2 WHERE RESPONSE = 'true'

Database: shakespeare
Question: How many "servant to Timon" characters are there?
Evidence: servant to Timon refers to characters.Description = 'servant to Timon'
SQL: SELECT COUNT(id) FROM characters WHERE Description = 'servant to Timon'

Database: video_games
Question: Tell the number of games whose publisher id is 352.
Evidence: number of games refers to count(game_id)
SQL: SELECT DISTINCT T.game_id FROM game_publisher AS T WHERE T.publisher_id = 352

Database: synthea
Question: How many male patients have been described as immune to quadrivalent HPV?
Evidence: male refers to gender = 'M'; immune to quadrivalent HPV refers to immunizations.DESCRIPTION = 'HPV quadrivalent';
SQL: SELECT COUNT(DISTINCT T1.patient) FROM patients AS T1 INNER JOIN immunizations AS T2 ON T1.patient = T2.PATIENT WHERE T2.DESCRIPTION = 'HPV  quadrivalent' AND T1.gender = 'M'

Database: donor
Question: List the resource types available at Sax Arts & Crafts.
Evidence: Sax Arts & Crafts refer to vendor_name; resource type available refer to project_resource_type

SQL: SELECT DISTINCT project_resource_type FROM resources WHERE vendor_name = 'Sax Arts & Crafts'

Database: video_games
Question: List the game IDs that were released in 2017.
Evidence: game ID refers to game.id; released in 2017 refers to release_year = 2017
SQL: SELECT T.id FROM game_platform AS T WHERE T.release_year = 2017

Database: codebase_comments
Question: How many percent more of the watchers for the repository of solution No.83855 than No.1502?
Evidence: solution No. refers to Solution.Id; percentage = DIVIDE(MULTIPLY(SUBTRACT(SUM(Solution.Id = 83855), SUM(Solution.Id = 1502)), 100)), SUM(Soltution.Id = 1502);
SQL: SELECT CAST(SUM(CASE WHEN T2.Id = 83855 THEN T1.Watchers ELSE 0 END) - SUM(CASE WHEN T2.Id = 1502 THEN T1.Watchers ELSE 0 END) AS REAL) * 100 / SUM(CASE WHEN T2.Id = 1502 THEN T1.Watchers ELSE 0 END) FROM Repo AS T1 INNER JOIN Solution AS T2 ON T1.Id = T2.RepoId

Database: talkingdata
Question: Please list all the models of the devices used by a female user.
Evidence: models of the devices refers to device_model; female refers to gender = 'F';
SQL: SELECT T1.device_model FROM phone_brand_device_model2 AS T1 INNER JOIN gender_age AS T2 ON T1.device_id = T2.device_id WHERE T2.gender = 'F'

Database: retail_world
Question: Which products by Plutzer Lebensmittelgromrkte AG were discontinued and what are their price?
Evidence: products refers to ProductName; 'Plutzer Lebensmittelgromrkte AG' is a CompanyName; price refers to UnitPrice; 
discontinued products refers to discontinued = 1
SQL: SELECT T1.UnitPrice FROM Products AS T1 INNER JOIN Suppliers AS T2 ON T1.SupplierID = T2.SupplierID WHERE T2.CompanyName = 'Plutzer Lebensmittelgromrkte AG' AND T1.Discontinued = 1

Database: image_and_language
Question: Please list all the predicted relation classes of object sample no.14 in image no.1.
Evidence: predicted relation classes refers to PRED_CLASS; object sample no.14 in image no.1 refers to OBJ1_SAMPLE_ID = 14 AND OBJ2_SAMPLE_ID = 14 and IMG_ID = 1
SQL: SELECT T1.PRED_CLASS FROM PRED_CLASSES AS T1 INNER JOIN IMG_REL AS T2 ON T1.PRED_CLASS_ID = T2.PRED_CLASS_ID WHERE T2.OBJ1_SAMPLE_ID = 14 AND T2.OBJ2_SAMPLE_ID = 14

Database: law_episode
Question: How many people did not enjoy the finale episode?
Evidence: did not enjoy refers to stars = 1; the finale episode refers to episode = 24
SQL: SELECT COUNT(T1.episode_id) FROM Episode AS T1 INNER JOIN Vote AS T2 ON T1.episode_id = T2.episode_id WHERE T1.episode = 24 AND T2.stars = 1