Database: authors
Question: List the paper title and journal ID which were published under the conference name of "International Symposium of Robotics Research".
Evidence: "International Symposium of Robotics Research" is the FullName of conference;
SQL: SELECT DISTINCT T2.Title, T2.JournalId FROM Conference AS T1 INNER JOIN Paper AS T2 ON T1.Id = T2.ConferenceId WHERE T1.FullName = 'International Symposium of Robotics Research' AND T2.Year = 2003

Database: donor
Question: Name the vendors who provide resources for project 'Lights, Camera, Action!'. List all the item names and unit price for each.
Evidence: project 'Lights, Camera, Action!' refers to title = 'Lights, Camera, Action!'
SQL: SELECT T1.vendor_name, T1.item_name, T1.item_unit_price FROM resources AS T1 INNER JOIN projects AS T2 ON T1.projectid = T2.projectid INNER JOIN essays AS T3 ON T2.projectid = T3.projectid WHERE T3.title = 'Lights, Camera, Action!'

Database: cookbook
Question: State the name of the optional ingredient of no.1397 recipe.
Evidence: no.1397 recipe refers to recipe_id = 1397; optional ingredient refers to optional = 'TRUE'
SQL: SELECT T1.name FROM Ingredient AS T1 INNER JOIN Quantity AS T2 ON T1.ingredient_id = T2.ingredient_id WHERE T2.recipe_id = 1397 AND T2.optional = 'TRUE'

Database: cs_semester
Question: What is the salary range of the student with an email of grosellg@hku.hk?
Evidence: salary range refers to salary;
SQL: SELECT T1.salary FROM RA AS T1 INNER JOIN student AS T2 ON T1.student_id = T2.student_id WHERE T2.email = 'grosellg@hku.hk'

Database: airline
Question: What is the name of the airline that flew the most flights to Chicago Midway International?
Evidence: name of the airline refers to Description; flights to refers to DEST; Chicago Midway International refers to Description = 'Chicago, IL: Chicago Midway International'; most flights to Chicago Midway International refers to MAX(COUNT(DEST WHERE Description = 'Chicago, IL: Chicago Midway International'));
SQL: SELECT T3.Description FROM Airports AS T1 INNER JOIN Airlines AS T2 ON T1.Code = T2.DEST INNER JOIN `Air Carriers` AS T3 ON T2.OP_CARRIER_AIRLINE_ID = T3.Code WHERE T1.Description = 'Chicago, IL: Chicago Midway International' AND T2.DEST = 'MDW' GROUP BY T3.Description ORDER BY COUNT(T3.Description) DESC LIMIT 1

Database: world
Question: What is the GNP of the country where district "Entre Rios" belongs?
SQL: SELECT T2.GNP FROM City AS T1 INNER JOIN Country AS T2 ON T1.CountryCode = T2.Code WHERE T1.District = 'Entre Rios' LIMIT 1

Database: retail_world
Question: Please indicate total order quantity of product Geitost and calculate the percentage of such product among all the order quantity.
Evidence: 'Geitost' is a ProductName; calculation = DIVIDE(ProductName = 'Geitost', COUNT(ProductID)) * 100
SQL: SELECT SUM(IF(T1.ProductName = 'Geitost', 1, 0)) AS sum , CAST(SUM(IF(T1.ProductName = 'Geitost', 1, 0)) AS REAL) / COUNT(T1.ProductID) FROM Products AS T1 INNER JOIN `Order Details` AS T2 ON T1.ProductID = T2.ProductID

Database: movie_3
Question: List the store ID of the films starred by Reese West with a duration of 100 minutes and below?
Evidence: a duration of 100 minutes and below refers to length < 100
SQL: SELECT T4.store_id FROM actor AS T1 INNER JOIN film_actor AS T2 ON T1.actor_id = T2.actor_id INNER JOIN film AS T3 ON T2.film_id = T3.film_id INNER JOIN inventory AS T4 ON T3.film_id = T4.film_id WHERE T3.length < 100 AND T1.first_name = 'Reese' AND T1.last_name = 'West'

Database: mental_health_survey
Question: How many questions in 2014's survey had more than 200 answers?
Evidence: 2014 refer to SurveyID; COUNT(QuestionID) where COUNT(AnswerText) > 200
SQL: SELECT COUNT(QuestionID) FROM Answer WHERE SurveyID LIKE 2014 GROUP BY QuestionID ORDER BY COUNT(QuestionID) > 200 LIMIT 1

