Database: card_games
Question: Which artist designed the card whose promotional name is "Battra, Dark Destroyer"?
Evidence: promotional name is "Battra, Dark Destroyer" refers to flavorName = 'Battra, Dark Destroyer'
SQL: SELECT artist FROM cards WHERE flavorName = 'Battra, Dark Destroyer'

Database: codebase_community
Question: In comments with 0 score, how many of the posts have view count lower than 5?
Evidence: view count lower than 5 refers to ViewCount < 5;
SQL: SELECT COUNT(T1.Id) FROM comments AS T1 INNER JOIN posts AS T2 ON T1.PostId = T2.Id WHERE T2.ViewCount < 5 AND T2.Score = 0

Database: california_schools
Question: What is the phone number of the school that has the highest average score in Math?
SQL: SELECT T1.Phone FROM schools AS T1 INNER JOIN satscores AS T2 ON T1.CDSCode = T2.cds ORDER BY T2.AvgScrMath DESC LIMIT 1

Database: thrombosis_prediction
Question: Lists all patients by ID who were diagnosed with Behcet's and had their exams between 01/01/197 and 12/31/1997.
Evidence: 'Behcet' refers to diagnosis; exam between 01/01/1997 and 12/31/1997 refers to YEAR(Description) > = '1997-1-1' AND YEAR(Description) < '1998-1-1'
SQL: SELECT ID FROM Examination WHERE `Examination Date` BETWEEN '1997-01-01' AND '1997-12-31' AND Diagnosis = 'Behcet'

Database: california_schools
Question: How many schools in merged Alameda have number of test takers less than 100?
SQL: SELECT COUNT(T1.CDSCode) FROM schools AS T1 INNER JOIN satscores AS T2 ON T1.CDSCode = T2.cds WHERE T1.StatusType = 'Merged' AND T2.NumTstTakr < 100 AND T1.County = 'Lake'

Database: european_football_2
Question: How many matches in the 2008/2009 season were held in Belgium?
Evidence: Belgium refers to Country.name = 'Belgium';
SQL: SELECT COUNT(t2.id) FROM Country AS t1 INNER JOIN Match AS t2 ON t1.id = t2.country_id WHERE t1.name = 'Belgium' AND t2.season = '2008/2009'

Database: toxicology
Question: How many bonds are created by bonding atoms with chlorine element?
Evidence: chlorine refers to element = 'cl'
SQL: SELECT COUNT(T1.bond_id) FROM connected AS T1 INNER JOIN atom AS T2 ON T1.atom_id = T2.atom_id WHERE T2.element = 'cl'

Database: california_schools
Question: What is the free or reduced price meal count for ages 5 to 17 in the Youth Authority School with a mailing street address of PO Box 1040?
SQL: SELECT T1.`FRPM Count (Ages 5-17)` FROM frpm AS T1 INNER JOIN schools AS T2 ON T1.CDSCode = T2.CDSCode WHERE T2.MailStreet = 'PO Box 1040' AND T2.SOCType = 'Youth Authority Facilities'

Database: european_football_2
Question: Which foot is preferred by Abdou Diallo?
Evidence: Abdou Diallo refers to player_name = 'Abdou Diallo'; foot is preferred refers to preferred_foot
SQL: SELECT DISTINCT t2.preferred_foot FROM Player AS t1 INNER JOIN Player_Attributes AS t2 ON t1.player_api_id = t2.player_api_id WHERE t1.player_name = 'Abdou Diallo'

Database: california_schools
Question: What is the total number of schools whose total SAT scores are greater or equal to 1500 whose mailing city is Lakeport?
Evidence: Total SAT scores can be computed by AvgScrRead + AvgScrMath + AvgScrWrite
SQL: SELECT COUNT(T1.cds) FROM satscores AS T1 INNER JOIN schools AS T2 ON T1.cds = T2.CDSCode WHERE T2.MailCity = 'Lakeport' AND (T1.AvgScrRead + T1.AvgScrMath + T1.AvgScrWrite) >= 1500

Database: formula_1
Question: Please list the time each driver spent at the pit stop during the 2011 Australian Grand Prix.
Evidence: time spent at pit stop refers to duration
SQL: SELECT T1.duration FROM pitStops AS T1 INNER JOIN races AS T2 on T1.raceId = T2.raceId WHERE T2.year = 2011 AND T2.name = 'Australian Grand Prix'

