Database: retail_world
Question: What is the shipping cost for order number 10692 from the company Alfreds Futterkiste?
Evidence: Alfreds Futterkiste is the name of the company; order number 10692 refers to OrderID = 10692;
SQL: SELECT T2.Freight FROM Customers AS T1 INNER JOIN Orders AS T2 ON T1.CustomerID = T2.CustomerID WHERE T2.OrderID = 10692 AND T1.CompanyName = 'Alfreds Futterkiste'

Database: movies_4
Question: Look for the movie title with the keyword of "angel".
Evidence: keyword of "angel" refers to keyword_name = 'angel'
SQL: SELECT T1.title FROM movie AS T1 INNER JOIN movie_keywords AS T2 ON T1.movie_id = T2.movie_id INNER JOIN keyword AS T3 ON T2.keyword_id = T3.keyword_id WHERE T3.keyword_name = 'angel'

Database: regional_sales
Question: Among sales teams in Midwest region, which sales team has an order quantity greater than 5?
Evidence: order quantity greater than 5 refers to Order Quantity > 5
SQL: SELECT DISTINCT T2.`Sales Team` FROM `Sales Orders` AS T1 INNER JOIN `Sales Team` AS T2 ON T2.SalesTeamID = T1._SalesTeamID WHERE T2.Region = 'Midwest' AND T1.`Order Quantity` > 5

Database: regional_sales
Question: List down the customer IDs and names that start with alphabet "W".
Evidence: names that start with alphabet "W" refer to Customer Names LIKE 'W%';
SQL: SELECT DISTINCT CustomerID, `Customer Names` FROM Customers WHERE `Customer Names` LIKE 'W%' ORDER BY `Customer Names` DESC

Database: video_games
Question: Who is the publisher of 3D Lemmings?
Evidence: publisher refers to publisher_name; 3D Lemmings refers to game_name = '3D Lemmings'
SQL: SELECT T3.publisher_name FROM game AS T1 INNER JOIN game_publisher AS T2 ON T1.id = T2.game_id INNER JOIN publisher AS T3 ON T2.publisher_id = T3.id WHERE T1.game_name = '3D Lemmings'

Database: movielens
Question: List the top 10 USA movies, by descending order, from the highest to the lowest, the user rating.
Evidence: USA is a country
SQL: SELECT T1.movieid FROM u2base AS T1 INNER JOIN movies AS T2 ON T1.movieid = T2.movieid WHERE T2.country = 'USA' GROUP BY T1.movieid ORDER BY AVG(T1.rating) DESC LIMIT 10

Database: retail_world
Question: Mention the supplier country of Ipoh Coffee and the order ID which had maximum in total payment.
Evidence: Ipoh Coffee refers to ProductName = 'Ipoh Coffee'; maximum in total payment refers to MAX(MULTIPLY(UnitPrice, Quantity, SUBTRACT(1, Discount)))
SQL: SELECT T3.Country, T1.OrderID FROM `Order Details` AS T1 INNER JOIN Products AS T2 ON T1.ProductID = T2.ProductID INNER JOIN Suppliers AS T3 ON T2.SupplierID = T3.SupplierID WHERE T2.ProductName = 'Ipoh Coffee' ORDER BY T1.UnitPrice * T1.Quantity * (1 - T1.Discount) DESC LIMIT 1

Database: music_tracker
Question: In 1980, how many singles were released by sugar daddy?
Evidence: sugar daddy is an artist; releaseType = 'single'; groupYear = 1980;
SQL: SELECT COUNT(releaseType) FROM torrents WHERE artist LIKE 'sugar daddy' AND releaseType LIKE 'Single' AND groupYear = 1980

Database: soccer_2016
Question: What is the role of K Goel in the match ID 335992?
Evidence: role refers to Role_Desc; K Goel refers to Player_Name = 'K Goel'; match ID 335992 refers to Match_Id = 335992
SQL: SELECT T3.Role_Desc FROM Player AS T1 INNER JOIN Player_Match AS T2 ON T2.Player_Id = T1.Player_Id INNER JOIN Rolee AS T3 ON T3.Role_Id = T2.Role_Id WHERE T2.Match_Id = 335992 AND T1.Player_Name = 'K Goel'

Database: bike_share_1
Question: List the names of the stations within Mountain View that were installed on 12/31/2013.
Evidence: Mountain View refers to city = 'Mountain View'; installed on 12/31/2013 refers to installation_date = '12/31/2013';
SQL: SELECT name FROM station WHERE installation_date = '12/31/2013' AND city = 'Mountain View'

