Database: toxicology
Question: What is the molecule id of bond id TR001_1_7?
SQL: SELECT DISTINCT T1.molecule_id FROM atom AS T1 INNER JOIN connected AS T2 ON T1.atom_id = T2.atom_id WHERE T2.bond_id = 'TR001_1_7'

Database: european_football_2
Question: Give the team_fifa_api_id of teams with more than 50 but less than 60 build-up play speed.
Evidence: teams with more than 50 but less than 60 build-up play speed refers to buildUpPlaySpeed >50 AND buildUpPlaySpeed <60; 
SQL: SELECT DISTINCT team_fifa_api_id FROM Team_Attributes WHERE buildUpPlaySpeed > 50 AND buildUpPlaySpeed < 60

Database: california_schools
Question: Among the schools with the SAT test takers of over 500, please list the schools that are magnet schools or offer a magnet program.
Evidence: Magnet schools or offer a magnet program means that Magnet = 1
SQL: SELECT T2.School FROM satscores AS T1 INNER JOIN schools AS T2 ON T1.cds = T2.CDSCode WHERE T2.Magnet = 1 AND T1.NumTstTakr > 500

Database: formula_1
Question: How many British drivers who were born in 1980?
Evidence: born in 1980 refers to year(dob) = 1980;
SQL: SELECT COUNT(driverId) FROM drivers WHERE nationality = 'British' AND STRFTIME('%Y', dob) = '1980'

Database: card_games
Question: Write down the ruling of Beacon of Immortality.
Evidence: Beacon of Immortality' is the name of card;
SQL: SELECT T2.text FROM cards AS T1 INNER JOIN rulings AS T2 ON T1.uuid = T2.uuid WHERE T1.name = 'Beacon of Immortality'

Database: toxicology
Question: In the molecule containing sodium atoms, how many are non-carcinogenic?
Evidence: non-carcinogenic refers to label = '-'; sodium atoms refers to element = 'na'
SQL: SELECT COUNT(DISTINCT T2.molecule_id) FROM atom AS T1 INNER JOIN molecule AS T2 ON T1.molecule_id = T2.molecule_id WHERE T1.element = 'na' AND T2.label = '-'

Database: card_games
Question: What is the Simplified Chinese translation of the name of the set "Eighth Edition"?
Evidence: Eighth Edition is the name of card set which refers to name = 'Eighth Edition'; Simplified Chinese refers to language = 'Chinese Simplified'; translation of the name refers to translation
SQL: SELECT T2.translation FROM sets AS T1 INNER JOIN set_translations AS T2 ON T2.setCode = T1.code WHERE T1.name = 'Eighth Edition' AND T2.language = 'Chinese Simplified'

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

Database: superhero
Question: In superheroes with missing weight data, calculate the difference between the number of superheroes with blue eyes and no eye color.
Evidence: missing weight data refers to weight_kg = 0 OR T1.weight_kg = NULL; difference = SUBTRACT(SUM(colour.id = 7), SUM(colour.id = 1)); blue eyes refers to eye_colour_id WHERE colour.id = 7; no eye color refers to eye_colour_id WHERE colour.id = 1;
SQL: SELECT SUM(CASE WHEN T2.id = 7 THEN 1 ELSE 0 END) - SUM(CASE WHEN T2.id = 1 THEN 1 ELSE 0 END) FROM superhero AS T1 INNER JOIN colour AS T2 ON T1.eye_colour_id = T2.id WHERE T1.weight_kg = 0 OR T1.weight_kg is NULL

Database: thrombosis_prediction
Question: What number of patients with a degree of thrombosis level 2 and ANA pattern of only S, have a level of anti-Cardiolip in antibody (IgM) 20% higher than average?
Evidence: thrombosis level 2 refers to Thrombosis = 2; ANA pattern of only S refers to ANA = 'S'; average anti-Cardiolip in antibody (IgM) refers to AVG(`aCL IgM`); calculation = MULTIPLY(AVG + AVG, 0.2)
SQL: SELECT COUNT(*) FROM Examination WHERE Thrombosis = 2 AND `ANA Pattern` = 'S' AND `aCL IgM` > (SELECT AVG(`aCL IgM`) * 1.2 FROM Examination WHERE Thrombosis = 2 AND `ANA Pattern` = 'S')

