Database: talkingdata
Question: What is the label ID of "Third-party card management" category?
SQL: SELECT label_id FROM label_categories WHERE category = 'Third-party card management'

Database: retail_world
Question: What products are no longer sold by Northwind?
Evidence: no longer sold refers to Discontinued = 1; products refers to ProductName
SQL: SELECT ProductName FROM Products WHERE Discontinued = 1

Database: social_media
Question: What is the gender of the user who has posted the tweet that is seen by the most number of unique users?
Evidence: seen by the most number of unique users refers to Max(Reach)
SQL: SELECT T2.Gender FROM twitter AS T1 INNER JOIN user AS T2 ON T1.UserID = T2.UserID ORDER BY T1.Reach DESC LIMIT 1

Database: car_retails
Question: To whom does the employee have to inform that is the sales representative of the French customer?
Evidence: inform refers to reportsTo; 'reportsTO' is the leader of the 'employeeNumber'; France is a country; country = 'France';
SQL: SELECT T1.reportsTo FROM employees AS T1 INNER JOIN customers AS T2 ON T1.employeeNumber = T2.salesRepEmployeeNumber WHERE T2.country = 'France'

Database: ice_hockey_draft
Question: What is the percentage of Swedish players in playoffs games in the 1997 - 2000 season?
Evidence: percentage = MULTIPLY(DIVIDE(SUM(nation = 'Sweden'), COUNT(ELITEID) WHERE SEASON = '1997-2000'), 100); Swedish refers to nation = 'Sweden'; players refers to PlayerName; playoffs games refers to GAMETYPE = 'Playoffs'; 1997-2000 season refers to 3 consecutive SEASONs : '1997-1998', '1998-1999', '1999-2000';
SQL: SELECT DISTINCT CAST(COUNT(CASE WHEN T1.nation = 'Sweden' THEN T1.ELITEID ELSE NULL END) OVER (PARTITION BY T2.SEASON) AS REAL) * 100 / COUNT(T1.ELITEID) OVER (PARTITION BY T2.SEASON) FROM PlayerInfo AS T1 INNER JOIN SeasonStatus AS T2 ON T1.ELITEID = T2.ELITEID WHERE T2.SEASON IN ('1997-1998', '1998-1999', '1999-2000')

Database: food_inspection
Question: In businesses with an owner address 500 California St, 2nd Floor of Silicon Valley, list the type of inspection of the business with the highest score.
Evidence: the highest score MAX(score); Silicon Valley is located in 'SAN FRANCISCO';
SQL: SELECT T1.type FROM inspections AS T1 INNER JOIN businesses AS T2 ON T1.business_id = T2.business_id WHERE T2.owner_address = '500 California St, 2nd Floor' AND T2.owner_city = 'SAN FRANCISCO' ORDER BY T1.score DESC LIMIT 1

Database: shakespeare
Question: Describe the scene number, act, and title of work which had the description of "The house of ANTIPHOLUS of Ephesus" in chapter.
SQL: SELECT T2.Act, T2.Scene, T1.Title FROM works AS T1 INNER JOIN chapters AS T2 ON T1.id = T2.work_id WHERE T2.Description = 'The house of ANTIPHOLUS of Ephesus.'

Database: superstore
Question: Among the customers in South superstore, which customers ordered more than 3 times in 2015? State the name of the customers.
Evidence: name of the customers refers to Customer_Name; in 2015 refers to "Order Date" BETWEEN '2015-01-01' AND '2015-12-31'; more than 3 times refers to count(Order_ID) > 3
SQL: SELECT DISTINCT T2.`Customer Name` FROM south_superstore AS T1 INNER JOIN people AS T2 ON T1.`Customer ID` = T2.`Customer ID` WHERE STRFTIME('%Y', T1.`Order Date`) = '2015' GROUP BY T2.`Customer Name` HAVING COUNT(T2.`Customer Name`) > 3

Database: college_completion
Question: Which state is "Mercer University" located in?
Evidence: Mercer University refers to chronname = 'Mercer University';
SQL: SELECT T FROM ( SELECT DISTINCT CASE WHEN chronname = 'Mercer University' THEN state ELSE NULL END AS T FROM institution_details ) WHERE T IS NOT NULL

