Database: restaurant
Question: In which region can you find the highest number of Baskin Robbins restaurants?
Evidence: the highest number refers to max(count(city)); Baskin Robbins restaurant refers to label = 'baskin robbins'
SQL: SELECT T2.region AS num FROM generalinfo AS T1 INNER JOIN geographic AS T2 ON T1.city = T2.city WHERE T1.label = 'baskin robbins' GROUP BY T2.region ORDER BY COUNT(T1.city) DESC LIMIT 1

Database: olympics
Question: In which year did London hold its earliest Olympic game?
Evidence: In which year refers to games_year; London refers to city_name = 'London'; earliest Olympic game refers to MIN(games_year);
SQL: SELECT T3.games_year FROM games_city AS T1 INNER JOIN city AS T2 ON T1.city_id = T2.id INNER JOIN games AS T3 ON T1.games_id = T3.id WHERE T2.city_name = 'London' ORDER BY T3.games_year LIMIT 1

Database: european_football_1
Question: How many final-time home-team goals were there in total in all the matches of the Bundesliga division in the 2021 season?
Evidence: Bundesliga is the name of division; final-time home-team goals refers to FTHG;
SQL: SELECT SUM(T1.FTHG) FROM matchs AS T1 INNER JOIN divisions AS T2 ON T1.Div = T2.division WHERE T2.name = 'Bundesliga' AND T1.season = 2021

Database: cookbook
Question: How many recipes include the ingredient "graham cracker crumbs"?
Evidence: 'graham cracker crumbs' 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 = 'graham cracker crumbs'

Database: cs_semester
Question: Among students with low salary, how many of them have a gpa of 3.5?
Evidence: low salary refers to salary = 'low';
SQL: SELECT COUNT(T1.student_id) FROM RA AS T1 INNER JOIN student AS T2 ON T1.student_id = T2.student_id WHERE T2.gpa = 3.5 AND T1.salary = 'low'

Database: restaurant
Question: What is the city located in Bay Area of Santa Clara?
Evidence: Bay Area refers to region = 'bay area'; Santa Clara refers to county = 'santa clara county'
SQL: SELECT city FROM geographic WHERE region = 'bay area' AND county = 'santa clara county'

Database: retail_complains
Question: Which region does Noah Thompson live in?
SQL: SELECT T2.division FROM client AS T1 INNER JOIN district AS T2 ON T1.district_id = T2.district_id WHERE T1.first = 'Noah' AND T1.last = 'Thompson'

Database: bike_share_1
Question: Name the station and city with the most borrowed bike.
Evidence: the station with the most borrowed bikes refers to MAX(start_station);
SQL: SELECT T2.start_station_name, T1.city FROM station AS T1 INNER JOIN trip AS T2 ON T2.start_station_name = T1.name GROUP BY T2.start_station_name ORDER BY COUNT(T2.start_station_name) DESC LIMIT 1

Database: legislator
Question: How many districts are in Idaho?
Evidence: Idaho refers to state = 'ID';
SQL: SELECT COUNT(district) FROM `current-terms` WHERE state = 'ID'

Database: video_games
Question: Please list the names of all the games published by 10TACLE Studios.
Evidence: name refers to game_name; published by 10TACLE Studios refers to publisher_name = '10TACLE Studios'
SQL: SELECT T1.game_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 T3.publisher_name = '10TACLE Studios'

Database: chicago_crime
Question: Calculate the total beat of the crimes reported in a community area in the central side with population of 50,000 and above.
Evidence: the central side refers to side = 'Central'; population of 50,000 and above refers to population > '50000'; total beat = sum(beat) where side = 'Central' and population > '50000'
SQL: SELECT 1.0 * SUM(CASE WHEN T1.population > 50000 THEN T2.beat ELSE 0 END) AS sum FROM Community_Area AS T1 INNER JOIN Crime AS T2 ON T2.community_area_no = T1.community_area_no WHERE T1.side = 'Central'

