Database: european_football_2
Question: Give the name of the league had the most matches in the 2008/2009 season?
Evidence: league that had the most matches in the 2008/2009 season refers to MAX(league_name WHERE season = '2008/2009');
SQL: SELECT t1.name FROM League AS t1 JOIN Match AS t2 ON t1.id = t2.league_id WHERE t2.season = '2008/2009' GROUP BY t1.name HAVING COUNT(t2.id) = (SELECT MAX(match_count) FROM (SELECT COUNT(t2.id) AS match_count FROM Match AS t2 WHERE t2.season = '2008/2009' GROUP BY t2.league_id))

Database: student_club
Question: Calculate the total average cost that Elijah Allen spent in the events on September and October.
Evidence: Elijah Allen is the full name; full name refers to first_name, last_name; The 5th and 6th string of the expense_date in the expense table can refer to month; events in September and October refers to month(expense_date) = 9 OR month(expense_date) = 10
SQL: SELECT AVG(T2.cost) FROM member AS T1 INNER JOIN expense AS T2 ON T1.member_id = T2.link_to_member WHERE T1.last_name = 'Allen' AND T1.first_name = 'Elijah' AND (SUBSTR(T2.expense_date, 6, 2) = '09' OR SUBSTR(T2.expense_date, 6, 2) = '10')

Database: formula_1
Question: What is the website of the constructor who tallied the most total wins.
Evidence: introduction website refers to url;
SQL: SELECT T1.url FROM constructors AS T1 INNER JOIN constructorStandings AS T2 on T1.constructorId = T2.constructorId ORDER BY T2.wins DESC LIMIT 1

Database: formula_1
Question: How many driver participated in race ID number 18?
SQL: SELECT COUNT(driverId) FROM driverStandings WHERE raceId = 18

Database: thrombosis_prediction
Question: For all patient born in 1982, state if their albumin is within normal range.
Evidence: Year(Birthday) = '1982'; albumin is within normal range refers to ALB between 3.5 and 5.5
SQL: SELECT CASE WHEN T2.ALB >= 3.5 AND T2.ALB <= 5.5 THEN 'normal' ELSE 'abnormal' END FROM Patient AS T1 INNER JOIN Laboratory AS T2 ON T1.ID = T2.ID WHERE STRFTIME('%Y', T1.Birthday) = '1982'

Database: codebase_community
Question: Identify the latest badge awarded to the user with the display name Emmett.
Evidence: the latest badge refers to Name FROM badges where MAX(Date);
SQL: SELECT T1.Name FROM badges AS T1 INNER JOIN users AS T2 ON T1.UserId = T2.Id WHERE T2.DisplayName = 'Emmett' ORDER BY T1.Date DESC LIMIT 1

Database: debit_card_specializing
Question: There's one customer spent 214582.17 in the June of 2013, which currency did he/she use?
Evidence: June of 2013 means Date contains '201306' in the yearmonth.date of the database
SQL: SELECT T2.Currency FROM yearmonth AS T1 INNER JOIN customers AS T2 ON T1.CustomerID = T2.CustomerID WHERE T1.Date = '201306' AND T1.Consumption = 214582.17

Database: student_club
Question: What's Angela Sanders's major?
Evidence: Angela Sanders is the full name; full name refers to first_name, last_name; major refers to major_name.
SQL: SELECT T2.major_name FROM member AS T1 INNER JOIN major AS T2 ON T1.link_to_major = T2.major_id WHERE T1.first_name = 'Angela' AND T1.last_name = 'Sanders'

Database: student_club
Question: How many members did attend the event 'Community Theater' in 2019?
Evidence: event 'Community Theater' in 2019 refers to event_name = 'Community Theater' where YEAR(event_date) = 2019
SQL: SELECT COUNT(T2.link_to_member) FROM event AS T1 INNER JOIN attendance AS T2 ON T1.event_id = T2.link_to_event WHERE T1.event_name = 'Community Theater' AND SUBSTR(T1.event_date, 1, 4) = '2019'

Database: student_club
Question: What is the last name and position of the student that bought pizza on 09/10/2019?
Evidence: bought pizza on 09/10/2019 refers to expense_description = 'Pizza' where expense_date = '2019-09-10'
SQL: SELECT T1.last_name, T1.position FROM member AS T1 INNER JOIN expense AS T2 ON T1.member_id = T2.link_to_member WHERE T2.expense_date = '2019-09-10' AND T2.expense_description = 'Pizza'

