Database: cars
Question: Among the cars from Asia, list the IDs of cars that were introduced in 1979.
Evidence: from Asia refers to country = 'Japan'; introduced in 1979 refers to model_year = 1979
SQL: SELECT T1.ID FROM production AS T1 INNER JOIN country AS T2 ON T1.country = T2.origin WHERE T2.country = 'Japan' AND T1.model_year = 1979

Database: retails
Question: Among the suppliers from Middle East region, how many suppliers were in debt?
Evidence: suppliers from Middle East region refer to s_name where r_name = 'MIDDLE EAST'; in debt refers to s_acctbal < 0;
SQL: SELECT COUNT(T3.s_name) FROM region AS T1 INNER JOIN nation AS T2 ON T1.r_regionkey = T2.n_regionkey INNER JOIN supplier AS T3 ON T2.n_nationkey = T3.s_nationkey WHERE T3.s_acctbal < 0 AND T1.r_name = 'MIDDLE EAST'

Database: codebase_comments
Question: List 5 solution path that has sampling time of 636431758961741000.
Evidence: solution path refers to Path; sampling time refers to SampledAt; SampledAt = '636431758961741000';
SQL: SELECT DISTINCT T1.Path FROM Solution AS T1 INNER JOIN Method AS T2 ON T1.Id = T2.SolutionId WHERE T2.SampledAt = 636431758961741000 LIMIT 5

Database: authors
Question: Which paper published by the "TUBERCLE LUNG DIS" journal is the oldest?
Evidence: paper refers to Title; TUBERCLE LUNG DIS is the ShortName of journal; the oldest refers to MIN(Year)
SQL: SELECT T2.Title FROM Journal AS T1 INNER JOIN Paper AS T2 ON T1.Id = T2.JournalId WHERE T1.ShortName = 'TUBERCLE LUNG DIS' ORDER BY T2.Year ASC LIMIT 1

Database: retails
Question: When was the latest date the items of order no.1 were shipped?
Evidence: order no.1 refers to l_orderkey = 1; the latest date shipped refers to MAX(l_shipdate);
SQL: SELECT MAX(l_shipdate) FROM lineitem WHERE l_orderkey = 1

Database: books
Question: How many books were ordered in the last month of the year 2020?
Evidence: ordered in last month of the year 2020 refers to Substr(order_date, 1, 7) = '2020-12'
SQL: SELECT COUNT(*) FROM cust_order WHERE order_date LIKE '2020-12%'

Database: language_corpus
Question: What is the language of the pair of words numbered 1 and 616?
Evidence: Pair is a relationship of two words: w1st and w2nd, where w1st is word id of the first word and w2nd is a word id of the second word; w1st = 1; w2nd = 616;
SQL: SELECT T2.lang FROM biwords AS T1 INNER JOIN langs AS T2 ON T1.lid = T2.lid WHERE T1.w1st = 1 AND T1.w2nd = 616

Database: sales_in_weather
Question: On how many days with the max temperature over 90 did the sale of item no.5 in store no.3 exceed 100?
Evidence: max temperature over 90 refers to tmax > 90; item no. 5 refers to item_nbr = 5; store no.3 refers to store_nbr = 3; sale exceed 100 refers to units > 100; number of days refers to count (date)
SQL: SELECT SUM(CASE WHEN units > 100 THEN 1 ELSE 0 END) AS count FROM sales_in_weather AS T1 INNER JOIN relation AS T2 ON T1.store_nbr = T2.store_nbr INNER JOIN weather AS T3 ON T2.station_nbr = T3.station_nbr WHERE T2.store_nbr = 3 AND SUBSTR(T1.`date`, 1, 4) = '2012' AND T1.item_nbr = 5 AND tmax > 90

Database: retails
Question: What is the quantity of the part "burnished seashell gainsboro navajo chocolate" ordered in order no.1?
Evidence: quantity refers to l_quantity; part "burnished seashell gainsboro navajo chocolate" refers to p_name = 'burnished seashell gainsboro navajo chocolate'; order no.1 refers to l_orderkey = 1
SQL: SELECT T1.l_quantity FROM lineitem AS T1 INNER JOIN part AS T2 ON T1.l_partkey = T2.p_partkey WHERE T1.l_orderkey = 1 AND T2.p_name = 'burnished seashell gainsboro navajo chocolate'

Database: movie_platform
Question: Give the number of followers for the user who posted the most lists.
Evidence: number of followers refers to user_subscriber; posted the most lists refers to MAX(COUNT(list_id))
SQL: SELECT SUM(T1.list_followers) FROM lists AS T1 INNER JOIN lists_users AS T2 ON T1.list_id = T2.list_id GROUP BY T1.user_id ORDER BY COUNT(T1.list_id) DESC LIMIT 1

