Database: european_football_2
Question: Which country's players have the heaviest average weights?
Evidence: heaviest average weights refers to MAX(AVG(weight))
SQL: SELECT t1.name FROM Country AS t1 INNER JOIN Match AS t2 ON t1.id = t2.country_id INNER JOIN Player AS t3 ON t2.home_player_1 = t3.player_api_id GROUP BY t1.name ORDER BY AVG(t3.weight) DESC LIMIT 1

Database: student_club
Question: How many members of Business have the Medium size of tee shirt?
Evidence: members of Economics refers to major_name = 'Business'; t_shirt_size = 'Medium'
SQL: SELECT COUNT(T2.member_id) FROM major AS T1 INNER JOIN member AS T2 ON T1.major_id = T2.link_to_major WHERE T1.major_name = 'Business' AND T2.t_shirt_size = 'Medium'

Database: formula_1
Question: Which country is the oldest driver from?
Evidence: date of birth refers to drivers.dob; The larger the birthday value, the younger the person is, and vice versa;
SQL: SELECT nationality FROM drivers WHERE dob IS NOT NULL ORDER BY dob ASC LIMIT 1

Database: card_games
Question: When was the ruling for the card 'Reminisce' created?
Evidence: Reminisce refers to name = 'Reminisce'; when created is the date
SQL: SELECT T2.date FROM cards AS T1 INNER JOIN rulings AS T2 ON T2.uuid = T1.uuid WHERE T1.name = 'Reminisce'

Database: student_club
Question: Mention the zip code of member who incurred less than 50USD.
Evidence: incurred less than 50USD refers to cost < 50
SQL: SELECT T1.zip FROM member AS T1 INNER JOIN expense AS T2 ON T1.member_id = T2.link_to_member WHERE T2.cost < 50

Database: card_games
Question: Give the code of sets have expansion type of 'expansion'?
Evidence: code of sets refers to setCode
SQL: SELECT T2.setCode FROM sets AS T1 INNER JOIN set_translations AS T2 ON T2.setCode = T1.code WHERE T1.type = 'expansion' GROUP BY T2.setCode

Database: toxicology
Question: What atoms are connected in single type bonds?
Evidence: single type bond refers to bond_type = '-';
SQL: SELECT T2.atom_id, T2.atom_id2 FROM bond AS T1 INNER JOIN connected AS T2 ON T1.bond_id = T2.bond_id WHERE T1.bond_type = '-'

Database: european_football_2
Question: When is the birthday of the football player who has the highest overall rating?
Evidence: football player who has the highest overall rating refers to MAX(overall_rating);
SQL: SELECT t1.birthday FROM Player AS t1 INNER JOIN Player_Attributes AS t2 ON t1.player_api_id = t2.player_api_id ORDER BY t2.overall_rating DESC LIMIT 1

Database: formula_1
Question: Who was the champion of 2008's Australian Grand Prix and where can I know more about him?
Evidence: only champion's finished time is represented by 'HH:MM:SS.mmm'; where can I know more refers to url
SQL: SELECT T1.forename, T1.surname, T1.url FROM drivers AS T1 INNER JOIN results AS T2 ON T1.driverId = T2.driverId INNER JOIN races AS T3 ON T3.raceId = T2.raceId WHERE T3.name = 'Australian Grand Prix' AND T2.time LIKE '_:%:__.___' AND T3.year = 2008

Database: student_club
Question: What was the notes of the fundraising on 2019/9/14?
Evidence: fundraising on 2019/9/14 refers to source = 'Fundraising' where date_received = '2019-09-14'
SQL: SELECT notes FROM income WHERE source = 'Fundraising' AND date_received = '2019-09-14'

Database: card_games
Question: How many of the banned cards are white border?
Evidence: banned card refers to status = 'Banned'; white border refers to borderColor = 'white';
SQL: SELECT COUNT(T1.id) FROM cards AS T1 INNER JOIN legalities AS T2 ON T1.uuid = T2.uuid WHERE T2.status = 'Banned' AND T1.borderColor = 'white'

Database: thrombosis_prediction
Question: Which patient has a normal proteinuria level and is diagnosed with SLE? Please give his or her patient ID.
Evidence: normal proteinuria level refers to 0 < `U-PRO` < 30; diagnosed with SLE refers to Diagnosis = 'SLE';
SQL: SELECT DISTINCT T1.ID FROM Patient AS T1 INNER JOIN Laboratory AS T2 ON T1.ID = T2.ID WHERE T2.`U-PRO` > 0 AND T2.`U-PRO` < 30 AND T1.Diagnosis = 'SLE'