Database: codebase_community
Question: Among the posts owned by csgillespie, how many of them are root posts?
Evidence: "csgillespie" is the DisplayName of user; root post refers to ParentId IS Null
SQL: SELECT COUNT(T1.Id) FROM posts AS T1 INNER JOIN users AS T2 ON T1.OwnerUserId = T2.Id WHERE T2.DisplayName = 'csgillespie' AND T1.ParentId IS NULL

Database: debit_card_specializing
Question: Which year recorded the most gas use paid in EUR?
SQL: SELECT SUBSTRING(T2.Date, 1, 4) FROM customers AS T1 INNER JOIN yearmonth AS T2 ON T1.CustomerID = T2.CustomerID WHERE T1.Currency = 'EUR' GROUP BY SUBSTRING(T2.Date, 1, 4) ORDER BY SUM(T2.Consumption) DESC LIMIT 1

Database: financial
Question: Among the weekly issuance accounts, how many have a loan of under 200000?
Evidence: frequency = 'POPLATEK TYDNE' stands for weekly issuance
SQL: SELECT COUNT(T1.account_id) FROM loan AS T1 INNER JOIN account AS T2 ON T1.account_id = T2.account_id WHERE T2.frequency = 'POPLATEK TYDNE' AND T1.amount < 200000

Database: codebase_community
Question: Mention the reputation of users who had obtained the badge on 7/19/2010 7:39:08 PM.
Evidence: on 7/19/2010 7:39:08 PM refers to Date = '2010-07-19 19:39:08.0'
SQL: SELECT T1.Reputation FROM users AS T1 INNER JOIN badges AS T2 ON T1.Id = T2.UserId WHERE T2.Date = '2010-07-19 19:39:08.0'

Database: thrombosis_prediction
Question: Among the patients with normal anti-SM, how many of them does not have thrombosis?
Evidence: normal anti-SM refers to SM IN('-', '+-'); SM = 'negative' means '-'; SM = '0' means '+-'; SM = '1' means '+'; does not have thrombosis refers to Thrombosis = 0;
SQL: SELECT COUNT(T1.ID) FROM Examination AS T1 INNER JOIN Laboratory AS T2 ON T1.ID = T2.ID WHERE T2.SM IN ('negative','0') AND T1.Thrombosis = 0

Database: student_club
Question: List the city and state of members enrolled under electrical and computer engineering department.
Evidence: 'Electrical and Computer Engineering Department' is the department; members enrolled refers to position = 'Member'
SQL: SELECT city, state FROM member AS T1 INNER JOIN major AS T2 ON T2.major_id = T1.link_to_major INNER JOIN zip_code AS T3 ON T3.zip_code = T1.zip WHERE department = 'Electrical and Computer Engineering Department' AND position = 'Member'

Database: superhero
Question: What is the superpowers of the superhero has Helen Parr as their full name?
Evidence: superpowers refers to power_name; Helen Parr is the full name of superhero;
SQL: SELECT T3.power_name FROM superhero AS T1 INNER JOIN hero_power AS T2 ON T1.id = T2.hero_id INNER JOIN superpower AS T3 ON T2.power_id = T3.id WHERE T1.full_name = 'Helen Parr'

Database: california_schools
Question: What is the phone number and extension number for the school with the zip code 95203-3704? Indicate the school's name.
SQL: SELECT Phone, Ext, School FROM schools WHERE Zip = '95203-3704'

Database: card_games
Question: What's the Italian name of the set of cards with "Ancestor's Chosen" is in?
Evidence: Italian is a language which refers to language = 'Italian'; with "Ancestor's Chosen" in the card set refers to name = 'Ancestor''s Chosen'
SQL: SELECT translation FROM set_translations WHERE setCode IN ( SELECT setCode FROM cards WHERE name = 'Ancestor''s Chosen' ) AND language = 'Italian'

Database: formula_1
Question: What time did the the 2010's Formula_1 race took place on the Abu Dhabi Circuit?
SQL: SELECT T2.date, T2.time FROM circuits AS T1 INNER JOIN races AS T2 ON T2.circuitID = T1.circuitId WHERE T2.year = 2010 AND T2.name = 'Abu Dhabi Grand Prix'

Database: toxicology
Question: Write down bond id for molecules that are carcinogenic.
Evidence: label = '+' mean molecules are carcinogenic
SQL: SELECT DISTINCT T1.bond_id FROM bond AS T1 INNER JOIN molecule AS T2 ON T1.molecule_id = T2.molecule_id WHERE T2.label = '+'