Database: trains
Question: Please list the IDs of all the cars on train no.1 that have 2 wheels.
Evidence: train no.1 refers to train_id = 1; 2 wheels refers to wheels = 2
SQL: SELECT id FROM cars WHERE train_id = 1 AND wheels = 2

Database: public_review_platform
Question: Please list the businesses name with a rating less than 5 whose category name is men's clothing.
Evidence: businesses name refers to business_id; rating refers to stars; stars < 5;
SQL: SELECT T2.business_id FROM Categories AS T1 INNER JOIN Business_Categories AS T2 ON T1.category_id = T2.category_id INNER JOIN Business AS T3 ON T2.business_id = T3.business_id WHERE T1.category_name LIKE 'Men''s Clothing' AND T3.stars < 5

Database: book_publishing_company
Question: How many publishers are in the USA?
SQL: SELECT COUNT(pub_id) FROM publishers WHERE country = 'USA'

Database: cs_semester
Question: What is the average teaching ability of the most popular professors?
Evidence: average = AVG(teachingability); most popular professor refers to MAX(popularity);
SQL: SELECT CAST(SUM(teachingability) AS REAL) / COUNT(prof_id) FROM prof WHERE popularity = ( SELECT MAX(popularity) FROM prof )

Database: student_loan
Question: How many unemployed students have never been absent?
Evidence: never been absent refers to month = 0;
SQL: SELECT COUNT(T2.name) FROM longest_absense_from_school AS T1 INNER JOIN unemployed AS T2 ON T2.name = T1.name WHERE T1.month = 0

Database: world
Question: Provide the language used in the country ruled by Pierre Buyoya.
Evidence: ruled by Pierre Buyoya refers to HeadOfState = 'Pierre Buyoya';
SQL: SELECT T1.Language FROM CountryLanguage AS T1 INNER JOIN Country AS T2 ON T1.CountryCode = T2.Code WHERE T2.HeadOfState = 'Pierre Buyoya'

Database: beer_factory
Question: Give the name of the brands that brewed their first drink between 1996 and 2000 in the descending order of the date brewed.
Evidence: name of the brands refers to BrandName; between 1996 and 2000 refers to FirstBrewedYear > = 1996 AND FirstBrewedYear < = 2000;
SQL: SELECT BrandName FROM rootbeerbrand WHERE FirstBrewedYear BETWEEN '1996' AND '2000' ORDER BY FirstBrewedYear DESC

Database: cookbook
Question: How many times do seedless red grapes appear in the recipes?
Evidence: seedless red grapes is a name of an ingredient
SQL: SELECT COUNT(*) FROM Ingredient AS T1 INNER JOIN Quantity AS T2 ON T1.ingredient_id = T2.ingredient_id WHERE T1.name = 'seedless red grapes'

Database: social_media
Question: How many tweets are seen by more than 1000 unique users?
Evidence: seen by more than 1000 unique users refers to Reach > 1000
SQL: SELECT COUNT(TweetID) AS tweet_number FROM twitter WHERE Reach > 1000

Database: shipping
Question: Among the shipments done by Sue Newell, how many of them are for S K L Enterprises Inc?
Evidence: "S K L Enterprises Inc" is the cust_name
SQL: SELECT COUNT(*) FROM customer AS T1 INNER JOIN shipment AS T2 ON T1.cust_id = T2.cust_id INNER JOIN driver AS T3 ON T3.driver_id = T2.driver_id WHERE T1.cust_name = 'S K L Enterprises Inc' AND T3.first_name = 'Sue' AND T3.last_name = 'Newell'

Database: sales
Question: List the quantity and price of the product bought by Abigail Henderson.
SQL: SELECT T2.Quantity, T1.Price FROM Products AS T1 INNER JOIN Sales AS T2 ON T1.ProductID = T2.ProductID INNER JOIN Customers AS T3 ON T2.CustomerID = T3.CustomerID WHERE T3.FirstName = 'Abigail' AND T3.LastName = 'Henderson'

Database: law_episode
Question: Who is the script supervisor of the series in episode tt0629204?
Evidence: who refers to name; script supervisor refers to role = 'script supervisor'; episode tt0629204 refers to episode_id = 'tt0629204'
SQL: SELECT T2.name FROM Credit AS T1 INNER JOIN Person AS T2 ON T2.person_id = T1.person_id WHERE T1.episode_id = 'tt0629204' AND T1.role = 'script supervisor'

Database: synthea
Question: What is the most common allergy among patients?
Evidence: the most common allergy refers to MAX(COUNT(DESCRIPTION)) from allergies;
SQL: SELECT DESCRIPTION FROM allergies GROUP BY DESCRIPTION ORDER BY COUNT(DESCRIPTION) DESC LIMIT 1

