Database: soccer_2016
Question: Which team has the highest number of losses of all time?
Evidence: name of the team refers to Team_Name; the highest number of losses refers to max(add(count(Team_1 where Team_Id = Team_1 and Team_1 <> Match_Winner), count(Team_2 where Team_Id = Team_2 and Team_2 <> Match_Winner)))
SQL: SELECT T1.Team_Name FROM Team AS T1 INNER JOIN ( SELECT COUNT(Team_1) AS a, Team_1 FROM Match WHERE Team_1 <> Match_Winner GROUP BY Team_1 UNION SELECT COUNT(Team_2) AS a, Team_2 FROM Match WHERE Team_2 <> Match_Winner GROUP BY Team_2 ORDER BY a DESC LIMIT 1 ) AS T2 ON T1.Team_Id = T2.Team_1

Database: retail_world
Question: Which region has the most territories?
Evidence: region refers to RegionDescription; most territories refers to Max(Count(TerritoryID))
SQL: SELECT T2.RegionID FROM Territories AS T1 INNER JOIN Region AS T2 ON T1.RegionID = T2.RegionID GROUP BY T2.RegionID ORDER BY COUNT(T1.TerritoryID) DESC LIMIT 1

Database: book_publishing_company
Question: What is the title with the most ordered quantity in year 1992?
Evidence: total quantity refers to qty; most ordered quantity refers to order with the highest quantity where MAX(count(qty)); date refers to ord_date; year 1992 refers to YEAR(ord_date) = 1992
SQL: SELECT T2.title FROM sales AS T1 INNER JOIN titles AS T2 ON T1.title_id = T2.title_id WHERE STRFTIME('%Y', T1.ord_date) = '1992' ORDER BY T1.qty DESC LIMIT 1

Database: bike_share_1
Question: Among the trips in August 2013, how many bikes were borrowed from Redwood City.
Evidence: Redwood City is the name of the city; trips in August 2013 refers to start_date like '8%2013%';
SQL: SELECT COUNT(T2.start_date) FROM station AS T1 INNER JOIN trip AS T2 ON T2.start_station_name = T1.name WHERE T2.start_date LIKE '8/%/2013%' AND T1.city = 'Redwood City'

Database: legislator
Question: Among male legislators, state number of the legislators who are not the senator.
Evidence: male refers to gender_bio = M; not the senator refers to class IS NULL OR class = ''
SQL: SELECT COUNT(T3.state) FROM ( SELECT T2.state FROM current AS T1 INNER JOIN `current-terms` AS T2 ON T1.bioguide_id = T2.bioguide WHERE T1.gender_bio = 'M' AND (T2.class IS NULL OR T2.class = '') GROUP BY T2.state ) T3

Database: university
Question: How many criteria are associated with ranking system Center for World University Rankings?
Evidence: ranking system Center for World University Rankings refers to system_name = 'Center for World University Rankings';
SQL: SELECT COUNT(T2.criteria_name) FROM ranking_system AS T1 INNER JOIN ranking_criteria AS T2 ON T1.id = T2.ranking_system_id WHERE T1.system_name = 'Center for World University Rankings'

Database: trains
Question: In which direction does the train with an ellipse-shape car run?
Evidence: shape = 'ellipse'
SQL: SELECT T2.direction FROM cars AS T1 INNER JOIN trains AS T2 ON T1.train_id = T2.id WHERE T1.shape = 'ellipse'

Database: disney
Question: List the movie titles and character names by Bill Thompson.
Evidence: Bill Thompson refers to voice-actor = 'Bill Thompson';
SQL: SELECT movie, character FROM `voice-actors` WHERE 'voice-actor' = 'Bill Thompson'

Database: bike_share_1
Question: List the days in 2013 when rain and fog occurred together and find the id of bikes borrowed on these days.
Evidence: in 2013 refers to year(date) = 2013; rain and fog ocurred together refers to events = 'Fog-Rain'; id of bikes refers to biked_id;
SQL: SELECT T2.date, T1.bike_id FROM trip AS T1 INNER JOIN weather AS T2 ON T2.zip_code = T1.zip_code WHERE SUBSTR(CAST(T2.date AS TEXT), -4) = '2013' AND T2.events = 'Fog-Rain'

Database: car_retails
Question: How many customers with a canceled shipment have a credit limit greater than 115,000?
Evidence: cancelled shipment refers to status = 'cancelled'; creditLimit > 115000;
SQL: SELECT COUNT(T1.customerNumber) FROM customers AS T1 INNER JOIN orders AS T2 ON T1.customerNumber = T2.customerNumber WHERE T2.status = 'Cancelled' AND T1.creditLimit > 115000