Database: student_club
Question: List out the position of members who joined major of Business.
Evidence: 'Business' is the major name
SQL: SELECT T2.position FROM major AS T1 INNER JOIN member AS T2 ON T1.major_id = T2.link_to_major WHERE T1.major_name = 'Business'

Database: superhero
Question: How many gold-eyed superheroes did Marvel Comics publish?
Evidence: gold-eyed refers to colour = 'Gold' where eye_colour_id = colour.id; superheroes that Marvel Comics published refers to publisher_name = 'Marvel Comics'
SQL: SELECT COUNT(T1.id) FROM superhero AS T1 INNER JOIN publisher AS T2 ON T1.publisher_id = T2.id INNER JOIN colour AS T3 ON T1.eye_colour_id = T3.id WHERE T2.publisher_name = 'Marvel Comics' AND T3.colour = 'Gold'

Database: formula_1
Question: Which year has the most number of races?
Evidence: the most number of races refers to max(round);
SQL: SELECT year FROM races GROUP BY year ORDER BY COUNT(round) DESC LIMIT 1

Database: thrombosis_prediction
Question: How many patients with severe thrombosis have a normal prothrombin time?
Evidence: severe thrombosis refers to Thrombosis = 2 or 1; normal prothrombin time refers to PT < 14;
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.PT < 14 AND T3.Thrombosis < 3 AND T3.Thrombosis > 0

Database: superhero
Question: Count the good female superheroes.
Evidence: good refers to alignment.id = 1; female refers to gender.id = 2;
SQL: SELECT COUNT(T1.id) FROM superhero AS T1 INNER JOIN alignment AS T2 ON T1.alignment_id = T2.id INNER JOIN gender AS T3 ON T1.gender_id = T3.id WHERE T2.alignment = 'Good' AND T3.gender = 'Female'

Database: codebase_community
Question: Which user has the website URL listed at 'http://stackoverflow.com'
Evidence: "http://stackoverflow.com" is the WebsiteUrl; user refers to DisplayName
SQL: SELECT DisplayName FROM users WHERE WebsiteUrl = 'http://stackoverflow.com'

Database: card_games
Question: What's the list of all types for the card "Molimo, Maro-Sorcerer"?
Evidence: card "Molimo, Maro-Sorcerer" refers to name = 'Molimo, Maro-Sorcerer'; list of all types refers to subtypes,supertypes
SQL: SELECT DISTINCT subtypes, supertypes FROM cards WHERE name = 'Molimo, Maro-Sorcerer'

Database: thrombosis_prediction
Question: For the patient with an abnormal alkaliphophatase level, how many of them are admitted to the hospital?
Evidence: abnormal alkaliphophatase level refers to ALP > = 300; admitted to the hospital refers to Admission = '+';
SQL: SELECT COUNT(T1.ID) FROM Patient AS T1 INNER JOIN Laboratory AS T2 ON T1.ID = T2.ID WHERE T2.ALP >= 300 AND T1.Admission = '+'

Database: card_games
Question: Among the cards in the set "Hauptset Zehnte Edition", how many of them are designed by Adam Rex?
Evidence: card set "Hauptset Zehnte Edition" refers to translation = 'Hauptset Zehnte Edition'; designed by Adam refers to artist = 'Adam Rex'
SQL: SELECT COUNT(T1.id) FROM cards AS T1 INNER JOIN set_translations AS T2 ON T2.setCode = T1.setCode WHERE T2.translation = 'Hauptset Zehnte Edition' AND T1.artist = 'Adam Rex'

Database: codebase_community
Question: What are the titles of the top 5 posts with the highest popularity?
Evidence: Higher view count means the post has higher popularity; the highest popularity refers to MAX(ViewCount);
SQL: SELECT Title FROM posts ORDER BY ViewCount DESC LIMIT 5

Database: thrombosis_prediction
Question: How many patients have a normal anti-SSB and are diagnosed with SLE in the examination?
Evidence: normal anti-SSB refers to SSB IN('-', '+-'); '-' is expressed as 'negative' and '+-' is expressed as '0' in the database ; diagnosed with SLE refers to Diagnosis = 'SLE'; Should compute the number of distinct ones
SQL: SELECT COUNT(DISTINCT T1.ID) FROM Patient AS T1 INNER JOIN Laboratory AS T2 ON T1.ID = T2.ID WHERE T2.SSB = 'negative' OR '0' AND T1.Diagnosis = 'SLE'