Database: financial
Question: Which kind of credit card does client number 9 possess?
SQL: SELECT T3.type FROM client AS T1 INNER JOIN disp AS T2 ON T1.client_id = T2.client_id INNER JOIN card AS T3 ON T2.disp_id = T3.disp_id WHERE T1.client_id = 9

Database: thrombosis_prediction
Question: Please list the IDs of the patients who had the examination done after 1997/1/1 and had a normal anti-scl70.
Evidence: examination done after 1997/1/1 refers to `Examination Date` >  1997-01-01; normal anti-scl70 refers to SC170 IN('negative','0');
SQL: SELECT T1.ID FROM Patient AS T1 INNER JOIN Laboratory AS T2 ON T1.ID = T2.ID WHERE T2.SC170 IN ('negative','0') AND T2.Date > 1997-01-01

Database: card_games
Question: What is the rule of playing card "Benalish Knight"?
Evidence: Benalish Knight' is the name of card; rule of playing card refers to format;
SQL: SELECT T2.format FROM cards AS T1 INNER JOIN legalities AS T2 ON T1.uuid = T2.uuid WHERE T1.name = 'Benalish Knight'

Database: codebase_community
Question: Among the posts with views ranging from 100 to 150, what is the comment with the highest score?
Evidence: views ranging from 100 to 150 refers to ViewCount BETWEEN 100 and 150; comment with the highest score refers to Text where MAX(Score);
SQL: SELECT Text FROM comments WHERE PostId IN ( SELECT Id FROM posts WHERE ViewCount BETWEEN 100 AND 150 ) ORDER BY Score DESC LIMIT 1

Database: california_schools
Question: What are the two most common first names among the school administrators? Indicate the district to which they administer.
SQL: SELECT DISTINCT T1.AdmFName1, T1.District FROM schools AS T1 INNER JOIN ( SELECT admfname1 FROM schools GROUP BY admfname1 ORDER BY COUNT(admfname1) DESC LIMIT 2 ) AS T2 ON T1.AdmFName1 = T2.admfname1

Database: thrombosis_prediction
Question: For the patients who have an abnormal level of anti-DNA, please list the diseases they are diagnosed with.
Evidence: abnormal level of anti-DNA refers to DNA > = 8; diseases refers to Diagnosis;
SQL: SELECT DISTINCT(T1.Diagnosis) FROM Patient AS T1 INNER JOIN Laboratory AS T2 ON T1.ID = T2.ID WHERE T2.DNA >= 8

Database: debit_card_specializing
Question: Please list the disparate time of the transactions taken place in the gas stations from chain no. 11.
SQL: SELECT DISTINCT T1.Time FROM transactions_1k AS T1 INNER JOIN gasstations AS T2 ON T1.GasStationID = T2.GasStationID WHERE T2.ChainID = 11

Database: codebase_community
Question: Indicate the creation date of the maximum number of votes.
Evidence: the creation date of the maximum number of votes refers to CreationDate where Max(Count(Id))
SQL: SELECT CreationDate FROM votes GROUP BY CreationDate ORDER BY COUNT(Id) DESC LIMIT 1

Database: debit_card_specializing
Question: What's the nationality of the customer who spent 548.4 in 2012/8/24?
Evidence: '2012/8/24' can be represented by '2012-08-24'
SQL: SELECT T2.Country FROM transactions_1k AS T1 INNER JOIN gasstations AS T2 ON T1.GasStationID = T2.GasStationID WHERE T1.Date = '2012-08-24' AND T1.Price = 548.4

Database: formula_1
Question: When was the last f1 season whereby Brands Hatch hosted the British Grand Prix?
Evidence: the last refers to max(year);
SQL: SELECT T2.date FROM circuits AS T1 INNER JOIN races AS T2 ON T2.circuitID = T1.circuitId WHERE T1.name = 'Brands Hatch' AND T2.name = 'British Grand Prix' ORDER BY T2.year DESC LIMIT 1

Database: card_games
Question: What is the type of the card "Ancestor's Chosen" as originally printed?
Evidence: Ancestor's Chosen' is the name of card; type of the card as originally printed refers to originaltype;
SQL: SELECT originalType FROM cards WHERE name = 'Ancestor''s Chosen' AND originalType IS NOT NULL

Database: european_football_2
Question: For the team "Hannover 96", what was its defence aggression class on 2015/9/10?
Evidence: "Hannover 96" refers to team_long_name = 'Hannover 96'; on 2015/9/10 refers to date LIKE '2015-09-10%';
SQL: SELECT t2.chanceCreationShootingClass FROM Team AS t1 INNER JOIN Team_Attributes AS t2 ON t1.team_api_id = t2.team_api_id WHERE t1.team_long_name = 'Hannover 96' AND t2.`date` LIKE '2015-09-10%'

