Database: toxicology
Question: How many bonds which involved atom 12 does molecule TR009 have?
Evidence: TR009 is the molecule id;  involved atom 12 refers to atom_id = 'TR009_12' or atom_id2 = 'TR009_12'
SQL: SELECT COUNT(T2.bond_id) FROM bond AS T1 INNER JOIN connected AS T2 ON T1.bond_id = T2.bond_id WHERE T1.molecule_id = 'TR009' AND T2.atom_id = T1.molecule_id || '_1' AND T2.atom_id2 = T1.molecule_id || '_2'

Database: student_club
Question: Tell the phone number of "Carlo Jacobs".
Evidence: Carlo Jacobs is the full name; full name refers to first_name, last_name;
SQL: SELECT phone FROM member WHERE first_name = 'Carlo' AND last_name = 'Jacobs'

Database: debit_card_specializing
Question: How much did customer 6 consume in total between August and November 2013?
Evidence: Between August And November 2013 refers to Between 201308 And 201311; The first 4 strings of the Date values in the yearmonth table can represent year; The 5th and 6th string of the date can refer to month.
SQL: SELECT SUM(Consumption) FROM yearmonth WHERE CustomerID = 6 AND Date BETWEEN '201308' AND '201311'

Database: card_games
Question: What is the percentage of the set of cards that have Chinese Simplified as the language and are only available for online games?
Evidence: are only available for online games refers to isOnlineOnly = 1; percentage = DIVIDE(COUNT(isOnlineOnly = 1),COUNT(isOnlineOnly))*100
SQL: SELECT CAST(SUM(CASE WHEN T2.language = 'Chinese Simplified' AND T1.isOnlineOnly = 1 THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(*) FROM sets AS T1 INNER JOIN set_translations AS T2 ON T1.code = T2.setCode

Database: toxicology
Question: How many triple type bonds are there?
Evidence: triple type bonds refers to bond_type = '#'
SQL: SELECT COUNT(T.bond_id) FROM bond AS T WHERE T.bond_type = '#'

Database: card_games
Question: cards are not directly linked to language but through table 'set'. you need to add set in covered table & rephrase your question
What are the languages available for the set that card 'Angel of Mercy' is in?
Evidence: Angel of Mercy' is the name of card;
SQL: SELECT language FROM set_translations WHERE id IN ( SELECT id FROM cards WHERE name = 'Angel of Mercy' )

Database: european_football_2
Question: How many players whose first names are Adam and weigh more than 170?
Evidence: team names refers to team_long_name; speed class refers to buildUpPlaySpeedClass; buildUpPlaySpeedClass = 'Fast';
SQL: SELECT COUNT(id) FROM Player WHERE weight > 170 AND player_name LIKE 'Adam%'

Database: european_football_2
Question: List out of players whose preferred foot is left.
Evidence: preferred_foot = 'left';
SQL: SELECT DISTINCT t1.id, t1.player_name FROM Player AS t1 INNER JOIN Player_Attributes AS t2 ON t1.player_api_id = t2.player_api_id WHERE t2.preferred_foot = 'left'

Database: financial
Question: How many of the accounts are from Jesenik district?
SQL: SELECT COUNT(T2.account_id) FROM district AS T1 INNER JOIN account AS T2 ON T1.district_id = T2.district_id WHERE T1.A2 = 'Jesenik'

Database: superhero
Question: List down at least five full names of superheroes with blue eyes.
Evidence: blue eyes refers to colour.colour = 'Blue' WHERE eye_colour_id = colour.id; Name of superheroes refers to superhero_name;
SQL: SELECT T1.superhero_name FROM superhero AS T1 INNER JOIN colour AS T2 ON T1.eye_colour_id = T2.id WHERE T2.colour = 'Blue' LIMIT 5

Database: card_games
Question: What are the card numbers that don't have multiple faces on a single card and have the subtypes Angel and Wizard?
Evidence: don't have multiple faces on a single card side is null
SQL: SELECT id FROM cards WHERE subtypes = 'Angel,Wizard' AND side IS NULL

Database: toxicology
Question: Which non-carcinogenic molecules consisted more than 5 atoms?
Evidence: label = '-' means molecules are non-carcinogenic; molecules consisted more than 5 atoms refers to COUNT(molecule_id) > 5
SQL: SELECT T.molecule_id FROM ( SELECT T1.molecule_id, COUNT(T2.atom_id) FROM molecule AS T1 INNER JOIN atom AS T2 ON T1.molecule_id = T2.molecule_id WHERE T1.label = '-' GROUP BY T1.molecule_id HAVING COUNT(T2.atom_id) > 5 ) t

Database: student_club
Question: How many times was the budget in Advertisement for "Yearly Kickoff" meeting more than "October Meeting"?
Evidence: budget in Advertisement refer to category = 'Advertisement' in the budget table; DIVIDE(SUM(amount when event_name = 'Yearly Kickoff'), SUM(amount when event_name = 'October Meeting'))
SQL: SELECT CAST(SUM(CASE WHEN T2.event_name = 'Yearly Kickoff' THEN T1.amount ELSE 0 END) AS REAL) / SUM(CASE WHEN T2.event_name = 'October Meeting' THEN T1.amount ELSE 0 END) FROM budget AS T1 INNER JOIN event AS T2 ON T1.link_to_event = T2.event_id WHERE T1.category = 'Advertisement' AND T2.type = 'Meeting'

Database: thrombosis_prediction
Question: Among the patients with the normal level of triglyceride, how many of them have other symptoms observed?
Evidence: normal level of triglyceride refers to TG < 200; have other symptoms refers to Symptoms is not null;
SQL: SELECT COUNT(T1.ID) FROM Examination AS T1 INNER JOIN Laboratory AS T2 ON T1.ID = T2.ID WHERE T2.TG < 200 AND T1.Symptoms IS NOT NULL

Database: codebase_community
Question: What is the owner user id of the most valuable post?
Evidence: the most valuable post refers to MAX(FavoriteCount);
SQL: SELECT OwnerUserId FROM posts WHERE FavoriteCount = ( SELECT MAX(FavoriteCount) FROM posts )

Database: card_games
Question: What's the French name of the set of cards with "Tendo Ice Bridge" is in?
Evidence: French refers to language = 'French'; "Tendo Ice Bridge" is a translated name of a card; translated name refers to translation
SQL: SELECT T2.translation FROM cards AS T1 INNER JOIN set_translations AS T2 ON T2.setCode = T1.setCode WHERE T1.name = 'Tendo Ice Bridge' AND T2.language = 'French' AND T2.translation IS NOT NULL

Database: thrombosis_prediction
Question: What percentage of patients with a proteinuria level within the normal range have a uric acid level below the normal range?
Evidence: proteinuria level within the normal range refers to `U-PRO` > 0 AND `U-PRO` < 30; uric acid level below the normal range refers to UA < = 6.5; calculation = MULTIPLY(DIVIDE(UA < = 6.5, `U-PRO` > 0 AND `U-PRO` < 30)，100)
SQL: SELECT CAST(SUM(CASE WHEN UA <= 6.5 THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(ID) FROM Laboratory WHERE `U-PRO` > 0 AND `U-PRO` < 30

Database: formula_1
Question: Which driver was in the no. 4 grid formation when starting the race in 1989's Australian Grand Prix? Please give his forename and surname.
Evidence: the no. 4 grid formation refers to grid = 4
SQL: SELECT T3.forename, T3.surname 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 T2.grid = 4 AND T1.name = 'Australian Grand Prix' AND T1.year = 1989

Database: codebase_community
Question: How many users were adult?
Evidence: adult refers to user where Age BETWEEN 19 and 65;
SQL: SELECT COUNT(id) FROM users WHERE Age BETWEEN 19 AND 65

Database: financial
Question: How many customers who choose statement of weekly issuance are Owner?
Evidence: 'POPLATEK TYDNE' stands for weekly issuance
SQL: SELECT COUNT(T1.account_id) FROM account AS T1 INNER JOIN disp AS T2 ON T1.account_id = T2.account_id WHERE T2.type = 'OWNER' AND T1.frequency = 'POPLATEK TYDNE'

Database: california_schools
Question: Between San Diego and Santa Barbara, which county offers the most number of schools that does not offer physical building? Indicate the amount.
Evidence: 'Does not offer physical building' means Virtual = F in the database.
SQL: SELECT County, COUNT(Virtual) FROM schools WHERE (County = 'San Diego' OR County = 'Santa Barbara') AND Virtual = 'F' GROUP BY County ORDER BY COUNT(Virtual) DESC LIMIT 1