Database: toxicology
Question: How many atoms belong to molecule id TR001?
SQL: SELECT COUNT(T.atom_id) FROM atom AS T WHERE T.molecule_id = 'TR001'

Database: toxicology
Question: Indicate the molecule id is belonging to the TR000_1_2 bond that has the first atom named TR000_1.
SQL: SELECT T2.molecule_id, T2.bond_id, T1.atom_id FROM connected AS T1 INNER JOIN bond AS T2 ON T1.bond_id = T2.bond_id WHERE T1.atom_id = 'TR000_1' AND T2.bond_id = 'TR000_1_2'

Database: card_games
Question: For the set which had 'SS2' as the code, what is its magic card market id?
Evidence: magic card market id refers to mcmId
SQL: SELECT mcmId FROM sets WHERE code = 'SS2'

Database: codebase_community
Question: For the post that got the most number of answers owned by csgillespie, how many answers did it get?
Evidence: "csgillespie" is the DisplayName of user; the most number of answer refers to Max(AnswerCount)
SQL: SELECT MAX(T1.AnswerCount) FROM posts AS T1 INNER JOIN users AS T2 ON T1.OwnerUserId = T2.Id WHERE T2.DisplayName = 'csgillespie'

Database: codebase_community
Question: How many users received commentator badges in 2014?
Evidence: Commentator is the name of the badge; year(Date) = 2014;
SQL: SELECT COUNT(Id) FROM badges WHERE Name = 'Commentator' AND STRFTIME('%Y', Date) = '2014'

Database: toxicology
Question: Which toxic element can be found in the molecule TR151?
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 DISTINCT T.element FROM atom AS T WHERE T.molecule_id = 'TR151'

Database: codebase_community
Question: What is the detailed content of the comment of the post which was created on 7/19/2010 7:37:33 PM?
Evidence: detailed content of the comment refers to Text; created on 7/19/2010 7:37:33 PM CreationDate = 2010-07-19 19:37:33.0'
SQL: SELECT T1.Text FROM comments AS T1 INNER JOIN posts AS T2 ON T1.PostId = T2.Id WHERE T1.CreationDate = '2010-07-19 19:37:33.0'

Database: student_club
Question: Please list the full names of the students in the Student_Club that come from the Art and Design Department.
Evidence: full name refers to first_name, last_name;
SQL: SELECT T1.first_name, T1.last_name FROM member AS T1 INNER JOIN major AS T2 ON T1.link_to_major = T2.major_id WHERE T2.department = 'Art and Design Department'

Database: superhero
Question: How many powers does Amazo hero have?
Evidence: Amazo hero refers to superhero_name = 'Amazo';
SQL: SELECT COUNT(T1.power_id) FROM hero_power AS T1 INNER JOIN superhero AS T2 ON T1.hero_id = T2.id WHERE T2.superhero_name = 'Amazo'

Database: formula_1
Question: What's the location coordinates of Silverstone Circuit?
Evidence: location coordinates refers to (lat, lng); Silverstone Circuit refers to circuits.name = 'Silverstone Circuit'
SQL: SELECT lat, lng FROM circuits WHERE name = 'Silverstone Circuit'

Database: toxicology
Question: Which element is the least numerous in non-carcinogenic molecules?
Evidence: label = '-' means molecules are non-carcinogenic; least numerous refers to MIN(COUNT(element));
SQL: SELECT T.element FROM (SELECT T1.element, COUNT(DISTINCT T1.molecule_id) FROM atom AS T1 INNER JOIN molecule AS T2 ON T1.molecule_id = T2.molecule_id WHERE T2.label = '-' GROUP BY T1.element ORDER BY COUNT(DISTINCT T1.molecule_id) ASC LIMIT 1) t

Database: formula_1
Question: What race number has the most finishers?
Evidence: finisher refers to time is not null;
SQL: SELECT raceId FROM results GROUP BY raceId ORDER BY COUNT(time IS NOT NULL) DESC LIMIT 1

Database: codebase_community
Question: What is the average score of the posts owned by the user csgillespie?
Evidence: "csgillespie" is the DisplayName of user; average score refers to AVG(Score)
SQL: SELECT AVG(T1.Score) FROM posts AS T1 INNER JOIN users AS T2 ON T1.OwnerUserId = T2.Id WHERE T2.DisplayName = 'csgillespie'