Database: ice_hockey_draft
Question: How many players who were born in 1980 weigh 185 in pounds?
Evidence: born in 1980 refers to birthyear = 1980; weigh 185 in pounds refers to weight_in_lbs = 185;
SQL: SELECT COUNT(T2.ELITEID) FROM weight_info AS T1 INNER JOIN PlayerInfo AS T2 ON T1.weight_id = T2.weight WHERE T1.weight_in_lbs = 185 AND strftime('%Y', T2.birthdate) = '1980'

Database: bike_share_1
Question: What was duration of the longest trip started on the day that has a maximum wind speed of 30 mph?
Evidence: longest trip refers to MAX(duration); started on the day refers to start_date; maximum wind speed refers to max_wind_speed_mph; max_wind_speed_mph = 30;
SQL: SELECT T1.duration FROM trip AS T1 INNER JOIN weather AS T2 ON T2.zip_code = T1.zip_code WHERE T2.max_wind_Speed_mph = 30 ORDER BY T1.duration DESC LIMIT 1

Database: law_episode
Question: What are the keywords of the "Shield" episode?
Evidence: "Shield" episode refers to title = 'Shield'
SQL: SELECT T2.keyword FROM Episode AS T1 INNER JOIN Keyword AS T2 ON T1.episode_id = T2.episode_id WHERE T1.title = 'Shield'

Database: retails
Question: What is the total quantity available by all suppliers for the part "hot spring dodger dim light"?
Evidence: total quantity available refers to sum(ps_availqty); part "hot spring dodger dim light" refers to p_name = 'hot spring dodger dim light'
SQL: SELECT SUM(T1.ps_availqty) FROM partsupp AS T1 INNER JOIN part AS T2 ON T1.ps_partkey = T2.p_partkey WHERE T2.p_name = 'hot spring dodger dim light'

Database: public_review_platform
Question: Among all attribute names, list down the ID and attribute name which start with "music".
Evidence: attribute name which start with "music" refers to attribute_name LIKE 'music%'
SQL: SELECT attribute_id, attribute_name FROM Attributes WHERE attribute_name LIKE 'music%'

Database: movielens
Question: What is the disparate number of the comedy films that got the 1 rating?
SQL: SELECT COUNT(DISTINCT T1.movieid) FROM movies2directors AS T1 INNER JOIN u2base AS T2 ON T1.movieid = T2.movieid WHERE T2.rating = 1 AND T1.genre = 'comedy'

Database: language_corpus
Question: What is the title of the Catalan language Wikipedia page that has the highest number of different words?
Evidence: highest number of different words refers to max(words)
SQL: SELECT title FROM pages WHERE words = ( SELECT MAX(words) FROM pages )

Database: public_review_platform
Question: Find the location of businesses that has business hours from 7 am to 7 pm every Wednesday.
Evidence: location of business refers to city; business hours from 7am to 7pm refers to opening_time = '7AM' AND closing_time = '7PM'; Wednesday refers to day_of_week = 'Wednesday'
SQL: SELECT DISTINCT T1.city FROM Business AS T1 INNER JOIN Business_Hours AS T2 ON T1.business_id = T2.business_id INNER JOIN Days AS T3 ON T2.day_id = T3.day_id WHERE T2.opening_time = '7AM' AND T2.closing_time = '7PM' AND T3.day_of_week = 'Wednesday'

Database: books
Question: How many books were published by Kensington?
Evidence: "Kensington" is the publisher_name;
SQL: SELECT COUNT(T1.book_id) FROM book AS T1 INNER JOIN publisher AS T2 ON T1.publisher_id = T2.publisher_id WHERE T2.publisher_name = 'Kensington'

Database: law_episode
Question: What roles have not been credited at the end of the episodes?
Evidence: have not been credited refers to credited = ''
SQL: SELECT DISTINCT role FROM Credit WHERE credited = 'false'

Database: movie_platform
Question: For all the movies that were released in 1995, how many lower than 3 ratings did the most popularity movie had?
Evidence: released in 1995 refers to movie_release_year = '1995'; lower than 3 ratings refers to rating_score <3; most popularity movie refers to MAX(movie_popularity)
SQL: SELECT COUNT(T1.rating_score) FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T1.rating_score < 3 AND T2.movie_release_year = 1995 AND T2.movie_popularity = ( SELECT MAX(movie_popularity) FROM movies WHERE movie_release_year = 1995 )