Database: bike_share_1
Question: Count the number of subscribers who started their trips in Market at 4th.
Evidence: subsscriber refers to subscription_type = subscriber; started their trips in refers to start_station_name; start_station_name = 'Market at 4th';
SQL: SELECT COUNT(CASE WHEN subscription_type = 'Subscriber' AND start_station_name = 'Market at 4th' THEN id END) FROM trip

Database: cookbook
Question: How many times is the sodium content in Lasagne-Spinach Spirals to Beef and Spinach Pita Pockets?
Evidence: sodium is a name of an ingredient; calculation = DIVIDE(SUM(title = 'Lasagne-Spinach Spirals' THEN sodium), SUM(title = 'Beef and Spinach Pita Pockets' THEN sodium))
SQL: SELECT CAST(SUM(CASE WHEN T1.title = 'Lasagne-Spinach Spirals' THEN T2.sodium ELSE 0 END) AS REAL) * 100 / SUM(CASE WHEN T1.title = 'Beef and Spinach Pita Pockets' THEN T2.sodium ELSE 0 END) FROM Recipe AS T1 INNER JOIN Nutrition AS T2 ON T1.recipe_id = T2.recipe_id

Database: shakespeare
Question: What are the descriptions of the short chapters?
Evidence: short chapters refers to ParagraphNum < 150
SQL: SELECT DISTINCT T2.Description FROM paragraphs AS T1 INNER JOIN chapters AS T2 ON T1.chapter_id = T2.id WHERE T1.ParagraphNum < 150

Database: movielens
Question: Which genre contains the greatest number of non-English films?
Evidence: isEnglish = 'F' means non-English
SQL: SELECT T2.genre FROM movies AS T1 INNER JOIN movies2directors AS T2 ON T1.movieid = T2.movieid WHERE T1.isEnglish = 'F' GROUP BY T2.genre ORDER BY COUNT(T1.movieid) DESC LIMIT 1