Database: european_football_2
Question: Who has the highest average finishing rate between the highest and shortest football player?
Evidence: finishing rate refers to finishing; highest average finishing rate = MAX(AVG(finishing)); highest football player refers to MAX(height); shortest football player refers to MIN(height);
SQL: SELECT A FROM ( SELECT AVG(finishing) result, 'Max' A FROM Player AS T1 INNER JOIN Player_Attributes AS T2 ON T1.player_api_id = T2.player_api_id WHERE T1.height = ( SELECT MAX(height) FROM Player ) UNION SELECT AVG(finishing) result, 'Min' A FROM Player AS T1 INNER JOIN Player_Attributes AS T2 ON T1.player_api_id = T2.player_api_id WHERE T1.height = ( SELECT MIN(height) FROM Player ) ) ORDER BY result DESC LIMIT 1

Database: codebase_community
Question: Among the users located in United Kingdom, how many users whose post have a total favorite amount of 4 or more?
Evidence: favorite amount of 4 or more refers to FavoriteCount > = 4; Location = 'United Kingdom';
SQL: SELECT COUNT(T1.Id) FROM users AS T1 INNER JOIN posts AS T2 ON T1.Id = T2.OwnerUserId WHERE T1.Location = 'United Kingdom' AND T2.FavoriteCount >= 4

Database: toxicology
Question: Calculate the percentage of carcinogenic molecules which contain the Chlorine element.
Evidence: label = '+' mean molecules are carcinogenic; percentage = DIVIDE(SUM(label = '+' and element = 'cl'), COUNT(molecule_id)) as percentage
SQL: SELECT COUNT(CASE WHEN T2.label = '+' AND T1.element = 'cl' THEN T2.molecule_id ELSE NULL END) * 100 / COUNT(T2.molecule_id) FROM atom AS T1 INNER JOIN molecule AS T2 ON T1.molecule_id = T2.molecule_id

Database: european_football_2
Question: Which country is the Belgium Jupiler League from?
Evidence: Belgium Jupiler League refers to League.name = 'Belgium Jupiler League';
SQL: SELECT t1.name FROM Country AS t1 INNER JOIN League AS t2 ON t1.id = t2.country_id WHERE t2.name = 'Belgium Jupiler League'

Database: codebase_community
Question: Among the users who have more than 100 upvotes, how many of them have more then 1 downvotes?
Evidence: more than 100 upvotes refers to Upvotes > 100; more than 1 downvotes refers to Downvotes > 1
SQL: SELECT COUNT(Id) FROM users WHERE Upvotes > 100 AND Downvotes > 1

Database: thrombosis_prediction
Question: What is the anti-nucleus antibody concentration of the patient whose total bilirubin is the highest in the normal range?
Evidence: anti-nucleus antibody concentration refers to ANA; total bilirubin is the highest in the normal range refers to MAX(`T-BIL` < 2.0);
SQL: SELECT T3.ANA FROM Patient AS T1 INNER JOIN Laboratory AS T2 ON T1.ID = T2.ID INNER JOIN Examination AS T3 ON T1.ID = T3.ID WHERE T2.`T-BIL` < 2.0 ORDER BY T2.`T-BIL` DESC LIMIT 1

Database: european_football_2
Question: Find the average number of long-shot done by Ahmed Samir Farag.
Evidence: average number of long shot = DIVIDE(SUM(long_shots), COUNT(player_fifa_api_id));
SQL: SELECT CAST(SUM(t2.long_shots) AS REAL) / COUNT(t2.`date`) FROM Player AS t1 INNER JOIN Player_Attributes AS t2 ON t1.player_api_id = t2.player_api_id WHERE t1.player_name = 'Ahmed Samir Farag'

Database: card_games
Question: Which Russian set of cards contains the most cards overall?
Evidence: Russian refers to language = 'Russian'; contains the most cards overall refers to MAX(baseSetSize)
SQL: SELECT T1.id FROM sets AS T1 INNER JOIN set_translations AS T2 ON T1.code = T2.setCode WHERE T2.language = 'Russian' GROUP BY T1.baseSetSize ORDER BY T1.baseSetSize DESC LIMIT 1