Database: european_football_1
Question: What's the winning rate of Club Brugge in the 2021 Premier League?
Evidence: Premier League is name of division; season = 2021; Club Brugge is name of team; Club Brugge wins implies HomeTeam = 'Club Brugge' and FTR = 'H' and AwayTeam = 'Club Brugge' and FTR = 'A'; DIVIDE(SUM(COUNT(FTR = 'H' where HomeTeam = 'Club Brugge', name = 'Premier League', season = 2021), COUNT(FTR = 'A'where AwayTeam = 'Club Brugge', name = 'Premier League', season = 2021)), COUNT(Div where name = 'Premier League', season = 2021));
SQL: SELECT CAST(COUNT(CASE WHEN T1.FTR = 'H' THEN 1 ELSE NULL END) + COUNT(CASE WHEN T1.FTR = 'A' THEN 1 ELSE NULL END) AS REAL) * 100 / COUNT(t1.FTR) FROM matchs AS T1 INNER JOIN divisions AS T2 ON T1.Div = T2.division WHERE T1.season = 2021 AND T1.AwayTeam = 'Club Brugge' OR T1.HomeTeam = 'Club Brugge'

Database: mental_health_survey
Question: What was the percentage for the answer of "Yes" was given to the question "Has your employer ever formally discussed mental health (for example, as part of a wellness campaign or other official communication)?"?
Evidence: percentage = divide(count(QuestionID = 15& AnswerText = 'Yes'), count(QuestionID = 15))*100%
SQL: SELECT CAST(SUM(CASE  WHEN T1.AnswerText LIKE 'Yes' THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(T1.UserID) FROM Answer AS T1 INNER JOIN Question AS T2 ON T1.QuestionID = T2.questionid WHERE T2.questiontext LIKE 'Has your employer ever formally discussed mental health (for example, as part of a wellness campaign or other official communication)?'

Database: retails
Question: Among all the suppliers providing the part "hot spring dodger dim light", how many of them are in Europe?
Evidence: part "hot spring dodger dim light" refers to p_name = hot spring dodger dim light; Europe refers to r_name = 'EUROPE'
SQL: SELECT COUNT(T1.r_regionkey) FROM region AS T1 INNER JOIN nation AS T2 ON T1.r_regionkey = T2.n_regionkey INNER JOIN supplier AS T3 ON T2.n_nationkey = T3.s_nationkey WHERE T1.r_name = 'EUROPE'

Database: movie_3
Question: Among all the active customers, how many of them live in Arlington?
Evidence: active refers to active = 1; Arlington refers to city = 'Arlington'
SQL: SELECT COUNT(T2.customer_id) FROM address AS T1 INNER JOIN customer AS T2 ON T1.address_id = T2.address_id INNER JOIN city AS T3 ON T1.city_id = T3.city_id WHERE T2.active = 1 AND T3.city = 'Arlington'

Database: student_loan
Question: How many students were absence for 4 month?
Evidence: absence for 4 month refers to month = 4;
SQL: SELECT COUNT(name) FROM longest_absense_from_school WHERE month = 4

Database: olympics
Question: Give the id of the event "Shooting Mixed Skeet".
Evidence: "Shooting Mixed Skeet" refers to event_name = 'Shooting Mixed Skeet';
SQL: SELECT id FROM event WHERE event_name = 'Shooting Mixed Skeet'

Database: legislator
Question: Please list the official full names of all the current legislators who have served in the U.S. House.
Evidence: have served in the U.S. House refers to house_history_id is not null;
SQL: SELECT official_full_name FROM current WHERE house_history_id IS NOT NULL

Database: music_platform_2
Question: What is the average rating of the podcast "Please Excuse My Dead Aunt Sally"?
Evidence: "Please Excuse My Dead Aunty Sally" is the title of podcast; Average rating = Divide (Sum(rating), Count(rating))
SQL: SELECT AVG(T2.rating) FROM podcasts AS T1 INNER JOIN reviews AS T2 ON T2.podcast_id = T1.podcast_id WHERE T1.title = 'Please Excuse My Dead Aunt Sally'

Database: public_review_platform
Question: Describe ID and active status of the business under category of "Diagnostic Imaging".
Evidence: ID refers to business_id; category of "Diagnostic Imaging" refers to category_name = 'Diagnostic Imaging';
SQL: SELECT T2.business_id, T3.active 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 = 'Diagnostic Imaging'

Database: video_games
Question: List down the platform IDs of the games with a region ID of 3.
SQL: SELECT T2.id FROM region_sales AS T1 INNER JOIN game_platform AS T2 ON T1.game_platform_id = T2.id WHERE T1.region_id = 3

Database: menu
Question: How many dishes appeared more than once on a menu?
Evidence: appeared more than once on a menu refers to times_appeared > menus_appeared;
SQL: SELECT COUNT(*) FROM Dish WHERE times_appeared > Dish.menus_appeared

Database: restaurant
Question: List all cities in the Northern California Region.
SQL: SELECT city FROM geographic WHERE region = 'northern california'

Database: talkingdata
Question: How many category names start with the word "game"?
Evidence: category names refers to category; start with the word game refers to category like 'game%';
SQL: SELECT COUNT(label_id) FROM label_categories WHERE category LIKE 'game%'

Database: retails
Question: Please indicate the total price of order key 32.
Evidence: total price refers to o_totalprice; order key 32 refers to o_orderkey = 32
SQL: SELECT o_totalprice FROM orders WHERE o_orderkey = 32

Database: soccer_2016
Question: List the names of the first andthe second teams that played a match with the point of the winning margin lower than the 30% of the average winning margin of the matches held in 2011.
Evidence: name of the team refers to Team_Name; in 2011 refers to Match_Date LIKE '2011%'; the point of winning margin lower than 30% of the average winning margin refers to Win_Margin < multiply(avg(Win_Margin), 0.3) where Match_Date LIKE '2011%'
SQL: SELECT DISTINCT CASE WHEN T1.Win_Margin < ( SELECT AVG(Win_Margin) * 0.3 FROM Match WHERE Match_Date LIKE '2011%' ) THEN T2.Team_Name END, CASE WHEN T1.Win_Margin < ( SELECT AVG(Win_Margin) * 0.3 FROM Match WHERE Match_Date LIKE '2011%' ) THEN T3.Team_Name END FROM Match AS T1 INNER JOIN Team AS T2 ON T2.Team_Id = T1.Team_1 INNER JOIN Team AS T3 ON T3.Team_Id = T1.Team_2 WHERE T1.Match_Date LIKE '2011%'

Database: sales_in_weather
Question: How many inches of total precipitation was recorded by the weather station of store no.2 on 2012/12/25?
Evidence: store no.2 refers to store_nbr = 2; on 2012/12/25 refers to date = '2012-12-25'; total precipitation refers to preciptotal
SQL: SELECT T1.preciptotal FROM weather AS T1 INNER JOIN relation AS T2 ON T1.station_nbr = T2.station_nbr WHERE T1.`date` = '2012-12-25' AND T2.store_nbr = 2

Database: software_company
Question: Among the reference ID of under 10 who got response by marketing department, compare their education status.
Evidence: reference ID of under 10 refers to REFID < 10; got response refers to RESPONSE = 'true'; education status refers to EDUCATIONNUM;
SQL: SELECT T1.EDUCATIONNUM FROM Customers AS T1 INNER JOIN Mailings1_2 AS T2 ON T1.ID = T2.REFID WHERE T2.REFID < 10 AND T2.RESPONSE = 'true'

Database: movie_3
Question: List all the films that Karl Berr starred in and rated as PG.
Evidence: film refers to title; rated as PG refers to rating = 'PG'
SQL: SELECT T3.title FROM actor AS T1 INNER JOIN film_actor AS T2 ON T1.actor_id = T2.actor_id INNER JOIN film AS T3 ON T2.film_id = T3.film_id WHERE T1.first_name = 'KARL' AND T1.last_name = 'BERRY' AND T3.rating = 'PG'

Database: retail_complains
Question: What is the percentage of complaints about the late fee issue whose priority is 2 in 2017?
Evidence: percentage = divide(count(Complaint ID where priority = 2) , count(Complaint ID)) * 100%; in 2017 refers to year(Date received) = 2017
SQL: SELECT CAST(SUM(CASE WHEN T1.priority = 2 THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(T1.`Complaint ID`) FROM callcenterlogs AS T1 INNER JOIN events AS T2 ON T1.`Complaint ID` = T2.`Complaint ID` WHERE strftime('%Y', T1.`Date received`) = '2017'