Database: toxicology
Question: How many double bonds does TR006 have and is it carcinogenic?
Evidence: label = '+' mean molecules are carcinogenic; label = '-' means molecules are non-carcinogenic; double bond refers to bond_type = ' = ';
SQL: SELECT COUNT(T1.bond_id), T2.label FROM bond AS T1 INNER JOIN molecule AS T2 ON T1.molecule_id = T2.molecule_id WHERE T1.bond_type = '=' AND T2.molecule_id = 'TR006' GROUP BY T2.label

Database: formula_1
Question: Please give the link of the website that shows more information about the circuits the Spanish Grand Prix used in 2009.
Evidence: link of the website refers to url
SQL: SELECT T1.url FROM circuits AS T1 INNER JOIN races AS T2 ON T2.circuitID = T1.circuitId WHERE T2.year = 2009 AND T2.name = 'Spanish Grand Prix'

Database: financial
Question: How many accounts in Beroun were opened after 1996?
SQL: SELECT COUNT(account_id) FROM account AS T1 INNER JOIN district AS T2 ON T1.district_id = T2.district_id WHERE STRFTIME('%Y', T1.date) > '1996' AND T2.A2 = 'Beroun'

Database: codebase_community
Question: List the post IDs and badge names of the user Samuel in 2013.
Evidence: Samuel refers to UserDisplayName; YEAR(CreationDate) = 2013 relates to PostId; YEAR(Date) = 2013 relates to the badge;
SQL: SELECT T1.PostId, T2.Name FROM postHistory AS T1 INNER JOIN badges AS T2 ON T1.UserId = T2.UserId WHERE T1.UserDisplayName = 'Samuel' AND STRFTIME('%Y', T1.CreationDate) = '2013' AND STRFTIME('%Y', T2.Date) = '2013'

Database: card_games
Question: Please list the names of the cards in the set "Hauptset Zehnte Edition".
Evidence: card set "Hauptset Zehnte Edition" refers to translation = 'Hauptset Zehnte Edition'
SQL: SELECT DISTINCT T1.name FROM cards AS T1 INNER JOIN set_translations AS T2 ON T2.setCode = T1.setCode WHERE T2.translation = 'Hauptset Zehnte Edition'

Database: card_games
Question: What is card number 4 in the set Coldsnap?
Evidence: card set Coldsnap refers to name = 'Coldsnap'; card number 4 refers to number = 4
SQL: SELECT T1.name FROM cards AS T1 INNER JOIN sets AS T2 ON T2.code = T1.setCode WHERE T2.name = 'Coldsnap' AND T1.number = 4

Database: codebase_community
Question: List the comments commented by the user with a username of Harvey Motulsky.
Evidence: comments refer to Text; username of Harvey Motulsky refers to DisplayName = 'Harvey Motulsky';
SQL: SELECT T1.Text FROM comments AS T1 INNER JOIN users AS T2 ON T1.UserId = T2.Id WHERE T2.DisplayName = 'Harvey Motulsky'

Database: codebase_community
Question: Write all comments made by user 'A Lion.'
Evidence: "A Lion" is the DisplayName of user; comment refers to Text
SQL: SELECT T2.Text FROM users AS T1 INNER JOIN comments AS T2 ON T1.Id = T2.UserId WHERE T1.DisplayName = 'A Lion'

