Database: european_football_2
Question: How much is the average build up play speed of the Heart of Midlothian team?
Evidence: Heart of Midlothian refers to team_long_name = 'Heart of Midlothian'; average build up play speed refers to  AVG(buildUpPlaySpeed)
SQL: SELECT CAST(SUM(t2.buildUpPlaySpeed) AS REAL) / COUNT(t2.id) FROM Team AS t1 INNER JOIN Team_Attributes AS t2 ON t1.team_api_id = t2.team_api_id WHERE t1.team_long_name = 'Heart of Midlothian'

Database: student_club
Question: Calculate the percentage of members who are major Business in the list?
Evidence: DIVIDE(SUM(position = 'Member' and major_name = 'Business'), COUNT(member_id)) * 100
SQL: SELECT CAST(SUM(CASE WHEN T2.major_name = 'Business' THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(T1.member_id) FROM member AS T1 INNER JOIN major AS T2 ON T2.major_id = T1.link_to_major WHERE T1.position = 'Member'

Database: card_games
Question: How many cards in the set Coldsnap have a black border color?
Evidence: card set Coldsnap refers to name = 'Coldsnap'; black border color refers to borderColor = 'black'
SQL: SELECT SUM(CASE WHEN T1.borderColor = 'black' THEN 1 ELSE 0 END) FROM cards AS T1 INNER JOIN sets AS T2 ON T2.code = T1.setCode WHERE T2.name = 'Coldsnap'

Database: toxicology
Question: What is the percentage of element chlorine in carcinogenic molecules?
Evidence: chlorine refers to element = 'cl'; label = '+' mean molecules are carcinogenic; percentage = DIVIDE(SUM(element = 'pb'); COUNT(molecule_id)) as percentage where label = '+'
SQL: SELECT CAST(COUNT( CASE WHEN T1.element = 'cl' THEN T1.element ELSE NULL END) AS REAL) * 100 / COUNT(T1.element) FROM atom AS T1 INNER JOIN molecule AS T2 ON T1.molecule_id = T2.molecule_id WHERE T2.label = '+'

Database: formula_1
Question: Among the drivers who participated in the French Grand Prix, who has the slowest time in the 3rd lap.
Evidence: slowest time refers to Max(time);
SQL: SELECT T1.driverId FROM lapTimes AS T1 INNER JOIN races AS T2 on T1.raceId = T2.raceId WHERE T2.name = 'French Grand Prix' AND T1.lap = 3 ORDER BY T1.time DESC LIMIT 1

Database: toxicology
Question: in molecules with triple bonds, how many of them are not carcinogenic?
Evidence: triple bond refers to bond_type = '#'; label = '-' means molecules are non-carcinogenic
SQL: SELECT COUNT(DISTINCT T1.molecule_id) FROM molecule AS T1 INNER JOIN bond AS T2 ON T1.molecule_id = T2.molecule_id WHERE T2.bond_type = '#' AND T1.label = '-'

Database: formula_1
Question: How many drivers managed to finish the race in the 2008 Australian Grand Prix?
Evidence: managed to finish the race refers to time is not null
SQL: SELECT COUNT(T2.driverId) FROM races AS T1 INNER JOIN results AS T2 ON T2.raceId = T1.raceId WHERE T1.name = 'Australian Grand Prix' AND T1.year = 2008 AND T2.time IS NOT NULL

Database: codebase_community
Question: Give the total number of comments posted by user ID 13.
SQL: SELECT COUNT(Id) FROM comments WHERE UserId = 13

Database: european_football_2
Question: Who are the players that tend to be attacking when their mates were doing attack moves? List down their name.
Evidence: tend to be attacking when their mates were doing attack moves refers to attacking_work_rate = 'high';
SQL: SELECT DISTINCT t1.player_name FROM Player AS t1 INNER JOIN Player_Attributes AS t2 ON t1.player_api_id = t2.player_api_id WHERE t2.attacking_work_rate = 'high'

Database: california_schools
Question: Give the names of the schools with the percent eligible for free meals in K-12 is more than 0.1 and test takers whose test score is greater than or equal to 1500?
Evidence: Percent eligible for free meals = Free Meal Count (K-12) / Total (Enrollment (K-12)
SQL: SELECT T2.`School Name` FROM satscores AS T1 INNER JOIN frpm AS T2 ON T1.cds = T2.CDSCode WHERE CAST(T2.`Free Meal Count (K-12)` AS REAL) / T2.`Enrollment (K-12)` > 0.1 AND T1.NumGE1500 > 0

Database: card_games
Question: Which of the cards that are a promotional painting have multiple faces on the same card? Please list their names.
Evidence: are a promotional painting refers to isPromo = 1; have multiple faces on the same card refers to side is not Null
SQL: SELECT DISTINCT name FROM cards WHERE isPromo = 1 AND side IS NOT NULL

Database: formula_1
Question: What is Eddie Irvine's average points scored in year 2000?
Evidence: average points = AVG(points where year = 2000)
SQL: SELECT AVG(T2.points) FROM drivers AS T1 INNER JOIN driverStandings AS T2 ON T2.driverId = T1.driverId INNER JOIN races AS T3 ON T3.raceId = T2.raceId WHERE T1.forename = 'Eddie' AND T1.surname = 'Irvine' AND T3.year = 2000

Database: codebase_community
Question: For the user with the display name of "Tiago Pasqualini", how many posts did he/she own?
Evidence: "Tiago Pasqualini" is the DisplayName;
SQL: SELECT COUNT(T1.Id) FROM users AS T1 INNER JOIN posts AS T2 ON T1.Id = T2.OwnerUserId WHERE T1.DisplayName = 'Tiago Pasqualini'

Database: formula_1
Question: Which year was the first Singapore Grand Prix?
Evidence: the first race refers to race happened in min(year);
SQL: SELECT year FROM races WHERE name = 'Singapore Grand Prix' ORDER BY year ASC LIMIT 1

Database: student_club
Question: Provide the total number of the budget amount for "September Speaker" event.
Evidence: 'September Speaker' is an event name; total number of budget amount refers to SUM(amount)
SQL: SELECT SUM(T1.amount) FROM budget AS T1 INNER JOIN event AS T2 ON T1.link_to_event = T2.event_id WHERE T2.event_name = 'September Speaker'

Database: card_games
Question: List all the card id and artist with unknown power which are legal for commander play format.
Evidence: unknown power refers to power = '*' or POWER IS NULL; commander play format refers to format = 'commander'; legal for commander play format refers to format = 'commander' where status = 'Legal'
SQL: SELECT T1.id, T1.artist FROM cards AS T1 INNER JOIN legalities AS T2 ON T1.uuid = T2.uuid WHERE T2.status = 'Legal' AND T2.format = 'commander' AND (T1.power IS NULL OR T1.power = '*')

Database: european_football_2
Question: What was the potiential for Francesco Parravicini on 2010/8/30?
Evidence: Francesco Parravicini refers to player_name = 'Francesco Parravicini'; on 2010/8/30 refers to date = '2010-08-30 00:00:00'
SQL: SELECT t2.potential FROM Player AS t1 INNER JOIN Player_Attributes AS t2 ON t1.player_api_id = t2.player_api_id WHERE SUBSTR(t2.`date`, 1, 10) = '2010-08-30' AND t1.player_name = 'Francesco Parravicini'

Database: california_schools
Question: What is the phone number of the school that has the highest number of test takers with an SAT score of over 1500?
SQL: SELECT T2.Phone FROM satscores AS T1 INNER JOIN schools AS T2 ON T1.cds = T2.CDSCode ORDER BY T1.NumGE1500 DESC LIMIT 1

Database: superhero
Question: Calculate the difference between Emil Blonsky's weight and Charles Chandler's weight.
Evidence: difference = SUBTRACT(SUM(weight_kg WHERE full_name = 'Emil Blonsky'), SUM(weight_kg WHERE full_name = 'Charles Chandler')); Emil Blonsky is the full name of superhero; Charles Chandler is the full name of superhero;
SQL: SELECT ( SELECT weight_kg FROM superhero WHERE full_name LIKE 'Emil Blonsky' ) - ( SELECT weight_kg FROM superhero WHERE full_name LIKE 'Charles Chandler' ) AS CALCULATE

Database: debit_card_specializing
Question: How many gas stations in CZE has Premium gas?
SQL: SELECT COUNT(GasStationID) FROM gasstations WHERE Country = 'CZE' AND Segment = 'Premium'

Database: financial
Question: Calculate the percentage of account from 'Decin' district for all accounts are opened in 1993.
Evidence: A2 contains the information about district.
SQL: SELECT CAST(SUM(T1.A2 = 'Decin') AS REAL) * 100 / COUNT(account_id) FROM district AS T1 INNER JOIN account AS T2 ON T1.district_id = T2.district_id WHERE STRFTIME('%Y', T2.date) = '1993'