Database: codebase_community
Question: How many comments and answers were left by the users on the post with the title 'Clustering 1D data'?
SQL: SELECT CommentCount, AnswerCount FROM posts WHERE Title = 'Clustering 1D data'

Database: card_games
Question: For the set "From the Vault: Lore", what is its expansion type?
Evidence: set "From the Vault refers to name which contains 'From the Vault: Lore'; expansion type refers to type
SQL: SELECT type FROM sets WHERE name LIKE '%FROM the Vault: Lore%'

Database: student_club
Question: What percentage was the budget for Parking to the total budget for the "November Speaker"?
Evidence: DIVDE(SUM( amount where category = 'Parking' and event_name = 'November Speaker'), COUNT(event_name = 'November Speaker)) * 100
SQL: SELECT CAST(SUM(CASE WHEN T1.category = 'Parking' THEN T1.amount ELSE 0 END) AS REAL) * 100 / SUM(T1.amount) FROM budget AS T1 INNER JOIN event AS T2 ON T1.link_to_event = T2.event_id WHERE T2.event_name = 'November Speaker'

Database: formula_1
Question: List circuits in USA which hosted f1 races in 2006. State the name and location of circuit and the name of the race it hosted.
SQL: SELECT T1.name, T1.location, T2.name FROM circuits AS T1 INNER JOIN races AS T2 ON T2.circuitID = T1.circuitId WHERE T1.country = 'USA' AND T2.year = 2006

Database: codebase_community
Question: Please list the display names of all the users whose accounts were created in the year 2011.
Evidence: account created in the year 2011 refers to year(CreationDate) = 2011
SQL: SELECT DisplayName FROM users WHERE STRFTIME('%Y', CreationDate) = '2011'

Database: student_club
Question: List all the members of the "School of Applied Sciences, Technology and Education" department.
Evidence: list all members means to list all the full name; full name refers to first_name, last_name;
SQL: SELECT T1.first_name, T1.last_name FROM member AS T1 INNER JOIN major AS T2 ON T1.link_to_major = T2.major_id WHERE T2.department = 'School of Applied Sciences, Technology and Education'

Database: card_games
Question: Please list the Italian names of the cards in the set Coldsnap with the highest converted mana cost.
Evidence: card set Coldsnap refers to name = 'Coldsnap'; Italian refers to language = 'Italian'; highest converted mana cost refers to MAX(convertedManaCost)
SQL: SELECT T2.name FROM foreign_data AS T1 INNER JOIN cards AS T2 ON T2.uuid = T1.uuid INNER JOIN sets AS T3 ON T3.code = T2.setCode WHERE T3.name = 'Coldsnap' AND T1.language = 'Italian' ORDER BY T2.convertedManaCost DESC

Database: debit_card_specializing
Question: Who is the top spending customer and how much is the average price per single item purchased by this customer? What currency was being used?
Evidence: average price per single item = Total(price) / Total(amount)
SQL: SELECT T2.CustomerID, SUM(T2.Price / T2.Amount), T1.Currency FROM customers AS T1 INNER JOIN transactions_1k AS T2 ON T1.CustomerID = T2.CustomerID WHERE T2.CustomerID = ( SELECT CustomerID FROM yearmonth ORDER BY Consumption DESC LIMIT 1 ) GROUP BY T2.CustomerID, T1.Currency

Database: toxicology
Question: On average how many carcinogenic molecules are single bonded?
Evidence: carcinogenic molecules refers to label = '+'; single-bonded refers to bond_type = '-'; average = DIVIDE(SUM(bond_type = '-'), COUNT(atom_id))
SQL: SELECT AVG(single_bond_count) FROM (SELECT T3.molecule_id, COUNT(T1.bond_type) AS single_bond_count FROM bond AS T1  INNER JOIN atom AS T2 ON T1.molecule_id = T2.molecule_id INNER JOIN molecule AS T3 ON T3.molecule_id = T2.molecule_id WHERE T1.bond_type = '-' AND T3.label = '+' GROUP BY T3.molecule_id) AS subquery

Database: codebase_community
Question: What is the name of badge that the user whose display name is "Pierre" obtained?
SQL: SELECT T2.Name FROM users AS T1 INNER JOIN badges AS T2 ON T1.Id = T2.UserId WHERE T1.DisplayName = 'Pierre'

Database: formula_1
Question: Which year has the lowest speed of lap time?
Evidence: lowest speed of lap time refers to Max(time);
SQL: SELECT T2.year FROM lapTimes AS T1 INNER JOIN races AS T2 on T1.raceId = T2.raceId ORDER BY T1.time DESC LIMIT 1

Database: european_football_2
Question: Which player is the tallest?
Evidence: tallest player refers to MAX(height);
SQL: SELECT player_name FROM Player ORDER BY height DESC LIMIT 1

Database: european_football_2
Question: What was the final score for the match on September 24, 2008, in the Belgian Jupiler League between the home team and the away team?
Evidence: September 24, 2008 refers to date like '2008-09-24%'; in the Belgian Jupiler League refers to League.name = 'Belgium Jupiler League'; final score for home team refers to home_team_goal; final score for away team refers to away_team_goal
SQL: SELECT t2.home_team_goal, t2.away_team_goal FROM League AS t1 INNER JOIN Match AS t2 ON t1.id = t2.league_id WHERE t1.name = 'Belgium Jupiler League' AND t2.`date` LIKE '2008-09-24%'

Database: thrombosis_prediction
Question: For the year that concluded on December 31, 1998, how many male patients on average were tested in the lab each month?
Evidence: the year that concluded on December 31, 1998 refers to Date BETWEEN '1998-01-01' AND '1998-12-31'; male refers to SEX = 'M'; calculation = DIVIDE(COUNT(ID), 12)
SQL: SELECT CAST(COUNT(T1.ID) AS REAL) / 12 FROM Patient AS T1 INNER JOIN Laboratory AS T2 ON T1.ID = T2.ID WHERE STRFTIME('%Y', T2.Date) = '1998' AND T1.SEX = 'M'

Database: student_club
Question: State the name of major that Phillip Cullen has joined.
Evidence: name of major refers to major_name
SQL: SELECT T1.major_name FROM major AS T1 INNER JOIN member AS T2 ON T1.major_id = T2.link_to_major WHERE T2.first_name = 'Phillip' AND T2.last_name = 'Cullen'

Database: formula_1
Question: Name all drivers in the 2010 Singapore Grand Prix order by their position stands.
SQL: SELECT T3.forename, T3.surname FROM races AS T1 INNER JOIN driverStandings AS T2 ON T2.raceId = T1.raceId INNER JOIN drivers AS T3 ON T3.driverId = T2.driverId WHERE T1.name = 'Singapore Grand Prix' AND T1.year = 2010 ORDER BY T2.position ASC

Database: codebase_community
Question: What is the display name of the user who last edited the post "Examples for teaching: Correlation does not mean causation"?
Evidence: "Examples for teaching: Correlation does not mean causation" is the Title of post; user who last edited refers to LastEditorUserId
SQL: SELECT T2.DisplayName FROM posts AS T1 INNER JOIN users AS T2 ON T1.LastEditorUserId = T2.Id WHERE T1.Title = 'Examples for teaching: Correlation does not mean causation'

Database: student_club
Question: What is the event that has the highest attendance of the students from the Student_Club?
Evidence: event with highest attendance refers to MAX(COUNT(link_to_event))
SQL: SELECT T1.event_name FROM event AS T1 INNER JOIN attendance AS T2 ON T1.event_id = T2.link_to_event GROUP BY T1.event_name ORDER BY COUNT(T2.link_to_event) DESC LIMIT 1

Database: card_games
Question: On how many cards designed by John Avon is its foil non-powerful?
Evidence: John Avon refer to artist; foil poweful foils refers to cardKingdomId and cardKingdomFoildId is NOT NULL 

SQL: SELECT COUNT(id) FROM cards WHERE (cardKingdomId IS NULL OR cardKingdomFoilId IS NULL) AND artist = 'John Avon'

Database: california_schools
Question: Please list the codes of the schools with a total enrollment of over 500.
Evidence: Total enrollment can be represented by `Enrollment (K-12)` + `Enrollment (Ages 5-17)`
SQL: SELECT T2.CDSCode FROM schools AS T1 INNER JOIN frpm AS T2 ON T1.CDSCode = T2.CDSCode WHERE T2.`Enrollment (K-12)` + T2.`Enrollment (Ages 5-17)` > 500