Database: european_football_2
Question: For the teams with normal build-up play dribbling class in 2014, List the names of the teams with less than average chance creation passing, in descending order of chance creation passing.
Evidence: normal build-up play dribbling class refers to buildUpPlayDribblingClass = 'Normal'; in 2014 refers to date > = '2014-01-01 00:00:00' AND date < = '2014-01-31 00:00:00'; names of the teams refers to team_long_name; less than average chance creation passing = DIVIDE(SUM(chanceCreationPassing), COUNT(id)) > chanceCreationPassing;
SQL: SELECT t3.team_long_name FROM Team AS t3 INNER JOIN Team_Attributes AS t4 ON t3.team_api_id = t4.team_api_id WHERE t4.buildUpPlayDribblingClass = 'Normal' AND t4.chanceCreationPassing < ( SELECT CAST(SUM(t2.chanceCreationPassing) AS REAL) / COUNT(t1.id) FROM Team AS t1 INNER JOIN Team_Attributes AS t2 ON t1.team_api_id = t2.team_api_id WHERE t2.buildUpPlayDribblingClass = 'Normal' AND SUBSTR(t2.`date`, 1, 4) = '2014') ORDER BY t4.chanceCreationPassing DESC

Database: formula_1
Question: What is the average time in seconds of champion for each year, before year 1975?
Evidence: only champion's finished time is represented by 'HH:MM:SS.mmm'; finished the game refers to time is not null; before year 1975 refers to year < 1975;
SQL: WITH time_in_seconds AS ( SELECT T2.year, T2.raceId, T1.positionOrder, CASE WHEN T1.positionOrder = 1 THEN (CAST(SUBSTR(T1.time, 1, 1) AS REAL) * 3600) + (CAST(SUBSTR(T1.time, 3, 2) AS REAL) * 60) + CAST(SUBSTR(T1.time, 6,2) AS REAL )   + CAST(SUBSTR(T1.time, 9) AS REAL)/1000 ELSE 0 END AS time_seconds FROM results AS T1 INNER JOIN races AS T2 ON T1.raceId = T2.raceId WHERE T1.time IS NOT NULL ), champion_time AS ( SELECT year, raceId, time_seconds FROM time_in_seconds WHERE positionOrder = 1 ) SELECT year, AVG(time_seconds) FROM champion_time WHERE year < 1975 GROUP BY year HAVING AVG(time_seconds) IS NOT NULL

Database: european_football_2
Question: What is the overall rating of the football player Gabriel Tamas in year 2011?
Evidence: in year 2011 refers to strftime('%Y', date) = '2011';
SQL: SELECT t2.overall_rating FROM Player AS t1 INNER JOIN Player_Attributes AS t2 ON t1.player_api_id = t2.player_api_id WHERE t1.player_name = 'Gabriel Tamas' AND strftime('%Y', t2.date) = '2011'

Database: card_games
Question: What is the keyword found on card 'Angel of Mercy'?
Evidence: Angel of Mercy' is the name of card;
SQL: SELECT DISTINCT keywords FROM cards WHERE name = 'Angel of Mercy'

Database: student_club
Question: What is the status of the event which bought "Post Cards, Posters" on 2019/8/20?
Evidence: 'Post Cards, Posters' is an expense description; on 2019/8/20 refers to expense_date = '2019-8-20'; status of event refers to event_status
SQL: SELECT T1.event_status FROM budget AS T1 INNER JOIN expense AS T2 ON T1.budget_id = T2.link_to_budget WHERE T2.expense_description = 'Post Cards, Posters' AND T2.expense_date = '2019-08-20'

Database: superhero
Question: What is the total number of superheroes that have John as their first name?
Evidence: have John as their first name refers to full_name LIKE 'John%';
SQL: SELECT COUNT(id) FROM superhero WHERE full_name LIKE 'John%'

Database: formula_1
Question: What's the fastest lap time ever in a race for Lewis Hamilton?
Evidence: fastest lap time ever refers to min(fastestLapTime)
SQL: SELECT T2.fastestLapTime FROM drivers AS T1 INNER JOIN results AS T2 ON T2.driverId = T1.driverId WHERE T1.forename = 'Lewis' AND T1.surname = 'Hamilton' AND T2.fastestLapTime IS NOT NULL ORDER BY T2.fastestLapTime ASC LIMIT 1

Database: codebase_community
Question: Provide the display name of the user who made the vote No.6347.
Evidence: vote no. 6347 refers to Id = '6347'
SQL: SELECT T1.DisplayName FROM users AS T1 INNER JOIN votes AS T2 ON T1.Id = T2.UserId WHERE T2.Id = 6347