Database: address
Question: Name the bad alias of Geneva, AL.
Evidence: "Geneva" is the city; 'AL' is the state
SQL: SELECT T1.bad_alias FROM avoid AS T1 INNER JOIN zip_data AS T2 ON T1.zip_code = T2.zip_code WHERE T2.city = 'Geneva' AND T2.state = 'AL'

Database: superstore
Question: Please list the names of all the products ordered in order CA-2011-112326 in superstores in the center.
Evidence: names of all the products refers to "Product Name"; order CA-2011-112326 refers to "Order ID" = 'CA-2011-112326'; in the center refers to Region = 'Central';
SQL: SELECT DISTINCT T2.`Product Name` FROM central_superstore AS T1 INNER JOIN product AS T2 ON T1.`Product ID` = T2.`Product ID` WHERE T1.`Order ID` = 'CA-2011-112326'

Database: law_episode
Question: How many people from Canada are nominated for an award?
Evidence: from Canada refers to birth_country = Canada; nominated refers to award is NOT NULL
SQL: SELECT COUNT(T1.person_id) FROM Person AS T1 INNER JOIN Award AS T2 ON T1.person_id = T2.person_id WHERE T1.birth_country = 'Canada'

Database: superstore
Question: What was the quantity of Xerox 1952 ordered by Aimee Bixby on 2014/9/10?
Evidence: Xerox 1952 is a "Product Name"; ordered by Aimee Bixby refers to "Customer Name" = 'Aimee Bixby'; on 2014/9/10 refers to "Order Date" = date('2014-09-10');
SQL: SELECT SUM(T2.Quantity) FROM people AS T1 INNER JOIN central_superstore AS T2 ON T1.`Customer ID` = T2.`Customer ID` INNER JOIN product AS T3 ON T3.`Product ID` = T2.`Product ID` WHERE T1.`Customer Name` = 'Aimee Bixby' AND T3.`Product Name` = 'Xerox 1952' AND T2.`Order Date` = '2014-09-10'

Database: regional_sales
Question: Among the sales order shipped in July 2018, calculate the percentage of orders for home fragrances.
Evidence: shipped in July 2018 refers to ShipDate between 01-07-2018 and 31-07-2018; DIVIDE(COUNT(OrderNumber where Product Name = 'Home Fragrances' and SUBSTR(OrderDate, 1, 1) = '7'), COUNT(OrderNumber where SUBSTR(ShipDate, -2) = '18')) as percentage;
SQL: SELECT SUM(CASE WHEN T2.`Product Name` = 'Home Fragrances' THEN 1 ELSE 0 END) * 100 / COUNT(T1.OrderNumber)  FROM `Sales Orders` AS T1 INNER JOIN Products AS T2 ON T2.ProductID = T1._ProductID WHERE T1.ShipDate LIKE '7/%/18'

Database: language_corpus
Question: How many occurrences does the word "panajot" have?
Evidence: panajot refers to word = 'panajot'
SQL: SELECT occurrences FROM words WHERE word = 'panajot'

Database: olympics
Question: Who is the youngest person who participated in the Olympics?
Evidence: Who is the youngest person refers to full_name where MIN(age);
SQL: SELECT T1.full_name FROM person AS T1 INNER JOIN games_competitor AS T2 ON T1.id = T2.person_id ORDER BY T2.age LIMIT 1

Database: world_development_indicators
Question: What country has the latest trade data with a series code of "SP.DYN.CDRT.IN
"? List the table name of the country.
Evidence: the latest trade data refers to LatestTradeData = '2013'; with a series code of "SP.DYN.CDRT.IN
" refers to indicatorcode = 'SP.DYN.CDRT.IN'
SQL: SELECT DISTINCT T1.TableName FROM Country AS T1 INNER JOIN Indicators AS T2 ON T1.CountryCode = T2.CountryCode WHERE T1.LatestTradeData = 2013 AND T2.IndicatorCode = 'SP.DYN.CDRT.IN'

Database: restaurant
Question: Which chicken restaurant has the highest review?
Evidence: chicken restaurant refers to food_type = 'chicken'; the highest review refers to max(review)
SQL: SELECT label FROM generalinfo WHERE food_type = 'chicken' ORDER BY review DESC LIMIT 1

Database: image_and_language
Question: How many samples of "wall" are there in image no.2353079?
Evidence: samples of "wall" refers to OBJ_SAMPLE_ID and OBJ_CLASS = 'wall' ; image no.2353079 refers to IMG_ID = 2353079
SQL: SELECT SUM(CASE WHEN T1.OBJ_CLASS = 'wall' THEN 1 ELSE 0 END) FROM OBJ_CLASSES AS T1 INNER JOIN IMG_OBJ AS T2 ON T1.OBJ_CLASS_ID = T2.OBJ_CLASS_ID WHERE T2.IMG_ID = 2353079