Database: codebase_community
Question: How many posts with votes that were created in 2011 have a bounty of 50?
Evidence: created in 2012 refers YEAR(CreationDate) = 2011; BountyAmount = 50;
SQL: SELECT COUNT(T1.Id) FROM posts AS T1 INNER JOIN votes AS T2 ON T1.Id = T2.PostId WHERE T2.BountyAmount = 50 AND STRFTIME('%Y', T2.CreationDate) = '2011'

Database: codebase_community
Question: Please list the titles of the posts owned by the user csgillespie?
Evidence: "csgillespie" is the DisplayName of user
SQL: SELECT T1.Title FROM posts AS T1 INNER JOIN users AS T2 ON T1.OwnerUserId = T2.Id WHERE T2.DisplayName = 'csgillespie'

Database: formula_1
Question: What's the reference name of Marina Bay Street Circuit?
Evidence: reference name refers to circuitRef; Marina Bay Street Circuit refers to circuits.name = 'Marina Bay Street Circuit'
SQL: SELECT circuitRef FROM circuits WHERE name = 'Marina Bay Street Circuit'

Database: codebase_community
Question: What are the name of badge that users who have the highest reputation obtained?
Evidence: highest reputation refers to Max(Reputation); user refers to UserId
SQL: SELECT T2.name FROM users AS T1 INNER JOIN badges AS T2 ON T1.Id = T2.UserId ORDER BY T1.Reputation DESC LIMIT 1

Database: california_schools
Question: What is the administrator's email address of the chartered school with the fewest students enrolled in grades 1 through 12?
Evidence: Charted school means `Charter School (Y/N)` = 1 in the table frpm; Students enrolled in grades 1 through 12 refers to `Enrollment (K-12)`
SQL: SELECT T2.AdmEmail1 FROM frpm AS T1 INNER JOIN schools AS T2 ON T1.CDSCode = T2.CDSCode WHERE T1.`Charter School (Y/N)` = 1 ORDER BY T1.`Enrollment (K-12)` ASC LIMIT 1

Database: codebase_community
Question: What is the up vote number of the user that commented "R is also lazy evaluated."?
Evidence: commented "R is also lazy evaluated." refers to Text of the comment;
SQL: SELECT T2.UpVotes FROM comments AS T1 INNER JOIN users AS T2 ON T1.UserId = T2.Id WHERE T1.Text = 'R is also lazy evaluated.'

Database: toxicology
Question: What is the molecule of atom id "TR000_2" and atom id 2 "TR000_4"?
SQL: SELECT T1.molecule_id FROM bond AS T1 INNER JOIN connected AS T2 ON T1.bond_id = T2.bond_id WHERE T2.atom_id = 'TR000_2' AND T2.atom_id2 = 'TR000_4'

Database: formula_1
Question: What was Lewis Hamilton's final rank in the 2008 Chinese Grand Prix?
Evidence: Lewis Hamilton refers to the full name of the driver; Full name of the driver refers to drivers.forename and drivers.surname; final rank refers to positionOrder; Chinese Grand Prix refers to races.name = 'Chinese Grand Prix';
SQL: SELECT T2.positionOrder FROM races AS T1 INNER JOIN results AS T2 ON T2.raceId = T1.raceId INNER JOIN drivers AS T3 ON T3.driverId = T2.driverId WHERE T3.forename = 'Lewis' AND T3.surname = 'Hamilton' AND T1.name = 'Chinese Grand Prix' AND T1.year = 2008

Database: codebase_community
Question: What is the sum of favourite count gained by user ID 686 in 2011?
Evidence: in 2011 refers to year (CreatinDate) = 2011
SQL: SELECT SUM(DISTINCT FavoriteCount) FROM posts WHERE Id IN ( SELECT PostId FROM postHistory WHERE UserId = 686 AND STRFTIME('%Y', CreationDate) = '2011' )

Database: student_club
Question: Which student has been entrusted to manage the budget for the Yearly Kickoff?
Evidence: name of students means the full name; full name refers to first_name, last_name;'Yearly Kickoff' is an event name;
SQL: SELECT T4.first_name, T4.last_name FROM event AS T1 INNER JOIN budget AS T2 ON T1.event_id = T2.link_to_event INNER JOIN expense AS T3 ON T2.budget_id = T3.link_to_budget INNER JOIN member AS T4 ON T3.link_to_member = T4.member_id WHERE T1.event_name = 'Yearly Kickoff'

Database: toxicology
Question: What is the carcinogenic label for bond TR001_2_4?
Evidence: label = '+' mean molecules are carcinogenic
SQL: SELECT DISTINCT T2.label FROM atom AS T1 INNER JOIN molecule AS T2 ON T1.molecule_id = T2.molecule_id INNER JOIN bond AS T3 ON T2.molecule_id = T3.molecule_id WHERE T3.bond_id = 'TR001_2_4'