Database: movielens
Question: List the genres of the movies which actor id 851 is the star.
SQL: SELECT T2.genre FROM movies2actors AS T1 INNER JOIN movies2directors AS T2 ON T1.movieid = T2.movieid INNER JOIN actors AS T3 ON T1.actorid = T3.actorid WHERE T3.actorid = 851

Database: chicago_crime
Question: List the case numbers of domestic violence crimes reported in Lincoln Square.
Evidence: domestic violence refers to domestic = 'TRUE'; Lincoln Square refers to community_area_name = 'Lincoln Square'
SQL: SELECT T2.case_number FROM Community_Area AS T1 INNER JOIN Crime AS T2 ON T2.community_area_no = T1.community_area_no WHERE T1.community_area_name = 'Lincoln Square' AND T2.domestic = 'TRUE'

Database: shipping
Question: Who was the customer of shipment no.1275? Give the customer's name.
Evidence: shipment no. 1275 refers to ship_id = 1275; customer name refers to cust_name
SQL: SELECT T1.cust_name FROM customer AS T1 INNER JOIN shipment AS T2 ON T1.cust_id = T2.cust_id WHERE T2.ship_id = '1275'

Database: airline
Question: Which flight carrier operator flies from Atlantic City to Fort Lauderdale?
Evidence: flight carrier operator refers to OP_CARRIER_AIRLINE_ID; from Atlantic City refers to ORIGIN = 'ACY'; to Fort Lauderdale refers to DEST = 'FLL';
SQL: SELECT T2.Description FROM Airlines AS T1 INNER JOIN `Air Carriers` AS T2 ON T1.OP_CARRIER_AIRLINE_ID = T2.Code WHERE T1.ORIGIN = 'ACY' AND T1.DEST = 'FLL' GROUP BY T2.Description

Database: student_loan
Question: List out the number of disabled students who enlisted in marines.
Evidence: marines refers to organ = 'marines';
SQL: SELECT COUNT(T1.name) FROM disabled AS T1 INNER JOIN enlist AS T2 ON T1.name = T2.name WHERE T2.organ = 'marines'

Database: professional_basketball
Question: What's the full name of the team that won the most games in 2001 but didn't make the playoffs?
Evidence: full name of the team refers to teams.name; in 2001 refers to year = 2001; didn't make the playoffs refers to PostGP = 0; won the most games refers to max(won)
SQL: SELECT T2.tmID FROM players_teams AS T1 INNER JOIN teams AS T2 ON T1.tmID = T2.tmID AND T1.year = T2.year WHERE T1.PostGP = 0 ORDER BY T2.won DESC LIMIT 1

Database: world_development_indicators
Question: Name the countries' long name with national accounts base year prior to 1980.
Evidence: national accounts base year prior to 1980 means before 1980 and refers to NationalAccountsBaseYear<1980;
SQL: SELECT LongName FROM Country WHERE NationalAccountsBaseYear < '1980' AND NationalAccountsBaseYear != ''

Database: talkingdata
Question: How many users installed the app but are not active?
Evidence: installed refers to is_installed = 1; not active refers to is_active = 0;
SQL: SELECT COUNT(app_id) FROM app_events WHERE is_installed = 1 AND is_active = 0

Database: superstore
Question: From which city and state does the customer that bought the product with the highest sales?
Evidence: highest sales refers to max(Sales)
SQL: SELECT T5.City, T5.State FROM west_superstore AS T1 INNER JOIN east_superstore AS T2 ON T1.`Customer ID` = T2.`Customer ID` INNER JOIN central_superstore AS T3 ON T3.`Customer ID` = T2.`Customer ID` INNER JOIN south_superstore AS T4 ON T4.`Customer ID` = T3.`Customer ID` INNER JOIN people AS T5 ON T5.`Customer ID` = T4.`Customer ID` ORDER BY T2.Sales DESC LIMIT 1

Database: disney
Question: What proportion of the total gross of all movies is from movies with songs?
Evidence: Movies with songs refer song = 'not null'; DIVIDE(SUM(total_gross where song = 'not null'), sum(total_gross)) as percentage;
SQL: SELECT CAST(COUNT(CASE WHEN T1.song IS NOT NULL THEN T2.movie_title ELSE NULL END) AS REAL) * 100 / COUNT(T2.movie_title) FROM characters AS T1 INNER JOIN movies_total_gross AS T2 ON T1.movie_title = T2.movie_title

Database: restaurant
Question: Provide a list of restaurants from Marin county.
Evidence: restaurant refers to label
SQL: SELECT T1.label FROM generalinfo AS T1 INNER JOIN geographic AS T2 ON T1.city = T2.city WHERE T2.county = 'marin county'