Database: toxicology
Question: Write down the atom IDs of the first and second atoms of triple bond type molecules.
Evidence: first atom refers to atom_id; second atom refers to atom_id2; triple bond refers to bond_type = '#';
SQL: SELECT T2.atom_id, T2.atom_id2 FROM bond AS T1 INNER JOIN connected AS T2 ON T1.bond_id = T2.bond_id WHERE T1.bond_type = '#'

Database: european_football_2
Question: What was the highest score of the home team in the Netherlands Eredivisie league?
Evidence: highest score of the home team refers to MAX(home_team_goal)
SQL: SELECT MAX(t2.home_team_goal) FROM League AS t1 INNER JOIN Match AS t2 ON t1.id = t2.league_id WHERE t1.name = 'Netherlands Eredivisie'

Database: thrombosis_prediction
Question: How many patients born after 1980/1/1 have an abnormal fibrinogen level?
Evidence: born after 1980/1/1 refers to Birthday > '1980-01-01'; normal fibrinogen level refers to FG between 150 and 450; Should return the number of distinct patients.
SQL: SELECT COUNT(DISTINCT T1.ID) FROM Patient AS T1 INNER JOIN Laboratory AS T2 ON T1.ID = T2.ID WHERE T2.FG <= 150 OR T2.FG >= 450 AND T1.Birthday > '1980-01-01'

Database: thrombosis_prediction
Question: How many of the patients with the most serious thrombosis cases examined in 1997 are women?
Evidence: the most serious thrombosis refers to Thrombosis = '1' (the most severe one); women refers to sex = 'F'
SQL: SELECT  COUNT(*) FROM Patient AS T1 INNER JOIN Examination AS T2 ON T1.ID = T2.ID WHERE T1.SEX = 'F' AND STRFTIME('%Y', T2.`Examination Date`) = '1997' AND T2.Thrombosis = 1

Database: card_games
Question: What are the colors of cards from ID 1-20? What are the format of these cards?
Evidence: ID 1-20 refers to id BETWEEN 1 and 20;
SQL: SELECT T1.colors, T2.format FROM cards AS T1 INNER JOIN legalities AS T2 ON T1.uuid = T2.uuid WHERE T1.id BETWEEN 1 AND 20

Database: toxicology
Question: Among the single bond molecule id, which molecules are not carcinogenic?
Evidence: label = '-' means molecules are non-carcinogenic; single bond refers to bond_type = '-';
SQL: SELECT DISTINCT T1.molecule_id FROM bond AS T1 INNER JOIN molecule AS T2 ON T1.molecule_id = T2.molecule_id WHERE T2.label = '-' AND T1.bond_type = '-'

Database: student_club
Question: For all the budgets for "November Meeting", how many of them had exceeded the budget?
Evidence: 'November Meeting' is an event name; remaining < 0 means the cost had exceeded the budget
SQL: SELECT COUNT(T2.event_id) FROM budget AS T1 INNER JOIN event AS T2 ON T1.link_to_event = T2.event_id WHERE T2.event_name = 'November Meeting' AND T1.remaining < 0

Database: financial
Question: For the female client who was born in 1976/1/29, which district did she opened her account?
Evidence: Female refers to gender = 'F'; A2 refers to district names
SQL: SELECT T1.A2 FROM district AS T1 INNER JOIN client AS T2 ON T1.district_id = T2.district_id WHERE T2.birth_date = '1976-01-29' AND T2.gender = 'F'

Database: student_club
Question: How many cities are there in Orange County, Virginia?
Evidence: Orange County is the county name, Virginia is the state name
SQL: SELECT COUNT(city) FROM zip_code WHERE county = 'Orange County' AND state = 'Virginia'