Database: music_platform_2
Question: What is the average rating of all the podcasts with reviews created in 2019?
Evidence: created in 2019 refers to created_at BETWEEN '2019-01-01T00:00:00' and '2019-12-31T23:59:59'; average rating  = Divide (Sum(rating), Count(podcast_id))
SQL: SELECT AVG(rating) FROM reviews WHERE created_at BETWEEN '2019-01-01T00:00:00-07:00' AND '2019-12-31T23:59:59-07:00'

Database: movie_3
Question: Calculate how many percent of customers were located in India.
Evidence: 'India' is a country; calculation = DIVIDE(SUM(country = 'India'), COUNT(customer_id)) * 100
SQL: SELECT CAST(SUM(IIF(T1.country = 'India', 1, 0)) AS REAL) * 100 / COUNT(T4.customer_id) FROM country AS T1 INNER JOIN city AS T2 ON T1.country_id = T2.country_id INNER JOIN address AS T3 ON T2.city_id = T3.city_id INNER JOIN customer AS T4 ON T3.address_id = T4.address_id

Database: language_corpus
Question: What is the word id of the catalan language that was repeated no more than 10 times in the said language?
Evidence: word id refers to wid; repeated no more than 10 times refers to occurrences < = 10
SQL: SELECT wid FROM langs_words WHERE occurrences <= 10

Database: university
Question: What is the student population of the university that scored 98 in 2013?
Evidence: student population refers to num_students; in 2013 refers to year = 2013
SQL: SELECT SUM(T1.num_students) FROM university_year AS T1 INNER JOIN university_ranking_year AS T2 ON T1.university_id = T2.university_id WHERE T2.score = 98 AND T1.year = 2013

Database: olympics
Question: List out the name of the game that the people participated in games id 13.
Evidence: name of games refers to games_name;
SQL: SELECT DISTINCT T1.games_name FROM games AS T1 INNER JOIN games_competitor AS T2 ON T1.id = T2.games_id WHERE T2.games_id = 13

Database: synthea
Question: What percentage of patients born in 'Pembroke MA US' have 'allergy to grass pollen'?
Evidence: percentage = MULTIPLY(DIVIDE(SUM(patient WHERE allergies.DESCRIPTION = 'Allergy to grass pollen'), COUNT(patient) WHERE birthplace = 'Pembroke MA US'), 100.0); born in Pembroke MA US refers to birthplace = 'Pembroke MA US'; allergy to grass pollen refers to allergies.DESCRIPTION = 'Allergy to grass';
SQL: SELECT CAST(SUM(CASE WHEN T2.DESCRIPTION = 'Allergy to grass pollen' THEN 1 ELSE 0 END) AS REL) * 100 / COUNT(T1.patient) FROM patients AS T1 INNER JOIN allergies AS T2 ON T1.patient = T2.PATIENT WHERE T1.birthplace = 'Pembroke MA US'

Database: movielens
Question: What is the highest average rating for action movies made in the USA?
Evidence: USA is a country
SQL: SELECT AVG(T2.rating) FROM movies AS T1 INNER JOIN u2base AS T2 ON T1.movieid = T2.movieid INNER JOIN movies2directors AS T3 ON T1.movieid = T3.movieid WHERE T1.country = 'USA' AND T3.genre = 'Action' GROUP BY T1.movieid ORDER BY AVG(T2.rating) DESC LIMIT 1

Database: regional_sales
Question: Among the products sold in Maricopa County, which was the least sold?
Evidence: the least sold product refers to Product Name where MIN(Order Quantity);
SQL: SELECT T1.`Product Name` FROM Products AS T1 INNER JOIN `Sales Orders` AS T2 ON T2._ProductID = T1.ProductID INNER JOIN `Store Locations` AS T3 ON T3.StoreID = T2._StoreID WHERE T3.County = 'Maricopa County' ORDER BY T2.`Order Quantity` ASC LIMIT 1

Database: address
Question: Which district has the largest land area in Wisconsin? Write the full name of the congress representative and include the postal codes.
Evidence: "Wisconsin" is the state; largest land area refers to Max(land_area); full name refers to first_name, last_name; postal code refers to zip_code
SQL: SELECT T2.zip_code, T1.first_name, T1.last_name FROM congress AS T1 INNER JOIN zip_congress AS T2 ON T1.cognress_rep_id = T2.district WHERE T1.state = 'Wisconsin' ORDER BY T1.land_area DESC LIMIT 1