Database: university
Question: What is the percentage of the international students in University of Oslo in 2015?
Evidence: percentage of the international students refers to pct_international_students; in 2015 refers to year = 2015; in University of Oslo refers to university_name = 'University of Oslo';
SQL: SELECT T2.pct_international_students FROM university AS T1 INNER JOIN university_year AS T2 ON T1.id = T2.university_id WHERE T1.university_name = 'University of Oslo' AND T2.year = 2015

Database: cars
Question: Tell the origin country of car no.382.
Evidence: origin country refers to country; car no.382 refers to ID = 382
SQL: SELECT DISTINCT T2.country FROM production AS T1 INNER JOIN country AS T2 ON T1.country = T2.origin WHERE T1.ID = 382

Database: donor
Question: From which state do the 5 biggest donor, who gave the highest cost of optional support, come from? List their donor_acctid and calculate for their average cost of optional support for every donations they make and identtify the project's type of resource to which they gave the hightest optional support.
Evidence: which state refers to school_state; highest cost of optional support refers to max(donation_optional_support); average cost of optional support = avg(donation_optional_support)
SQL: SELECT T1.school_state, T2.donor_acctid, AVG(T2.donation_optional_support), T1.resource_type FROM projects AS T1 INNER JOIN donations AS T2 ON T1.projectid = T2.projectid ORDER BY T2.donation_optional_support DESC LIMIT 5

Database: regional_sales
Question: Write down the region and name of the sale team ID of 18 and compare their orders between in-store and online.
Evidence: sale team ID of 18 refers to _SalesTeamID = 18; COUNT(OrderNumber where Sales Channel = 'In-Store') > COUNT(OrderNumber where Sales Channel = 'Online');
SQL: SELECT T2.Region, T2.`Sales Team` FROM `Sales Orders` AS T1 INNER JOIN `Sales Team` AS T2 ON T2.SalesTeamID = T1._SalesTeamID WHERE T2.SalesTeamID = 18 AND T1.`Sales Channel` = 'In-Store' OR T1.`Sales Channel` = 'Online'

Database: books
Question: List all books published by ADV Manga.
Evidence: "ADV Manga" is the publisher_name; books refers to title
SQL: SELECT T1.title FROM book AS T1 INNER JOIN publisher AS T2 ON T1.publisher_id = T2.publisher_id WHERE T2.publisher_name = 'ADV Manga'

Database: shakespeare
Question: List the scenes and descriptions in Act 1 of " Pericles, Prince of Tyre".
Evidence: " Pericles, Prince of Tyre" refers to LongTitle = 'Pericles, Prince of Tyre'
SQL: SELECT T2.Scene, T2.Description FROM works AS T1 INNER JOIN chapters AS T2 ON T1.id = T2.work_id WHERE T1.LongTitle = 'Pericles, Prince of Tyre' AND T2.Act = 1

Database: book_publishing_company
Question: In the books published by US publishers, which book has the highest royalty? List these books in the descending order of royalty.
Evidence: US publisher refers publisher in the US where country = 'USA';
SQL: SELECT T1.title FROM titles AS T1 INNER JOIN publishers AS T2 ON T1.pub_id = T2.pub_id INNER JOIN roysched AS T3 ON T1.title_id = T3.title_id WHERE T2.country = 'USA' ORDER BY T1.royalty DESC

Database: public_review_platform
Question: How many long reviews does user No. 36139 give for the Yelp businesses?
Evidence: long reviews refers to review_length = 'long'; user No. refers to user_id;
SQL: SELECT COUNT(review_length) FROM Reviews WHERE user_id = 36139 AND review_length LIKE 'long'

Database: soccer_2016
Question: Among the matches of Delhi Daredevils in 2014, how many won matches are there?
Evidence: Delhi Daredevils refers to team_name = 'Delhi Daredevils'; in 2014 refers to Match_Date contains '2014';
SQL: SELECT COUNT(T1.Match_Winner) FROM `Match` AS T1 INNER JOIN Team AS T2 ON T2.Team_Id = T1.Team_1 OR T2.Team_Id = T1.Team_2 WHERE T2.team_name = 'Delhi Daredevils' AND T1.Match_Date LIKE '2014%'

Database: food_inspection_2
Question: What is the inspection result for inspection done by Thomas Langley?
Evidence: inspection result refers to results
SQL: SELECT DISTINCT T2.results FROM employee AS T1 INNER JOIN inspection AS T2 ON T1.employee_id = T2.employee_id WHERE T1.first_name = 'Thomas' AND T1.last_name = 'Langley'