Database: formula_1
Question: What is full name of the racer who ranked 1st in the 3rd qualifying race held in the Marina Bay Street Circuit in 2008?
Evidence: Ranked 1st in the 3rd qualifying race refer to MIN(q3); 2008 is the year of race; full name of racer = forename, surname
SQL: SELECT T2.forename, T2.surname FROM qualifying AS T1 INNER JOIN drivers AS T2 on T1.driverId = T2.driverId INNER JOIN races AS T3 ON T1.raceid = T3.raceid WHERE q3 IS NOT NULL AND T3.year = 2008 AND T3.circuitId IN ( SELECT circuitId FROM circuits WHERE name = 'Marina Bay Street Circuit' ) ORDER BY CAST(SUBSTR(q3, 1, INSTR(q3, ':') - 1) AS INTEGER) * 60 + CAST(SUBSTR(q3, INSTR(q3, ':') + 1, INSTR(q3, '.') - INSTR(q3, ':') - 1) AS REAL) + CAST(SUBSTR(q3, INSTR(q3, '.') + 1) AS REAL) / 1000 ASC LIMIT 1

Database: superhero
Question: Which power do superheroes have the most of?
Evidence: power that superheroes have the most refers to MAX(COUNT(power_name))
SQL: SELECT T2.power_name FROM hero_power AS T1 INNER JOIN superpower AS T2 ON T1.power_id = T2.id GROUP BY T2.power_name ORDER BY COUNT(T1.hero_id) DESC LIMIT 1

Database: california_schools
Question: What is the eligible free rate of the 10th and 11th schools with the highest enrolment for students in grades 1 through 12?
Evidence: K-12 refers to students in grades 1 through 12; Eligible free rate for K-12 = `Free Meal Count (K-12)` / `Enrollment (K-12)`
SQL: SELECT CAST(`Free Meal Count (K-12)` AS REAL) / `Enrollment (K-12)` FROM frpm ORDER BY `Enrollment (K-12)` DESC LIMIT 9, 2

Database: student_club
Question: Among the events attended by more than 10 members of the Student_Club, how many of them are meetings?
Evidence: meetings events refers to type = 'Meeting'; attended by more than 10 members refers to COUNT(event_id) > 10
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) > 10 EXCEPT SELECT T1.event_name  FROM event AS T1  WHERE T1.type = 'Meeting'

Database: toxicology
Question: How many elements are contained in bond_id TR001_3_4?
Evidence: 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 COUNT(DISTINCT T1.element) FROM atom AS T1 INNER JOIN connected AS T2 ON T1.atom_id = T2.atom_id WHERE T2.bond_id = 'TR001_3_4'

Database: card_games
Question: How many cards with original type of "Summon - Angel" have subtype other than "Angel"?
Evidence: subtype other than Angel refers to subtypes is not 'Angel';
SQL: SELECT COUNT(id) FROM cards WHERE originalType = 'Summon - Angel' AND subtypes != 'Angel'

Database: superhero
Question: Who is the dumbest superhero?
Evidence: the dumbest superhero refers to MIN(attribute_value) where attribute_name = 'Intelligence'
SQL: SELECT T1.superhero_name FROM superhero AS T1 INNER JOIN hero_attribute AS T2 ON T1.id = T2.hero_id INNER JOIN attribute AS T3 ON T2.attribute_id = T3.id WHERE T3.attribute_name = 'Intelligence' ORDER BY T2.attribute_value LIMIT 1

Database: toxicology
Question: What elements are in the TR004_8_9 bond atoms?
Evidence: TR004_8_9 bond atoms refers to bond_id = 'TR004_8_9';
SQL: SELECT DISTINCT T1.element FROM atom AS T1 INNER JOIN connected AS T2 ON T1.atom_id = T2.atom_id WHERE T2.bond_id = 'TR004_8_9'

Database: card_games
Question: How many borderless cards are illustrated in Russian?
Evidence: borderless card refers to borderColor = 'borderless'; 'Russian' is the language;
SQL: SELECT COUNT(T1.id) FROM cards AS T1 INNER JOIN foreign_data AS T2 ON T1.uuid = T2.uuid WHERE T1.borderColor = 'borderless' AND T2.language = 'Russian'

Database: financial
Question: From Year 1995 to 2000, who are the accounts holders from 'east Bohemia'. State the account ID the frequency of statement issuance.
Evidence: Accounts holder refers to the person who own this account.
SQL: SELECT T1.account_id, T1.frequency FROM account AS T1 INNER JOIN district AS T2 ON T1.district_id = T2.district_id WHERE T2.A3 = 'east Bohemia' AND STRFTIME('%Y', T1.date) BETWEEN '1995' AND '2000'