Database: public_review_platform
Question: What are the attribute numbers that are related to payment?
Evidence: attribute numbers refers to attribute_id; related to payment refers to attribute_name like '%payment%';
SQL: SELECT attribute_id FROM Attributes WHERE attribute_name LIKE '%payment%'

Database: cookbook
Question: How many ingredients are required to make the Raspberry Chiffon Pie?
Evidence: Raspberry Chiffon Pie refer to title
SQL: SELECT COUNT(*) FROM Recipe AS T1 INNER JOIN Quantity AS T2 ON T1.recipe_id = T2.recipe_id INNER JOIN Ingredient AS T3 ON T3.ingredient_id = T2.ingredient_id WHERE T1.title = 'Raspberry Chiffon Pie'

Database: regional_sales
Question: In which city is the store with the highest sales order unit price located?
Evidence: highest sales order unit price refers to Max(Unit Price)
SQL: SELECT T2.`City Name` FROM `Sales Orders` AS T1 INNER JOIN `Store Locations` AS T2 ON T2.StoreID = T1._StoreID WHERE REPLACE(T1.`Unit Price`, ',', '') = ( SELECT REPLACE(T1.`Unit Price`, ',', '') FROM `Sales Orders` AS T1 INNER JOIN `Store Locations` AS T2 ON T2.StoreID = T1._StoreID ORDER BY REPLACE(T1.`Unit Price`, ',', '') DESC LIMIT 1 ) ORDER BY REPLACE(T1.`Unit Price`, ',', '') DESC LIMIT 1

Database: cs_semester
Question: Calculate the GPA of the semester for Laughton Antonio.
Evidence: GPA of the semester = DIVIDE(SUM(MULTIPLY(credit, grade)), SUM(credit)); grade 'A' refers to gpa = 4; grade 'B' refers to gpa = 3; grade 'C' refers to gpa = 2; grade 'D' refers to gpa = 1;
SQL: SELECT CAST(SUM(T3.credit * CASE T1.grade WHEN 'A' THEN 4 WHEN 'B' THEN 3 WHEN 'C' THEN 2 WHEN 'D' THEN 1 ELSE 1 END) AS REAL) / COUNT(T3.credit) FROM registration AS T1 INNER JOIN student AS T2 ON T1.student_id = T2.student_id INNER JOIN course AS T3 ON T1.course_id = T3.course_id WHERE T2.f_name = 'Laughton' AND T2.l_name = 'Antonio'

Database: shipping
Question: Identify the total weight of shipments transported in 2016 by the newest Peterbilt.
Evidence: transported in 2016 refers to CAST(ship_date as DATE) = 2016; 'Peterbilt' is the make; newest refers to Max(model_year)
SQL: SELECT SUM(T2.weight) FROM truck AS T1 INNER JOIN shipment AS T2 ON T1.truck_id = T2.truck_id WHERE T1.make = 'Peterbilt' AND STRFTIME('%Y', T2.ship_date) = '2016' ORDER BY T1.model_year DESC LIMIT 1