Database: superstore
Question: What product category got the least sales in the west superstore?
Evidence: least sales refers to Sales = MIN(Sales)
SQL: SELECT T2.Category FROM west_superstore AS T1 INNER JOIN product AS T2 ON T1.`Product ID` = T2.`Product ID` ORDER BY T1.Sales LIMIT 1

Database: movie_3
Question: What is the first name of the customers whose address is in the postal code that begins with 76?
Evidence: postal code that begins with 76 refers to postal_code like '76%'
SQL: SELECT T1.first_name FROM customer AS T1 INNER JOIN address AS T2 ON T1.address_id = T2.address_id WHERE SUBSTR(T2.postal_code, 1, 2) = '76'

Database: mental_health_survey
Question: Give the number of users who took the "mental health survey for 2018".
Evidence: mental health survey for 2018 refers to SurveyID = 2018
SQL: SELECT COUNT(DISTINCT T1.UserID) FROM Answer AS T1 INNER JOIN Survey AS T2 ON T1.SurveyID = T2.SurveyID WHERE T2.Description = 'mental health survey for 2018'

Database: books
Question: How much money on average does Lucas Wyldbore spend on book orders?
Evidence: average spend on book orders = AVG (price)
SQL: SELECT SUM(T1.price) / COUNT(*) FROM order_line AS T1 INNER JOIN cust_order AS T2 ON T2.order_id = T1.order_id INNER JOIN customer AS T3 ON T3.customer_id = T2.customer_id WHERE T3.first_name = 'Lucas' AND T3.last_name = 'Wyldbore'

Database: food_inspection
Question: For the business whose business certificate number is 304977, how many violations did it have on 2013/10/7?
Evidence: date = '2013-10-07';
SQL: SELECT COUNT(T1.business_id) FROM violations AS T1 INNER JOIN businesses AS T2 ON T1.business_id = T2.business_id WHERE T2.business_certificate = '304977' AND T1.`date` = '2013-10-07'

Database: app_store
Question: What are the apps with only 5,000+ installs?
Evidence: Installs = '5,000+';
SQL: SELECT DISTINCT App FROM playstore WHERE Installs = '5,000+'

Database: movielens
Question: How many drama movie with the rating of 3?
SQL: SELECT COUNT(DISTINCT T2.movieid) FROM u2base AS T1 INNER JOIN movies2directors AS T2 ON T1.movieid = T2.movieid WHERE T2.genre = 'drama' AND T1.rating = 3

Database: talkingdata
Question: List the phone brands and models of the users under 10 years of age.
Evidence: models refers to device_model; under 10 years of age refers to age < 10;
SQL: SELECT T2.phone_brand, T2.device_model FROM gender_age AS T1 INNER JOIN phone_brand_device_model2 AS T2 ON T1.device_id = T2.device_id WHERE T1.age < 10

Database: shipping
Question: How many pounds did Sue Newell transport during her first shipment?
Evidence: first shipment refers to Min(ship_date); pounds refers to weight
SQL: SELECT T1.weight FROM shipment AS T1 INNER JOIN driver AS T2 ON T1.driver_id = T2.driver_id WHERE T2.first_name = 'Sue' AND T2.last_name = 'Newell' ORDER BY T1.ship_date ASC LIMIT 1

Database: retail_world
Question: Calculate the total products that are supplied by Japan suppliers.
Evidence: Japan Supplier refers to Country = 'Japan'; total product refers to Count (ProductName)
SQL: SELECT COUNT(T1.SupplierID) FROM Products AS T1 INNER JOIN Suppliers AS T2 ON T1.SupplierID = T2.SupplierID WHERE T2.Country = 'Japan'

Database: video_games
Question: What is the release year of the game that gained 350000 sales in North America?
Evidence: gained 350000 sales refers to num_sales = 3.5; in North America refers to region_name = 'North America'
SQL: SELECT T3.release_year FROM region AS T1 INNER JOIN region_sales AS T2 ON T1.id = T2.region_id INNER JOIN game_platform AS T3 ON T2.game_platform_id = T3.id WHERE T2.num_sales * 100000 = 350000 AND T1.region_name = 'North America'

Database: simpson_episodes
Question: Please indicate the birthplace of the crew which name is Dan Castellaneta.
SQL: SELECT birth_place FROM Person WHERE name = 'Dan Castellaneta';