Database: retail_world
Question: What is the average unit price of Tokyo Traders' products?
Evidence: "Tokyo Traders" is the CompanyName; average unit price = AVG(UnitPrice)
SQL: SELECT SUM(T1.UnitPrice) / COUNT(T2.SupplierID) FROM Products AS T1 INNER JOIN Suppliers AS T2 ON T1.SupplierID = T2.SupplierID WHERE T2.CompanyName = 'Tokyo Traders'

Database: movies_4
Question: What was the job of Dariusz Wolski in the movie "Pirates of the Caribbean: At World's End"?
Evidence: movie "Pirates of the Caribbean: At World's End" refers to title = 'Pirates of the Caribbean: At World''s End'
SQL: SELECT T2.job FROM movie AS T1 INNER JOIN movie_crew AS T2 ON T1.movie_id = T2.movie_id INNER JOIN person AS T3 ON T2.person_id = T3.person_id WHERE T1.title LIKE 'Pirates of the Caribbean: At World%s End' AND T3.person_name = 'Dariusz Wolski'

Database: simpson_episodes
Question: Name the organization which hold the award id 328.
SQL: SELECT organization FROM Award WHERE award_id = 328;

Database: retail_complains
Question: Which region has the second most clients?
Evidence: region refers to division; second most refers to second max(client_id)
SQL: SELECT T2.division FROM client AS T1 INNER JOIN district AS T2 ON T1.district_id = T2.district_id GROUP BY T2.division ORDER BY COUNT(T2.division) DESC LIMIT 1, 1

Database: law_episode
Question: Which episode was nominated for the award for "Outstanding Costume Design for a Series"?
Evidence: episode refers to title; "Outstanding Costume Design for a Series" refers to award = 'Outstanding Costume Design for a Series'
SQL: SELECT T2.title FROM Award AS T1 INNER JOIN Episode AS T2 ON T1.episode_id = T2.episode_id WHERE T1.award = 'Outstanding Costume Design for a Series'

Database: movie_platform
Question: Among the movie lists created after 2010/1/1, how many of them have over 200 followers?
Evidence: created after 2010/1/1 refers to list_update_timestamp_utc>'2010/1/1'; over 200 followers refers to list_followers>200;
SQL: SELECT COUNT(*) FROM lists WHERE list_followers > 200 AND list_update_timestamp_utc > '2010-01-01'

Database: car_retails
Question: Name the Sales Manager of Europe, Middle East, and Africa region. In which office does he/she report to?
Evidence: Sales Manager refers to jobTitle; Europe, Middle East, and Africa region refers to territory = 'EMEA';
SQL: SELECT t2.firstName, t2.lastName FROM offices AS t1 INNER JOIN employees AS t2 ON t1.officeCode = t2.officeCode WHERE t2.jobTitle = 'Sale Manager (EMEA)'

Database: coinmarketcap
Question: State the transaction date whereby DigixDAO was transacted at the hightest price.
Evidence: the highest price refers to max(price); DigixDAO refers to name = 'DigixDAO'
SQL: SELECT T2.date FROM coins AS T1 INNER JOIN historical AS T2 ON T1.id = T2.coin_id WHERE T1.name = 'DigixDAO' ORDER BY T2.price DESC LIMIT 1

Database: movielens
Question: Among divergent movies that got the highest rating, how many of them are from the UK?
Evidence: UK is a country
SQL: SELECT COUNT(DISTINCT T1.movieid) FROM u2base AS T1 INNER JOIN movies AS T2 ON T1.movieid = T2.movieid WHERE T2.country = 'UK' AND T1.rating = 5

Database: simpson_episodes
Question: What are the episodes that have the average rating with more than 20 of 2-star votes?
Evidence: 2-star refers to stars = 2; average rating refers to 5 < rating < = 7; more than 20 of 2-star votes refers to votes > 20
SQL: SELECT DISTINCT T1.episode_id FROM Episode AS T1 INNER JOIN Vote AS T2 ON T2.episode_id = T1.episode_id WHERE T2.stars = 2 AND T2.votes > 20 AND T1.rating > 5.0 AND T1.rating <= 7.0;

Database: car_retails
Question: How many products with the highest expected profits were sold in total?
Evidence: Products refer to productCode; Expected profits = SUBTRACT(MSRP, buyPrice);
SQL: SELECT SUM(t2.quantityOrdered) FROM orderdetails AS t2 INNER JOIN ( SELECT t1.productCode FROM products AS t1 ORDER BY t1.MSRP - t1.buyPrice DESC LIMIT 1 ) AS t3 ON t2.productCode = t3.productCode