Database: soccer_2016
Question: In which venue did Kochi Tuskers Kerala play most of their matches?
Evidence: Kochi Tuskers Kerala refers to Team_Name = 'Kochi Tuskers Kerala'; most of their matches refers to max(Venue_Id)
SQL: SELECT T1.Venue_Name FROM Venue AS T1 INNER JOIN Match AS T2 ON T1.Venue_Id = T2.Venue_Id INNER JOIN Team AS T3 ON T2.Team_1 = T3.Team_Id WHERE T3.Team_Name = 'Kochi Tuskers Kerala' GROUP BY T1.Venue_Name

Database: synthea
Question: Give the body height status of Mr. Vincent Wyman on 2010/8/2.
Evidence: body height status refers to DESCRIPTION = 'Body Height' from observations; on 2010/8/2 refers to DATE = '2010-08-02';
SQL: SELECT T2.description, T2.VALUE, T2.units FROM patients AS T1 INNER JOIN observations AS T2 ON T1.patient = T2.PATIENT WHERE T1.prefix = 'Mr.' AND T1.first = 'Vincent' AND T1.last = 'Wyman' AND T2.date = '2010-08-02' AND T2.description = 'Body Height'

Database: trains
Question: How many cars are there on train no.1?
Evidence: train no.1 refers to train_id = 1
SQL: SELECT COUNT(id) FROM cars WHERE train_id = 1

Database: movie_3
Question: How many films rented on 26th May, 2005 were returned on 30th May, 2005?
Evidence: rented on 26th May 2005 refers to rental_date = '2005-05-26'; return on 30th May, 2005 refers to return_date = '2005-05-30'; number of rented film refers to Count (rental_id)
SQL: SELECT COUNT(DISTINCT rental_id) FROM rental WHERE date(rental_date) BETWEEN '2005-05-26' AND '2005-05-30'

Database: social_media
Question: How many reshared tweets have over 100 likes?
Evidence: over 100 likes refers to Likes > 100; reshare tweet refers to IsReshare = 'TRUE'
SQL: SELECT COUNT(DISTINCT TweetID) FROM twitter WHERE IsReshare = 'TRUE' AND Likes > 100

Database: professional_basketball
Question: Which team did the MVP of 1997 NBA season play in?
Evidence: team refers to tmID; MVP refers to award like '%MVP'; 1997 refers to year = 1997; NBA refers to lgID = 'NBA'
SQL: SELECT DISTINCT T3.tmID FROM players_teams AS T1 INNER JOIN awards_players AS T2 ON T1.playerID = T2.playerID INNER JOIN teams AS T3 ON T1.tmID = T3.tmID AND T1.year = T3.year WHERE T2.year = 1997 AND T2.award = 'Finals MVP' LIMIT 1

Database: computer_student
Question: Provide the position status and IDs of professor who advised student ID "303".
Evidence: position status refers to hasPosition; IDs of professor refers to p_id_dummy; student ID "303" refers to advisedBy.p_id = 303
SQL: SELECT T2.hasPosition, T1.p_id_dummy FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id_dummy = T2.p_id WHERE T1.p_id = 303

Database: retail_world
Question: What is the average number of territories do each sales representative is in charge of?
Evidence: sales representative refers to Title = 'Sales Representative'; average number of territories = divide(count(TerritoryID) , count(EmployeeID)) where Title = 'Sales Representative'
SQL: SELECT CAST(COUNT(T2.TerritoryID) AS REAL) / COUNT(DISTINCT T1.EmployeeID) FROM Employees AS T1 INNER JOIN EmployeeTerritories AS T2 ON T1.EmployeeID = T2.EmployeeID WHERE T1.Title = 'Sales Representative'

Database: olympics
Question: List the name of competitors from Argentina.
Evidence: name refers to full_name; Argentina refers to region_name = 'Argentina';
SQL: SELECT T3.full_name FROM noc_region AS T1 INNER JOIN person_region AS T2 ON T1.id = T2.region_id INNER JOIN person AS T3 ON T2.person_id = T3.id WHERE T1.region_name = 'Argentina'

Database: book_publishing_company
Question: What's the publisher of the book "Silicon Valley Gastronomic Treats"? Give the publisher's name.
Evidence: publisher name refers to pub_name; Silicon Valley Gastronomic Treats is the title of a book
SQL: SELECT T2.pub_name FROM titles AS T1 INNER JOIN publishers AS T2 ON T1.pub_id = T2.pub_id WHERE T1.title = 'Silicon Valley Gastronomic Treats'