Database: european_football_2
Question: Who are the top 5 players who perform better in crossing actions? Indicate their player id.
Evidence: perform better in crossing actions refers to MAX(crossing)
SQL: SELECT id FROM Player_Attributes ORDER BY crossing DESC LIMIT 5

Database: toxicology
Question: How many molecules have a double bond type and among these molecule, how many are labeled as carcinogenic compound?
Evidence: double bond refers to bond_type = ' = '; label = '+' mean molecules are carcinogenic;
SQL: SELECT COUNT(DISTINCT T2.molecule_id), SUM(CASE WHEN T2.label = '+' THEN 1 ELSE 0 END) FROM bond AS T1 INNER JOIN molecule AS T2 ON T1.molecule_id = T2.molecule_id WHERE T1.bond_type = '='

Database: card_games
Question: How many sets are available just in Japanese and not in Magic: The Gathering Online?
Evidence: Japanese refers to language = 'Japanese'; not in Magic: The Gathering Online refers to mtgoCode is null or mtgoCode = ''
SQL: SELECT COUNT(T1.id) FROM sets AS T1 INNER JOIN set_translations AS T2 ON T2.setCode = T1.code WHERE T2.language = 'Japanese'  AND (T1.mtgoCode IS NULL OR T1.mtgoCode = '')

Database: toxicology
Question: List all the elements with double bond, consisted in molecule TR024.
Evidence: double bond refers to bond_type = '='; element = 'cl' means Chlorine; element = 'c' means Carbon; element = 'h' means Hydrogen; element = 'o' means Oxygen, element = 's' means Sulfur; element = 'n' means Nitrogen, element = 'p' means Phosphorus, element = 'na' means Sodium, element = 'br' means Bromine, element = 'f' means Fluorine; element = 'i' means Iodine; element = 'sn' means Tin; element = 'pb' means Lead; element = 'te' means Tellurium; element = 'ca' means Calcium
SQL: SELECT T1.element FROM atom AS T1 INNER JOIN bond AS T2 ON T1.molecule_id = T2.molecule_id WHERE T1.molecule_id = 'TR024' AND T2.bond_type = '='

Database: toxicology
Question: Among the atoms that contain element carbon, which one does not contain compound carcinogenic?
Evidence: label = '-' means molecules are non-carcinogenic; carbon refers to element = 'c'
SQL: SELECT T1.atom_id FROM atom AS T1 INNER JOIN molecule AS T2 ON T1.molecule_id = T2.molecule_id WHERE T1.element = 'c' AND T2.label = '-'

Database: european_football_2
Question: What is the average height of players born between 1990 and 1995?
Evidence: average height = DIVIDE(SUM(height), COUNT(id)); players born between 1990 and 1995 refers to birthday > = '1990-01-01 00:00:00' AND birthday < '1996-01-01 00:00:00';
SQL: SELECT SUM(height) / COUNT(id) FROM Player WHERE SUBSTR(birthday, 1, 4) BETWEEN '1990' AND '1995'

Database: toxicology
Question: What percentage of bonds have the most common combination of atoms' elements?
Evidence: DIVIDE(COUNT(bond_id), COUNT(atom_id where MAX(COUNT(atom_id)) ))
SQL: SELECT CAST((SELECT COUNT(T1.atom_id) FROM connected AS T1 INNER JOIN bond AS T2 ON T1.bond_id = T2.bond_id GROUP BY T2.bond_type ORDER BY COUNT(T2.bond_id) DESC LIMIT 1 ) AS REAL) * 100 / ( SELECT COUNT(atom_id) FROM connected )

Database: toxicology
Question: Identify all the atoms that are connected to the atoms of the TR181 molecule.
Evidence: TR181 molecule refers to molecule_id = 'TR181'
SQL: SELECT T2.atom_id, T2.atom_id2 FROM atom AS T1 INNER JOIN connected AS T2 ON T2.atom_id = T1.atom_id WHERE T1.molecule_id = 'TR181'

Database: codebase_community
Question: How many badges has the user csgillespie obtained?
Evidence: "csgillespie" is the DisplayName of user
SQL: SELECT COUNT(T1.Id) FROM badges AS T1 INNER JOIN users AS T2 ON T1.UserId = T2.Id WHERE T2.DisplayName = 'csgillespie'

Database: student_club
Question: How many of the members' hometowns are from Maryland state?
SQL: SELECT COUNT(T2.member_id) FROM zip_code AS T1 INNER JOIN member AS T2 ON T1.zip_code = T2.zip WHERE T1.state = 'Maryland'