Database: formula_1
Question: List out the code for drivers who have nationality in America.
Evidence: nationality = 'America'
SQL: SELECT code FROM drivers WHERE Nationality = 'American'

Database: toxicology
Question: Of all the carcinogenic molecules, which one has the most double bonds?
Evidence: label = '+' mean molecules are carcinogenic; double bond refers to bond_type = ' = ';
SQL: SELECT T.molecule_id FROM ( SELECT T3.molecule_id, COUNT(T1.bond_type) FROM bond AS T1 INNER JOIN molecule AS T3 ON T1.molecule_id = T3.molecule_id WHERE T3.label = '+' AND T1.bond_type = '=' GROUP BY T3.molecule_id ORDER BY COUNT(T1.bond_type) DESC LIMIT 1 ) AS T

Database: thrombosis_prediction
Question: What is the average age of the male patient with high cholesterol?
Evidence: average age = DIVIDE(SUM(SUBTRACT(YEAR(NOW()), YEAR(birthday))), COUNT(ID)); male patient refers to sex = 'M'; high cholesterol refers to `T-CHO` > = 250;
SQL: SELECT AVG(STRFTIME('%Y', date('NOW')) - STRFTIME('%Y', T1.Birthday)) FROM Patient AS T1 INNER JOIN Laboratory AS T2 ON T1.ID = T2.ID WHERE T2.`T-CHO` >= 250 AND T1.SEX = 'M'

Database: debit_card_specializing
Question: Which LAM customer used the Euro as their currency and had the highest consumption in October 2013?
Evidence: October 2013 refers to 201310 in the yearmonth.date
SQL: SELECT T1.CustomerID FROM customers AS T1 INNER JOIN yearmonth AS T2 ON T1.CustomerID = T2.CustomerID WHERE T1.Segment = 'LAM' AND T2.Date = '201310' AND T1.Currency = 'EUR' GROUP BY T1.CustomerID ORDER BY SUM(T2.Consumption) DESC LIMIT 1

Database: student_club
Question: Give the location for "Spring Budget Review".
Evidence: 'Spring Budget Review' is an event name;
SQL: SELECT location FROM event WHERE event_name = 'Spring Budget Review'

Database: card_games
Question: Did the set of cards with "Angel of Mercy" appear on Magic: The Gathering Online?
Evidence: card set "Angel of Mercy" refers to name = 'Angel of Mercy'; appear on Magic: The Gathering Online refers to mtgoCode is NOT NULL and vice versa
SQL: SELECT IIF(T2.mtgoCode IS NOT NULL, 'YES', 'NO') FROM cards AS T1 INNER JOIN sets AS T2 ON T2.code = T1.setCode WHERE T1.name = 'Angel of Mercy'

Database: superhero
Question: Please list all the superpowers of 3-D Man.
Evidence: 3-D Man refers to superhero_name = '3-D Man'; superpowers refers to power_name
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.superhero_name = '3-D Man'

Database: codebase_community
Question: Give the user's reputation and up vote number of the user that commented "fine, you win :)".
Evidence: Text = 'fine, you win :)';
SQL: SELECT T2.Reputation, T2.UpVotes FROM comments AS T1 INNER JOIN users AS T2 ON T1.UserId = T2.Id WHERE T1.Text = 'fine, you win :)'

Database: toxicology
Question: Find the percentage of atoms with single bond.
Evidence: single bond refers to bond_type = '-'; percentage = DIVIDE(SUM(bond_type = '-'), COUNT(bond_id)) as percentage
SQL: SELECT CAST(COUNT(CASE WHEN T.bond_type = '-' THEN T.bond_id ELSE NULL END) AS REAL) * 100 / COUNT(T.bond_id) FROM bond t

Database: student_club
Question: What is the category of event which was taken place in 2020-03-24T12:00:00?
Evidence: taken place in 2020-03-24T12:00:00 refers to event_date = '2020-03-24T12:00:00'
SQL: SELECT T2.category FROM event AS T1 INNER JOIN budget AS T2 ON T1.event_id = T2.link_to_event WHERE T1.event_date = '2020-03-24T12:00:00'

Database: european_football_2
Question: How was the build up play dribbling class for "LEI" on 2015/9/10?
Evidence: "LEI" refers to team_short_name = 'LEI'; on 2015/9/10 refers to  date = '2015-09-10 00:00:00'
SQL: SELECT t2.buildUpPlayDribblingClass FROM Team AS t1 INNER JOIN Team_Attributes AS t2 ON t1.team_api_id = t2.team_api_id WHERE t1.team_short_name = 'LEI' AND SUBSTR(t2.`date`, 1, 10) = '2015-09-10'