Database: ice_hockey_draft
Question: How many games did Per Mars play in the 1997-1998 season?
Evidence: 1997-1998 season refers to SEASON = '1997-1998';
SQL: SELECT T2.GP FROM PlayerInfo AS T1 INNER JOIN SeasonStatus AS T2 ON T1.ELITEID = T2.ELITEID WHERE T2.SEASON = '1997-1998' AND T1.PlayerName = 'Pavel Patera'

Database: olympics
Question: How many kinds of events belong to the sport of cycling?
Evidence: kinds of events refer to event_name; sport of cycling refers to sport_name = 'Cycling';
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 = 'Cycling'

Database: books
Question: What percentage of the total prices of all orders are shipped internationally?
Evidence: shipped internationally refers to method_name = 'International'; percentage = Divide (Sum(price where method_name = 'International'), Sum(price)) * 100
SQL: SELECT CAST(SUM(CASE WHEN T3.method_name = 'International' THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(*) FROM cust_order AS T1 INNER JOIN order_line AS T2 ON T1.order_id = T2.order_id INNER JOIN shipping_method AS T3 ON T3.method_id = T1.shipping_method_id

Database: retail_world
Question: Who has the highest salary? Please give their first name.
Evidence: highest salary refers to Max(Salary)
SQL: SELECT FirstName, LastName FROM Employees WHERE Salary = ( SELECT MAX(Salary) FROM Employees )

Database: retail_world
Question: Which customer have the biggest purchase in one order and where does this order being ship to?
Evidence: biggest purchase refers to max(ProductID.Order_Details); ship to refers to ShipCountry
SQL: SELECT T1.CompanyName, T2.ShipCountry FROM Customers AS T1 INNER JOIN Orders AS T2 ON T1.CustomerID = T2.CustomerID INNER JOIN `Order Details` AS T3 ON T2.OrderID = T3.OrderID GROUP BY T1.CompanyName, T2.ShipCountry ORDER BY COUNT(T3.ProductID) DESC LIMIT 1

Database: soccer_2016
Question: What is the batting hand of MK Pandey?
Evidence: MK Pandey refers to Player_Name = 'MK Pandey'
SQL: SELECT T2.Batting_hand FROM Player AS T1 INNER JOIN Batting_Style AS T2 ON T1.Batting_hand = T2.Batting_Id WHERE T1.Player_Name = 'MK Pandey'

Database: retail_world
Question: How many products supplied by Plutzer Lebensmittelgromrkte AG that is currently out of stock and on order?
Evidence: Plutzer Lebensmittelgromrkte AG refers to CompanyName; is currently out of stock and on order refers to UnitsInStock = 0 and UnitsOnOrder > 0
SQL: SELECT COUNT(T1.ProductID) FROM Products AS T1 INNER JOIN Suppliers AS T2 ON T1.SupplierID = T2.SupplierID WHERE T2.CompanyName = 'Plutzer Lebensmittelgromrkte AG' AND T1.UnitsInStock = 0 AND T1.UnitsOnOrder = 0

Database: cars
Question: Which country does Chevy C20 come from?
Evidence: Chevy C20 refers to car_name = 'chevy c20'
SQL: SELECT T3.country FROM data AS T1 INNER JOIN production AS T2 ON T1.ID = T2.ID INNER JOIN country AS T3 ON T3.origin = T2.country WHERE T1.car_name = 'chevy c20'

Database: sales
Question: Among the "Mountain-500 Black" product types, which type was purchased the most?
Evidence: Mountain-500 Black product types refers to Name like 'Mountain-500 Black%'; purchased the most refers to MAX(SUM(Quantity));
SQL: SELECT T1.Name FROM Products AS T1 INNER JOIN Sales AS T2 ON T1.ProductID = T2.ProductID WHERE T1.Name LIKE 'Mountain-500 Black%' GROUP BY T2.Quantity, T1.Name ORDER BY SUM(T2.Quantity) DESC LIMIT 1

Database: retails
Question: Please list the order keys of all the orders that have more than 2 parts with a jumbo case container.
Evidence: order key refers to l_orderkey; jumbo case container refers to p_container = 'JUMBO CASE'; more than 2 parts refers to count(l_partkey) > 2
SQL: SELECT T.l_orderkey FROM ( SELECT T2.l_orderkey, COUNT(T2.l_partkey) AS num FROM part AS T1 INNER JOIN lineitem AS T2 ON T1.p_partkey = T2.l_partkey WHERE T1.p_container = 'JUMBO CASE' GROUP BY T2.l_orderkey ) AS T WHERE T.num > 2