Database: thrombosis_prediction
Question: What is the percentage of female patient had total protein not within the normal range?
Evidence: female refers to sex = 'F'; total protein not within the normal range refers to TP < '6.0' or TP > '8.5'; calculation = DIVIDE((ID where sex = 'F' and TP < '6.0' or TP > '8.5'), COUNT(ID)) * 100
SQL: SELECT CAST(SUM(CASE WHEN T1.SEX = 'F' AND (T2.TP < 6.0 OR T2.TP > 8.5) THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(*) FROM Patient AS T1 INNER JOIN Laboratory AS T2 ON T1.ID = T2.ID WHERE T1.SEX = 'F'

Database: financial
Question: List the loan ID, district and average salary for loan with duration of 60 months.
Evidence: A3 refers to regions; A11 refers to average salary
SQL: SELECT T3.loan_id, T2.A2, T2.A11 FROM account AS T1 INNER JOIN district AS T2 ON T1.district_id = T2.district_id INNER JOIN loan AS T3 ON T1.account_id = T3.account_id WHERE T3.duration = 60

Database: california_schools
Question: What is the website for the schools under the administrations of Mike Larson and Dante Alvarez?
SQL: SELECT Website FROM schools WHERE (AdmFName1 = 'Mike' AND AdmLName1 = 'Larson') OR (AdmFName1 = 'Dante' AND AdmLName1 = 'Alvarez')

Database: thrombosis_prediction
Question: How many patients who were examined between 1987/7/6 and 1996/1/31 had a GPT level greater than 30 and an ALB level less than 4? List them by their ID.
Evidence: examined between 1987/7/6 and 1996/1/31 refers to Date BETWEEN '1987-07-06' AND '1996-01-31'; GPT level greater than 30 refers to GPT > 30; ALB level less than 4 ALB < 4
SQL: SELECT DISTINCT ID FROM Laboratory WHERE Date BETWEEN '1987-07-06' AND '1996-01-31' AND GPT > 30 AND ALB < 4

Database: student_club
Question: List all the names of events that had an attendance of over 20 students but were not fundraisers.
Evidence: name of events refers to event_name; attendance of over 20 students COUNT(event_id) > 20.
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_id HAVING COUNT(T2.link_to_event) > 20 EXCEPT SELECT T1.event_name FROM event AS T1  WHERE T1.type = 'Fundraiser'

Database: card_games
Question: What's the German type of the card "Ancestor's Chosen"?
Evidence: German refers to language = 'German'; "Ancestor's Chosen" refers to name = 'Ancestor''s Chosen'
SQL: SELECT DISTINCT T1.type FROM cards AS T1 INNER JOIN foreign_data AS T2 ON T2.uuid = T1.uuid WHERE T1.name = 'Ancestor''s Chosen' AND T2.language = 'German'

Database: formula_1
Question: Among all the lap records set on various circuits, what is the time for the fastest one?
SQL: SELECT time FROM lapTimes ORDER BY (CASE WHEN INSTR(time, ':') <> INSTR(SUBSTR(time, INSTR(time, ':') + 1), ':') + INSTR(time, ':') THEN CAST(SUBSTR(time, 1, INSTR(time, ':') - 1) AS REAL) * 3600 ELSE 0 END) + (CAST(SUBSTR(time, INSTR(time, ':') - 2 * (INSTR(time, ':') = INSTR(SUBSTR(time, INSTR(time, ':') + 1), ':') + INSTR(time, ':')), INSTR(time, ':') - 1) AS REAL) * 60) + (CAST(SUBSTR(time, INSTR(time, ':') + 1, INSTR(time, '.') - INSTR(time, ':') - 1) AS REAL)) + (CAST(SUBSTR(time, INSTR(time, '.') + 1) AS REAL) / 1000) ASC LIMIT 1

Database: codebase_community
Question: List the creation date and age of the user that commented with webiste.
Evidence: commented with webiste refers to the value contains 'http://'
SQL: SELECT T2.CreationDate, T2.Age FROM comments AS T1 INNER JOIN users AS T2 ON T1.UserId = T2.Id WHERE T1.text LIKE '%http://%'

Database: codebase_community
Question: Name the user that commented 'thank you user93!'
Evidence: "thank you user93" is the Text of comment; user refers to DisplayName
SQL: SELECT T1.DisplayName FROM users AS T1 INNER JOIN comments AS T2 ON T1.Id = T2.UserId WHERE T2.Text = 'thank you user93!'

Database: thrombosis_prediction
Question: What was the anti-nucleus antibody concentration level for the patient id 3605340 on 1996/12/2?
Evidence: anti-nucleus antibody refers to ANA; 1996/12/2 refers to `Examination Date` = '1996-12-02'
SQL: SELECT ANA FROM Examination WHERE ID = 3605340 AND `Examination Date` = '1996-12-02'

Database: formula_1
Question: How many times did Michael Schumacher won from races hosted in Sepang International Circuit?
Evidence: win from races refers to max(points)
SQL: SELECT SUM(T2.wins) FROM drivers AS T1 INNER JOIN driverStandings AS T2 ON T2.driverId = T1.driverId INNER JOIN races AS T3 ON T3.raceId = T2.raceId INNER JOIN circuits AS T4 ON T4.circuitId = T3.circuitId WHERE T1.forename = 'Michael' AND T1.surname = 'Schumacher' AND T4.name = 'Sepang International Circuit'

Database: european_football_2
Question: How many matches were held in the league Germany 1. Bundesliga
from August to October 2008?
Evidence: Germany 1. Bundesliga refers to League.name = 'Germany 1. Bundesliga'; from August to October 2008 refers to strftime('%Y-%m', date) BETWEEN '2008-08' AND '2008-10';
SQL: SELECT COUNT(t2.id) FROM League AS t1 INNER JOIN Match AS t2 ON t1.id = t2.league_id WHERE t1.name = 'Germany 1. Bundesliga' AND SUBSTR(t2.`date`, 1, 7) BETWEEN '2008-08' AND '2008-10'