Database: movie_platform
Question: What is the percentage of rated movies were released in year 2021?
Evidence: percentage = DIVIDE(SUM(movie_release_year = 2021), COUNT(rating_id)) as percent; movies released in year 2021 refers to movie_release_year = 2021;
SQL: SELECT CAST(SUM(CASE WHEN T1.movie_release_year = 2021 THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(*) FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id

Database: cars
Question: What is the average price of cars with 8 cylinders?
Evidence: with 8 cylinders refers to cylinders = 8; average price = avg(price) where cylinders = 8
SQL: SELECT AVG(T2.price) FROM data AS T1 INNER JOIN price AS T2 ON T1.ID = T2.ID WHERE T1.cylinders = 8

Database: language_corpus
Question: State the total pages of the words that has repeated times of 2593.
Evidence: repeated times of 2593 refers to occurrences = 2593;
SQL: SELECT COUNT(T1.pages) FROM langs AS T1 INNER JOIN langs_words AS T2 ON T1.lid = T2.lid WHERE T2.occurrences = 2593

Database: olympics
Question: How many males from Belgium have participated in an Olympic Games?
Evidence: males refer to gender = 'M'; Belgium refers to region_name = 'Belgium';
SQL: SELECT COUNT(T2.person_id) 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 = 'Belgium' AND T3.gender = 'M'

Database: mental_health_survey
Question: How many times more for the number of users who took the "mental health survey for 2017" than "mental health survey for 2018"?
Evidence: How many times more = subtract(count(UserID(SurveyID = 2017)), count(UserID(SurveyID = 2018)))
SQL: SELECT CAST(COUNT(T1.UserID) AS REAL) / ( SELECT COUNT(T1.UserID) FROM Answer AS T1 INNER JOIN Survey AS T2 ON T1.SurveyID = T2.SurveyID WHERE T2.Description = 'mental health survey for 2018' ) FROM Answer AS T1 INNER JOIN Survey AS T2 ON T1.SurveyID = T2.SurveyID WHERE T2.Description = 'mental health survey for 2017'

Database: regional_sales
Question: List out the name of products which have been applied 10% discount.
Evidence: applied 10% discount refers to Discount Applied = 0.1;
SQL: SELECT T FROM ( SELECT DISTINCT IIF(T1.`Discount Applied` = 0.1, T2.`Product Name`, NULL) AS T FROM `Sales Orders` T1 INNER JOIN Products T2 ON T2.ProductID = T1._ProductID ) WHERE T IS NOT NULL

Database: cookbook
Question: List all the ingredients for Strawberry Sorbet.
Evidence: Strawberry Sorbet refers to title
SQL: SELECT T3.name 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 = 'Strawberry Sorbet'

Database: public_review_platform
Question: Indicate the opening hours of businesses are with category in fashion.
Evidence: opening hours refers to opening_time; category refers to category_name;
SQL: SELECT T4.opening_time 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 INNER JOIN Business_Hours AS T4 ON T3.business_id = T4.business_id WHERE T1.category_name LIKE 'Fashion'

Database: retail_complains
Question: What is the oldest age of male clients?
Evidence: oldest age refers to max(age); male refers to sex = 'Male'
SQL: SELECT MAX(age) FROM client WHERE sex = 'Male'

Database: donor
Question: Who is the vendor of the resources needed by the project that had the highest cost of optional tip?
Evidence: Highest cost of the optional tip refers to Max(total_price_including_optional_support - total_price_excluding_optional_support);
SQL: SELECT T1.vendor_name FROM resources AS T1 INNER JOIN projects AS T2 ON T1.projectid = T2.projectid ORDER BY T2.total_price_including_optional_support - T2.total_price_including_optional_support DESC LIMIT 1

Database: synthea
Question: How many allergies does Mrs. Saundra Monahan have?
Evidence: allergies refer to PATIENT from allergies;
SQL: SELECT COUNT(DISTINCT T2.code) FROM patients AS T1 INNER JOIN allergies AS T2 ON T1.patient = T2.PATIENT WHERE T1.prefix = 'Mrs.' AND T1.first = 'Saundra' AND T1.last = 'Monahan'

Database: restaurant
Question: What kind of restaurants can be found at "106 E 25th Ave"?
Evidence: kind of restaurant refers to food_type; "106 E 25th Ave" refers to street_name = 'e 25th ave'
SQL: SELECT T1.food_type FROM generalinfo AS T1 INNER JOIN location AS T2 ON T1.id_restaurant = T2.id_restaurant WHERE T2.street_num = 106 AND T2.street_name = 'e 25th ave'

Database: video_games
Question: What is the average number of sales in Japan?
Evidence: in Japan refers to region_name = 'Japan'; average number of sales = multiply(avg(num_sales), 100000) where region_name = 'Japan'
SQL: SELECT AVG(T2.num_sales) * 100000 AS avg_japan FROM region AS T1 INNER JOIN region_sales AS T2 ON T1.id = T2.region_id WHERE T1.region_name = 'Japan'

Database: retails
Question: How many suppliers are from Japan?
Evidence: suppliers refer to s_nationkey; Japan is the name of the nation which refers to n_name = 'JAPAN';
SQL: SELECT COUNT(T1.c_custkey) FROM customer AS T1 INNER JOIN nation AS T2 ON T1.c_nationkey = T2.n_nationkey WHERE T2.n_name = 'JAPAN'

Database: university
Question: Which country is Harvard University in?
Evidence: Harvard University refers to university_name = 'Harvard University'; which country 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.university_name = 'Harvard University'

Database: shakespeare
Question: How many acts can be found in the comedy "Two Gentlemen of Verona"?
Evidence: comedy refers to GenreType = 'comedy'; "Two Gentlemen of Verona" refers to Title = 'Two Gentlemen of Verona'
SQL: SELECT COUNT(T1.ACT) FROM chapters AS T1 LEFT JOIN works AS T2 ON T1.work_id = T2.id WHERE T2.GenreType = 'Comedy' AND T2.Title = 'Two Gentlemen of Verona'

Database: movie_3
Question: How many films in English are for adults only?
Evidence: English is a name of a language; for adults only refers to rating = 'NC-17'
SQL: SELECT COUNT(T1.film_id) FROM film AS T1 INNER JOIN language AS T2 ON T1.language_id = T2.language_id WHERE T2.name = 'English' AND T1.rating = 'NC-17'