Database: cars
Question: Provide the price and country origin of the car named Ford Maverick.
Evidence: country origin refers to country; Ford Maverick refers to car_name = 'ford maverick'
SQL: SELECT DISTINCT T1.price, T3.country FROM price AS T1 INNER JOIN production AS T2 ON T1.ID = T2.ID INNER JOIN country AS T3 ON T3.origin = T2.country INNER JOIN data AS T4 ON T4.ID = T1.ID WHERE T4.car_name = 'ford maverick'

Database: car_retails
Question: Please list the top three product names with the highest unit price.
Evidence: The highest unit price refers to MAX(priceEach)
SQL: SELECT t1.productName FROM products AS t1 INNER JOIN orderdetails AS t2 ON t1.productCode = t2.productCode ORDER BY t2.priceEach DESC LIMIT 3

Database: music_tracker
Question: Provide the name of artists who released at least two bootlegs in 2016.
Evidence: at least two bootlegs refer to COUNT(releaseType = 'bootleg')≥ 2; groupYear = 2016;
SQL: SELECT artist FROM torrents WHERE groupYear = 2016 AND releaseType LIKE 'bootleg' GROUP BY artist HAVING COUNT(releaseType) > 2

Database: image_and_language
Question: How many objects can you spot in image no. 72? What objects may be identified on the same image and within the bounding box represented as (341, 27, 42, 51)?
Evidence: How many objects refers to OBJ_CLASS_ID; image no. 72 refers to IMG_ID = 72; What objects refers to OBJ_CLASS; bounding box represented as (341, 27, 42, 51) refers to X = 341 and Y = 27 and W = 42 and H = 51
SQL: SELECT SUM(IIF(T1.IMG_ID = 1, 1, 0)), SUM(IIF(T1.X = 341 AND T1.Y = 27 AND T1.W = 42 AND T1.H = 51, 1, 0)) FROM IMG_OBJ AS T1 INNER JOIN OBJ_CLASSES AS T2 ON T1.OBJ_CLASS_ID = T2.OBJ_CLASS_ID

Database: superstore
Question: Who order from the west region on August 12, 2013, and received a discount of 0.2?
Evidence: Who refers to "Customer Name"; on August 12, 2013 refers to "Order Date" = '2013-08-12'; discount of 0.2 refers to discount = 0.2
SQL: SELECT DISTINCT T2.`Customer Name` FROM west_superstore AS T1 INNER JOIN people AS T2 ON T1.`Customer ID` = T2.`Customer ID` WHERE T1.`Order Date` = '2013-08-12' AND T1.Discount = 0.2 AND T1.Region = 'West'

Database: simpson_episodes
Question: How many additional timers were born in USA?
Evidence: additional timers refers to role = 'additional timer'; born in USA refers to birth_country = 'USA'
SQL: SELECT COUNT(*) FROM Person AS T1 INNER JOIN Credit AS T2 ON T1.name = T2.person WHERE T2.role = 'additional timer' AND T1.birth_country = 'USA';

Database: music_platform_2
Question: To which categories do the podcasts of the reviewer whose id is EFB34EAC8E9397C belong?
Evidence: reviewer whose id is EFB34EAC8E9397C refers to author_id = 'EFB34EAC8E9397C'
SQL: SELECT DISTINCT T1.category FROM categories AS T1 INNER JOIN reviews AS T2 ON T2.podcast_id = T1.podcast_id WHERE T2.author_id = 'EFB34EAC8E9397C'

Database: sales
Question: What is the total sales amount for Reflector?
Evidence: total sales amount = SUM(MULTIPLY(Price, Quantity)); 'Reflector' is name of product;
SQL: SELECT SUM(T1.Price * T2.quantity) FROM Products AS T1 INNER JOIN Sales AS T2 ON T1.ProductID = T2.ProductID WHERE T1.Name = 'Reflector'

Database: movies_4
Question: What is the genre of the movie title with the lowest revenue generated?
Evidence: genre refers to genre_name; lowest revenue refers to min(revenue)
SQL: SELECT T3.genre_name FROM movie AS T1 INNER JOIN movie_genres AS T2 ON T1.movie_id = T2.movie_id INNER JOIN genre AS T3 ON T2.genre_id = T3.genre_id ORDER BY T1.revenue LIMIT 1

Database: cookbook
Question: How many calories from fat are there in the recipe "Raspberry Chiffon Pie"?
Evidence: calories from fat refers to MULTIPLY(calories, pcnt_cal_fat)||'%; Raspberry Chiffon Pie refers to title
SQL: SELECT T2.calories * T2.pcnt_cal_fat FROM Recipe AS T1 INNER JOIN Nutrition AS T2 ON T1.recipe_id = T2.recipe_id WHERE T1.title = 'Raspberry Chiffon Pie'