Database: card_games
Question: Which cards are ranked 1st on EDHRec? List all of the cards name and its banned play format.
Evidence: ranked 1st on EDHRec refers to edhrecRank = 1; banned refers to status = 'Banned'; play format refers to format; cards name refers to name
SQL: SELECT T1.name, T2.format FROM cards AS T1 INNER JOIN legalities AS T2 ON T2.uuid = T1.uuid WHERE T1.edhrecRank = 1 AND T2.status = 'Banned' GROUP BY T1.name, T2.format

Database: superhero
Question: What is the eyes colour of Abraham Sapien?
Evidence: eye colour refers to colour.colour where eye_colour_id = colour.id; Abraham Sapien is the full name of superhero;
SQL: SELECT T2.colour FROM superhero AS T1 INNER JOIN colour AS T2 ON T1.eye_colour_id = T2.id WHERE T1.full_name = 'Abraham Sapien'

Database: card_games
Question: Point out the language of set id "174"?
SQL: SELECT language FROM set_translations WHERE id = 174

Database: european_football_2
Question: What is Ajax's highest chance creation passing score and what is it classified as?
Evidence: Ajax's refers to team_long_name = 'Ajax'; chance creation passing score refers to MAX(chanceCreationPassing); classified refer to chanceCreationPassingClass
SQL: SELECT t2.chanceCreationPassing, t2.chanceCreationPassingClass FROM Team AS t1 INNER JOIN Team_Attributes AS t2 ON t1.team_api_id = t2.team_api_id WHERE t1.team_long_name = 'Ajax' ORDER BY t2.chanceCreationPassing DESC LIMIT 1

Database: thrombosis_prediction
Question: List all patients with their sex and date of birthday, whose AST glutamic oxaloacetic transaminase (GOT) index is within normal range for loboratory examination in 1994.
Evidence: AST glutamic oxaloacetic transaminase (GOT) index is within normal range refers to GOT < 60; examination in 1994 refers to year(Date) = 1994
SQL: SELECT DISTINCT T1.SEX, T1.Birthday FROM Patient AS T1 INNER JOIN Laboratory AS T2 ON T1.ID = T2.ID WHERE T2.GOT < 60 AND STRFTIME('%Y', T2.Date) = '1994'

Database: toxicology
Question: Find the triple-bonded molecules which are carcinogenic.
Evidence: triple-bonded molecules refers to bond_type = '#'; carcinogenic refers to label = '+'
SQL: SELECT DISTINCT T2.molecule_id FROM bond AS T1 INNER JOIN molecule AS T2 ON T1.molecule_id = T2.molecule_id WHERE T1.bond_type = '#' AND T2.label = '+'

Database: toxicology
Question: List down atom id2 for atoms with element sulfur.
Evidence: element sulfur refers to element = 's'
SQL: SELECT DISTINCT T2.atom_id2 FROM atom AS T1 INNER JOIN connected AS T2 ON T1.atom_id = T2.atom_id WHERE T1.element = 's'

Database: european_football_2
Question: Please list all team names which the speed class is fast.
Evidence: team names refers to team_long_name; speed class refers to buildUpPlaySpeedClass; buildUpPlaySpeedClass = 'Fast';
SQL: SELECT DISTINCT t1.team_long_name FROM Team AS t1 INNER JOIN Team_Attributes AS t2 ON t1.team_api_id = t2.team_api_id WHERE t2.buildUpPlaySpeedClass = 'Fast'

Database: superhero
Question: List the full names of superheroes with missing weight.
Evidence: missing weight refers to weight_kg = 0 OR weight_kg = NULL;
SQL: SELECT DISTINCT full_name FROM superhero WHERE full_name IS NOT NULL AND (weight_kg IS NULL OR weight_kg = 0)

Database: toxicology
Question: How many atoms belong to the molecule that element is hydrogen and labeled with carcinogenic compound?
Evidence: label = '+' mean molecules are carcinogenic; hydrogen refers to element = h'
SQL: SELECT COUNT(T1.atom_id) AS atomnums_h FROM atom AS T1 INNER JOIN molecule AS T2 ON T1.molecule_id = T2.molecule_id WHERE T2.label = '+' AND T1.element = 'h'

Database: superhero
Question: Calculate the average attribute value of all superheroes.
Evidence: average attribute value of all superheroes refers to AVG(attribute_value)
SQL: SELECT AVG(attribute_value) FROM hero_attribute