Database: formula_1
Question: How many races were there in 2005? Name all the races in descending order.
SQL: SELECT name FROM races WHERE year = 2005 ORDER BY name DESC

Database: card_games
Question: What kind of printing is on the card that Daren Bader created?
Evidence: kind of printing refers to availability; Daren Bader created refers to artist = 'Daren Bader'
SQL: SELECT DISTINCT availability FROM cards WHERE artist = 'Daren Bader'

Database: student_club
Question: Among the students from the Student_Club who attended the event "Women's Soccer", how many of them want a T-shirt that's in medium size?
Evidence: Women's Soccer is an event name; T-shirt that is in medium size refers to t_shirt_size = 'Medium'
SQL: SELECT COUNT(T1.event_id) FROM event AS T1 INNER JOIN attendance AS T2 ON T1.event_id = T2.link_to_event INNER JOIN member AS T3 ON T2.link_to_member = T3.member_id WHERE T1.event_name = 'Women''s Soccer' AND T3.t_shirt_size = 'Medium'

Database: superhero
Question: List the power of superheroes with height greater than 80% of the average height of all superheroes.
Evidence: power of superheroes refers to power_name; height greater than 80% of the average height of all superheroes = height_cm > MULTIPLY(AVG(height_cm), 0.8);
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.height_cm * 100 > ( SELECT AVG(height_cm) FROM superhero ) * 80

Database: student_club
Question: What does the person with the phone number "809-555-3360" major in?
Evidence: major in refers to major_name
SQL: SELECT T2.major_name FROM member AS T1 INNER JOIN major AS T2 ON T1.link_to_major = T2.major_id WHERE T1.phone = '809-555-3360'

Database: european_football_2
Question: How was Francesco Migliore's attacking work rate on 2015/5/1?
Evidence: Francesco Migliore refers to player_name = 'Francesco Migliore'; on 2015/5/1 refers to date LIKE '2015-05-01%';
SQL: SELECT t2.attacking_work_rate FROM Player AS t1 INNER JOIN Player_Attributes AS t2 ON t1.player_api_id = t2.player_api_id WHERE t2.`date` LIKE '2015-05-01%' AND t1.player_name = 'Francesco Migliore'

Database: card_games
Question: List the card names with value that cost more converted mana for the face.
Evidence: more converted mana for the face refers to Max(faceConvertedManaCost);
SQL: SELECT name FROM cards ORDER BY faceConvertedManaCost LIMIT 1

Database: thrombosis_prediction
Question: For the patients whose total cholesterol is higher than normal, how many of them have a negative measure of degree of coagulation?
Evidence: total cholesterol is higher than normal refers to `T-CHO` > = 250; negative measure of degree of coagulation refers to KCT = '-' ;
SQL: SELECT COUNT(T1.ID) 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-CHO` >= 250 AND T3.KCT = '-'

Database: student_club
Question: What are the budget category of the events located at MU 215 and a guest speaker type with a 0 budget spent?
Evidence: budget category refers to category; events located at refers to location; type = 'Guest Speaker'; 0 budget spent refers to spent = 0; 
SQL: SELECT DISTINCT T2.category, T1.type FROM event AS T1 INNER JOIN budget AS T2 ON T1.event_id = T2.link_to_event WHERE T1.location = 'MU 215' AND T2.spent = 0 AND T1.type = 'Guest Speaker'

Database: toxicology
Question: How many bond id have element iodine?
Evidence: iodine refers to element = 'i'
SQL: SELECT COUNT(T3.bond_id) FROM atom AS T1 INNER JOIN molecule AS T2 ON T1.molecule_id = T2.molecule_id INNER JOIN bond AS T3 ON T2.molecule_id = T3.molecule_id WHERE T1.element = 'i'

Database: codebase_community
Question: How many votes were made by Harlan?
Evidence: DisplayName = 'Harlan';
SQL: SELECT COUNT(T1.Id) FROM users AS T1 INNER JOIN postHistory AS T2 ON T1.Id = T2.UserId INNER JOIN votes AS T3 ON T3.PostId = T2.PostId WHERE T1.DisplayName = 'Harlan'

Database: student_club
Question: List the event names which were budgeted for the food.
Evidence: budgeted for food refers to category = 'Food'
SQL: SELECT T1.event_name FROM event AS T1 INNER JOIN budget AS T2 ON T1.event_id = T2.link_to_event WHERE T2.category = 'Food'