Database: european_football_1
Question: What percentage of all tied games did the Sassuolo team play in?
Evidence: tied games refer FTR = 'D'; DIVIDE(COUNT(Div where FTR = 'D', HomeTeam = 'Sassuolo' or AwayTeam = 'Sassuolo'), COUNT(Div where HomeTeam = 'Sassuolo' or AwayTeam = 'Sassuolo')) as percentage;
SQL: SELECT CAST(SUM(CASE WHEN HomeTeam = 'Sassuolo' OR AwayTeam = 'Sassuolo' THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(FTR) FROM matchs WHERE FTR = 'D'

Database: talkingdata
Question: What is the name of the category which most users belong to?
Evidence: most users belong to refers to MAX(COUNT(app_id)); name of category refers to category;
SQL: SELECT T.category FROM ( SELECT T2.category, COUNT(T1.app_id) AS num FROM app_labels AS T1 INNER JOIN label_categories AS T2 ON T2.label_id = T1.label_id GROUP BY T1.app_id, T2.category ) AS T ORDER BY T.num DESC LIMIT 1

Database: university
Question: Give the location of the university ID 112.
Evidence: location refers to country_name
SQL: SELECT T2.country_name FROM university AS T1 INNER JOIN country AS T2 ON T1.country_id = T2.id WHERE T1.id = 112

Database: cookbook
Question: Provide the title and total time of the recipe which has the highest possibility of gaining weight.
Evidence: the highest possibility of gaining weight refers to MAX(total_fat); total time refers to recipe_id, total time refers to TOTAL(prep_min, cook_min, stnd_min)
SQL: SELECT T1.title, T1.prep_min + T1.cook_min + T1.stnd_min FROM Recipe AS T1 INNER JOIN Nutrition AS T2 ON T1.recipe_id = T2.recipe_id ORDER BY T2.total_fat DESC LIMIT 1

Database: movie_3
Question: Among all films that the customer RUTH MARTINEZ has rented, what is the percentage of it being a Music film?
Evidence: music film refers to name = 'Music'; percentage = Divide (Count(film_id where name = 'Music'), Count(film_id)) * 100
SQL: SELECT CAST(SUM(IIF(T3.name = 'Music', 1, 0)) AS REAL) * 100 / COUNT(T1.film_id) FROM film AS T1 INNER JOIN film_category AS T2 ON T1.film_id = T2.film_id INNER JOIN category AS T3 ON T2.category_id = T3.category_id INNER JOIN inventory AS T4 ON T1.film_id = T4.film_id INNER JOIN customer AS T5 ON T4.store_id = T5.store_id INNER JOIN rental AS T6 ON T4.inventory_id = T6.inventory_id WHERE T5.first_name = 'RUTH' AND T5.last_name = 'MARTINEZ'

Database: book_publishing_company
Question: What's the royalty for the bestseller book?
Evidence: qty is abbreviation for quantity; bestseller means with the most sales quantity; MAX(qty)
SQL: SELECT royalty FROM titles ORDER BY ytd_sales DESC LIMIT 1

Database: simpson_episodes
Question: Calculate the total rating of winners in OFTA Television Award and WGA Award (TV).
Evidence: winners refers to result = 'Winner'; in OFTA Television Award and WGA Award (TV) refers to award = 'OFTA Television Award' and award = 'WGA Award (TV)'
SQL: SELECT SUM(T2.rating) FROM Award AS T1 INNER JOIN Episode AS T2 ON T1.episode_id = T2.episode_id WHERE T1.award_category IN ('Jupiter Award ', 'WGA Award (TV)');

Database: movies_4
Question: Are there any post-production movies in Nederlands?
Evidence: post-production movies refers to movie_status = 'Post Production'; Nederlands refers to language_name = 'Nederlands';
SQL: SELECT DISTINCT CASE WHEN T1.movie_status = 'Post Production' THEN 'YES' ELSE 'NO' END AS YORN FROM movie AS T1 INNER JOIN movie_languages AS T2 ON T1.movie_id = T2.movie_id INNER JOIN language AS T3 ON T2.language_id = T3.language_id WHERE T3.language_name = 'Nederlands'

Database: donor
Question: How many teachers have made some type of donation for projects in Chicago?
Evidence: in Chicago refers to school_city = 'Chicago'; teachers refers to is_teacher_acct = 't'
SQL: SELECT COUNT(DISTINCT T2.teacher_acctid) FROM donations AS T1 INNER JOIN projects AS T2 ON T1.projectid = T2.projectid WHERE T1.is_teacher_acct = 't' AND T2.school_city = 'Chicago'

Database: social_media
Question: Give the location id of West Sussex State.
SQL: SELECT DISTINCT LocationID FROM location WHERE State = 'West Sussex'

Database: trains
Question: How many cars running east have double-sided tail cars?
Evidence: east is an direction; double-sided refers to sides = 'double'; tail refers to carsposition = trailPosi
SQL: SELECT COUNT(T1.id) FROM trains AS T1 INNER JOIN cars AS T2 ON T1.id = T2.train_id INNER JOIN ( SELECT train_id, MAX(position) AS trailPosi FROM cars GROUP BY train_id ) AS T3 ON T1.id = T3.train_id WHERE T1.direction = 'east' AND T2.position = T3.trailPosi AND T2.sides = 'double'

Database: public_review_platform
Question: List the category of the business with high review count but received 2 stars.
Evidence: high review count refers to review_count = 'High'; received 2 stars refers to stars = 2; category refers to category_name
SQL: SELECT T3.category_name 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.stars = 2 AND T1.review_count LIKE 'High'

Database: bike_share_1
Question: What was the mean humidity of a trip with id 4275?
Evidence: mean humidity refers to mean_humidity;
SQL: SELECT T2.mean_humidity FROM trip AS T1 INNER JOIN weather AS T2 ON T2.zip_code = T1.zip_code WHERE T1.id = 4275

Database: music_platform_2
Question: Indicate the id of the reviewer whose itunes id is 1516665400.
Evidence: "151665400" is itunes_id; id of reviewer refers to author_id
SQL: SELECT T2.author_id FROM podcasts AS T1 INNER JOIN reviews AS T2 ON T2.podcast_id = T1.podcast_id WHERE T1.itunes_id = 1516665400