Database: toxicology
Question: Please list top two bonds that happened with the molecule TR006 in alphabetical order.
Evidence: TR006 is the molecule id
SQL: SELECT DISTINCT T2.bond_id FROM atom AS T1 INNER JOIN connected AS T2 ON T1.atom_id = T2.atom_id WHERE T1.molecule_id = 'TR006' ORDER BY T2.bond_id LIMIT 2

Database: california_schools
Question: For the school with the highest average score in Reading in the SAT test, what is its FRPM count for students aged 5-17?
SQL: SELECT T2.`FRPM Count (Ages 5-17)` FROM satscores AS T1 INNER JOIN frpm AS T2 ON T1.cds = T2.CDSCode ORDER BY T1.AvgScrRead DESC LIMIT 1

Database: toxicology
Question: How many molecules have a triple bond type?
Evidence: triple bond refers to bond_type = '#';
SQL: SELECT COUNT(DISTINCT T.molecule_id) FROM bond AS T WHERE T.bond_type = '#'

Database: toxicology
Question: Is molecule TR151 carcinogenic?
Evidence: label = '+' mean molecules are carcinogenic;
SQL: SELECT T.label FROM molecule AS T WHERE T.molecule_id = 'TR151'

Database: thrombosis_prediction
Question: For the patient who was diagnosed with SLE on 1994/2/19, what was his/her anti-Cardiolipin antibody concentration status on 1993/11/12?
Evidence: diagnosed with SLE refers to Diagnosis = 'SLE'; 1994/2/19 refers to Description = '1994-02-19'; anti-Cardiolipin refers to aCL IgM; 1993/11/12 refers to Examination Date = '1993/11/12'
SQL: SELECT `aCL IgA`, `aCL IgG`, `aCL IgM` FROM Examination WHERE ID IN ( SELECT ID FROM Patient WHERE Diagnosis = 'SLE' AND Description = '1994-02-19' ) AND `Examination Date` = '1993-11-12'

Database: formula_1
Question: For all the drivers who finished the game in race No. 592, who is the oldest?
Evidence: drivers who finished the race refers to time is not empty (i.e. time IS NOT NULL); race number refers to raceId; date of birth refers to drivers.dob; The larger the birthday value, the younger the person is, and vice versa;
SQL: SELECT T1.forename, T1.surname FROM drivers AS T1 INNER JOIN results AS T2 ON T2.driverId = T1.driverId WHERE T2.raceId = 592 AND T2.time IS NOT NULL AND T1.dob IS NOT NULL ORDER BY T1.dob ASC LIMIT 1

Database: student_club
Question: List the last name of all the students who majored Law and Constitutional Studies. 

Evidence: 'Law and Constitutional Studies' is the major name
SQL: SELECT T1.last_name FROM member AS T1 INNER JOIN major AS T2 ON T1.link_to_major = T2.major_id WHERE T2.major_name = 'Law and Constitutional Studies'

Database: formula_1
Question: List the names of all races that occurred in the earliest recorded year and month.
Evidence: earliest recorded year and month refers to year = year(min(date)) and month = month(min(date));
SQL: SELECT name FROM races WHERE STRFTIME('%Y', date) = ( SELECT STRFTIME('%Y', date) FROM races ORDER BY date ASC LIMIT 1 ) AND STRFTIME('%m', date) = ( SELECT STRFTIME('%m', date) FROM races ORDER BY date ASC LIMIT 1 )

Database: superhero
Question: Describe the names of neutral alignment superheroes.
Evidence: names of superheroes refers to superhero_name; neutral alignment refers to alignment = 'Neutral';
SQL: SELECT T1.superhero_name FROM superhero AS T1 INNER JOIN alignment AS T2 ON T1.alignment_id = T2.id WHERE T2.alignment = 'Neutral'

Database: toxicology
Question: What are the bond type for atoms with element Tin?
Evidence: element Tin refers to element = 'sn'; double bond refers to bond_type = ' = '; single bond refers to bond_type = '-'; triple bond refers to bond_type = '#'
SQL: SELECT DISTINCT T3.bond_type FROM atom AS T1 INNER JOIN connected AS T2 ON T1.atom_id = T2.atom_id INNER JOIN bond AS T3 ON T3.bond_id = T2.bond_id WHERE T1.element = 'sn'

Database: student_club
Question: Which college do most of the members go to?
Evidence: college most members go refers to MAX(COUNT(major.college))
SQL: SELECT T2.college FROM member AS T1 INNER JOIN major AS T2 ON T1.link_to_major = T2.major_id GROUP BY T2.major_id ORDER BY COUNT(T2.college) DESC LIMIT 1