Database: ice_hockey_draft
Question: Among the players who played 72 games, how many are left-shooters?
Evidence: played 72 games refers to GP = 72; left-shooters refers to shoots = 'L';
SQL: SELECT COUNT(T2.ELITEID) FROM SeasonStatus AS T1 INNER JOIN PlayerInfo AS T2 ON T1.ELITEID = T2.ELITEID WHERE T1.GP = 72 AND T2.shoots = 'L'

Database: retail_world
Question: Indicate the name of the country where Leka Trading supplies Ipoh Coffee product.
Evidence: 'Leka Trading' is a CompanyName; 'Ipoh Coffee' is a ProductName
SQL: SELECT T2.Country FROM Products AS T1 INNER JOIN Suppliers AS T2 ON T1.SupplierID = T2.SupplierID WHERE T1.ProductName = 'Ipoh Coffee' AND T2.CompanyName = 'Leka Trading'

Database: public_review_platform
Question: Which city has the highest number of businesses in the food industry whose number of reviews is high?
Evidence: highest number of businesses refers to MAX(business_id); food industry refers to category_name = 'Food'; number of reviews is high refers to review_count = 'High';
SQL: SELECT T1.city FROM Business AS T1 INNER JOIN Business_Categories ON T1.business_id = Business_Categories.business_id INNER JOIN Categories AS T3 ON Business_Categories.category_id = T3.category_id WHERE T1.review_count LIKE 'High' AND T3.category_name LIKE 'Food' GROUP BY T1.city

Database: sales_in_weather
Question: What is the ID of the item that sold the best on 2012/1/1 in store no.1?
Evidence: sold on 2012/1/1 refers to date = '2012-01-01'; in store no.1 refers to store_nbr = 1; item sold the best refers to Max(units)
SQL: SELECT item_nbr FROM sales_in_weather WHERE `date` = '2012-01-01' AND store_nbr = 1 ORDER BY units DESC LIMIT 1

Database: retail_world
Question: What is the contact title for the person who supplied a product that is 10 boxes x 12 pieces.
Evidence: "10 boxes x 12 pieces" is the QuantityPerUnit
SQL: SELECT T2.ContactTitle FROM Products AS T1 INNER JOIN Suppliers AS T2 ON T1.SupplierID = T2.SupplierID WHERE T1.QuantityPerUnit = '10 boxes x 12 pieces'

Database: video_games
Question: How many times did other regions make positive sales in DS platform?
Evidence: other regions refers to region_name = 'Other'; positive sales refers to num_sales > 0; DS platform refers to platform_name = 'DS';
SQL: SELECT COUNT(DISTINCT T2.id) FROM platform AS T1 INNER JOIN game_platform AS T2 ON T1.id = T2.platform_id INNER JOIN region_sales AS T3 ON T1.id = T3.game_platform_id INNER JOIN region AS T4 ON T3.region_id = T4.id WHERE T1.platform_name = 'DS' AND T4.region_name = 'Other' AND T3.num_sales > 0

Database: cs_semester
Question: What is the popularity of the professor who advises the highest number of students with the highest research ability?
Evidence: professor with the highest research ability refers to prof_id where MAX(capability);
SQL: SELECT T2.popularity FROM RA AS T1 INNER JOIN prof AS T2 ON T1.prof_id = T2.prof_id GROUP BY T1.prof_id, T1.capability ORDER BY COUNT(T1.student_id) DESC, T1.capability DESC LIMIT 1

Database: movies_4
Question: What is the production company of the movie "Crazy Heart"?
Evidence: movie "Crazy Heart" refers to title = 'Crazy Heart'; production company refers to company_name
SQL: SELECT T1.company_name FROM production_company AS T1 INNER JOIN movie_company AS T2 ON T1.company_id = T2.company_id INNER JOIN movie AS T3 ON T2.movie_id = T3.movie_id WHERE T3.title = 'Crazy Heart'

Database: chicago_crime
Question: Who is responsible for crime cases in district Lincoln?
Evidence: "Lincoln" is the district_name; responsible for crime case refers to commander
SQL: SELECT commander FROM District WHERE district_name = 'Lincoln'

Database: books
Question: Which book by Hirohiko Araki was published on 6/6/2006?
Evidence: "Hirohiko Araki" is the author_name; on 6/6/2006 refers to publication_date = '2006-06-06'; which book refers to title
SQL: SELECT T1.title FROM book AS T1 INNER JOIN book_author AS T2 ON T1.book_id = T2.book_id INNER JOIN author AS T3 ON T3.author_id = T2.author_id WHERE T3.author_name = 'Hirohiko Araki' AND T1.publication_date = '2006-06-06'