Database: student_loan
Question: How many students is disabled and unemployed at the same time?
Evidence: students who are disabled and unemployed at the same time refers to disabled.name = unemployed.name;
SQL: SELECT COUNT(T1.name) FROM disabled AS T1 INNER JOIN unemployed AS T2 ON T2.name = T1.name

Database: bike_share_1
Question: How many rainy days were recorded in Mountain View?
Evidence: rainy days refers to events = 'rain'; Mountain View refers to zip_code = 94041;
SQL: SELECT SUM(IIF(zip_code = 94041 AND events = 'Rain', 1, 0)) FROM weather

Database: image_and_language
Question: How many samples of animal objects are there in image no.660?
Evidence: samples of animal objects refer to OBJ_SAMPLE_ID where OBJ_CLASS = 'animal'; image no.660 refers to IMG_ID = 660;
SQL: SELECT COUNT(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 = 'animal' AND T1.IMG_ID = 660

Database: cookbook
Question: At least how many cups of graham cracker crumbs does the recipe "Raspberry Chiffon Pie" need?
Evidence: 'graham cracker crumbs' is a name of an ingredient; 'Raspberry Chiffon Pie' refers to title
SQL: SELECT T2.min_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.title = 'Raspberry Chiffon Pie' AND T3.name = 'graham cracker crumbs'

Database: simpson_episodes
Question: What is the percentage of Primetime Emmy nominated episodes with a rating over 7 to all the episodes that have a rating over 7?
Evidence: "Primetime Emmy' is the award_category;  rating over 7 refers to rating > 7; nominated refers to result = 'Nominee'; percentage = Divide(Count(episode_id(award_category = 'Primetime Emmy')), Count (episode_id)) * 100
SQL: SELECT CAST(SUM(CASE WHEN T1.award_category = 'Primetime Emmy' THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(*) FROM Award AS T1 INNER JOIN Episode AS T2 ON T1.episode_id = T2.episode_id WHERE T2.rating > 7 AND T1.result = 'Nominee';

Database: language_corpus
Question: List out the total pages of Wikipedia in Catalan language.
Evidence: This is not;
SQL: SELECT pages FROM langs

Database: retail_world
Question: Which product have the highest user satisfaction?
Evidence: product refers to ProductName; highest user satisfaction refers to max(ReorderLevel)
SQL: SELECT ProductName FROM Products WHERE ReorderLevel = ( SELECT MAX(ReorderLevel) FROM Products )

Database: student_loan
Question: Calculate the ratio of disabled students who have never been absent from school.
Evidence: ratio = MULTIPLY(DIVIDE(SUM(month = 0), COUNT(disabled.name)), 100); never been absent from school refers to month = 0;
SQL: SELECT 100 * SUM(IIF(T2.month = 0, 1, 0)) AS num FROM disabled AS T1 INNER JOIN longest_absense_from_school AS T2 ON T1.name = T2.name

Database: regional_sales
Question: Which store in Arizona has the most net profit?
Evidence: "Arizona" is the name of State; most net profit = Max(Subtract( Unit Price, Unit Cost))
SQL: SELECT T2.StoreID FROM `Sales Orders` AS T1 INNER JOIN `Store Locations` AS T2 ON T2.StoreID = T1._StoreID WHERE T2.State = 'Arizona' ORDER BY T1.`Unit Price` - T1.`Unit Cost` DESC LIMIT 1

Database: video_games
Question: Calculate the total number of sales in North America.
Evidence: total number of sales = MULTIPLY(SUM(num_sales), 100000); North America refers to region_name = 'North America';
SQL: SELECT SUM(T2.num_sales) * 100000 AS nums FROM region AS T1 INNER JOIN region_sales AS T2 ON T1.id = T2.region_id WHERE T1.region_name = 'North America'

Database: restaurant
Question: What is the region of 1149 El Camino Real?
Evidence: 1149 El Camino Real refers to street_num = 1149 and street_name = 'el camino real'
SQL: SELECT T2.region FROM location AS T1 INNER JOIN geographic AS T2 ON T1.city = T2.city WHERE T1.street_num = 1149 AND T1.street_name = 'el camino real'

Database: retail_world
Question: Provide the name of the contact person who made the orders that shipped to Switzerland.
Evidence: shipped to Switzerland refers to ShipCountry = 'Switzerland'; contact person refers to Customers;
SQL: SELECT T1.ContactName FROM Customers AS T1 INNER JOIN Orders AS T2 ON T1.CustomerID = T2.CustomerID WHERE T2.ShipCountry = 'Switzerland' GROUP BY T1.ContactName

Database: coinmarketcap
Question: When did Peercoin rank fifth?
Evidence: when refers to date; rank fifth refers to cmc_rank = 5
SQL: SELECT T2.date FROM coins AS T1 INNER JOIN historical AS T2 ON T1.id = T2.coin_id WHERE T1.name = 'Peercoin' AND T2.cmc_rank = 5

Database: superstore
Question: What is the total quantity that Cindy Stewart order "Lexmark X 9575 Professional All-in-One Color Printer" in the south superstore?
Evidence: Lexmark X 9575 Professional All-in-One Color Printer' is the "Product Name"
SQL: SELECT SUM(T1.Quantity) FROM south_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` = 'Cindy Stewart' AND T3.`Product Name` = 'Lexmark X 9575 Professional All-in-One Color Printer'

Database: menu
Question: Calculate the total dish count for menu with uuid of "510d47e4-2958-a3d9-e040-e00a18064a99" & "510d47e4-295a-a3d9-e040-e00a18064a99".
Evidence: total dish count for uuid of '510d47e4-2958-a3d9-e040-e00a18064a99' = SUM(dish_count WHERE uuid = '510d47e4-2958-a3d9-e040-e00a18064a99'); total dish count for uuid of '510d47e4-295a-a3d9-e040-e00a18064a99 = SUM(dish_count WHERE uuid = '510d47e4-295a-a3d9-e040-e00a18064a99');
SQL: SELECT SUM(CASE WHEN T2.uuid = '510d47e4-2958-a3d9-e040-e00a18064a99' THEN T1.dish_count ELSE 0 END) - SUM(CASE WHEN T2.uuid = '510d47e4-295a-a3d9-e040-e00a18064a99' THEN T1.dish_count ELSE 0 END) FROM Menu AS T1 INNER JOIN MenuPage AS T2 ON T1.id = T2.menu_id

Database: codebase_comments
Question: For the repository which got '189' Stars, how many solutions which needs to be compiled does it contain?
Evidence: repository refers to Repository.Id; solution needs to be compiled refers to WasCompiled = 0;
SQL: SELECT COUNT(T2.RepoId) FROM Repo AS T1 INNER JOIN Solution AS T2 ON T1.Id = T2.RepoId WHERE T1.Stars = 189 AND T2.WasCompiled = 0

Database: codebase_comments
Question: What is the percentage of the methods' solutions that need to be compiled among the methods whose comments is XML format?
Evidence: comment is XML format refers to CommentIsXml = 1; solution needs to be compiled refesr to WasCompiled = 0; percentage = MULTIPLY(DIVIDE(SUM(WasCompiled = 0), COUNT(Solution.Id)), 100);
SQL: SELECT CAST(SUM(CASE WHEN T1.WasCompiled = 0 THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(T2.SolutionId) FROM Solution AS T1 INNER JOIN Method AS T2 ON T1.Id = T2.SolutionId WHERE T2.CommentIsXml = 1

Database: olympics
Question: How many persons in total have participated in 12 meter Mixed Sailing competitions?
Evidence: 12 meter Mixed Sailing competitions refer to event_name = 'Sailing Mixed 12 metres';
SQL: SELECT COUNT(T1.competitor_id) FROM competitor_event AS T1 INNER JOIN event AS T2 ON T1.event_id = T2.id INNER JOIN sport AS T3 ON T2.sport_id = T3.id WHERE T2.event_name = 'Sailing Mixed 12 metres'

Database: olympics
Question: How many kinds of events does athletics have?
Evidence: kinds of events refer to event_name; athletics refer to sport_name = 'Athletics';
SQL: SELECT COUNT(T2.event_name) FROM sport AS T1 INNER JOIN event AS T2 ON T1.id = T2.sport_id WHERE T1.sport_name = 'Athletics'

Database: book_publishing_company
Question: Which publisher had the highest job level? Give his/her full name.
Evidence: highest job level refers to MAX(job_lvl)
SQL: SELECT T1.fname, T1.minit, T1.lname FROM employee AS T1 INNER JOIN jobs AS T2 ON T1.job_id = T2.job_id ORDER BY T1.job_lvl DESC LIMIT 1

Database: legislator
Question: What is the google entity ID of Benjamin Hawkins?
SQL: SELECT google_entity_id_id FROM historical WHERE first_name = 'Benjamin' AND last_name = 'Hawkins'