Database: superhero
Question: Identify superheroes who can control wind and list their names in alphabetical order.
Evidence: superheroes refers to superhero_name; can control wind refers to power_name = 'Wind Control';
SQL: SELECT T1.superhero_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 T3.power_name = 'Wind Control' ORDER BY T1.superhero_name

Database: toxicology
Question: Of the first 100 molecules in number order, how many are carcinogenic?
Evidence: first 100 molecules in number order refers to molecule_id between 'TR000' and 'TR099'; label = '+' means molecules are carcinogenic
SQL: SELECT COUNT(T.molecule_id) FROM molecule AS T WHERE molecule_id BETWEEN 'TR000' AND 'TR099' AND T.label = '+'

Database: superhero
Question: What is the average height of the superheroes from Marvel Comics?
Evidence: superheroes from Marvel Comics refers to publisher_name = 'Marvel Comics'; average height of the superheroes refers to AVG(height_cm)
SQL: SELECT AVG(T1.height_cm) FROM superhero AS T1 INNER JOIN publisher AS T2 ON T1.publisher_id = T2.id WHERE T2.publisher_name = 'Marvel Comics'

Database: student_club
Question: What is the highest amount of budget spend for an event?
Evidence: highest amount of budget spend refers to MAX(spent)
SQL: SELECT MAX(spent) FROM budget

Database: student_club
Question: Give the full name and contact number of members who had to spend more than average on each expense.
Evidence: full name refers to first_name, last_name; contact number refers to phone; had spent more than average on each expense refers to cost > AVG(cost)
SQL: SELECT DISTINCT T3.first_name, T3.last_name, T3.phone FROM expense AS T1 INNER JOIN budget AS T2 ON T1.link_to_budget = T2.budget_id INNER JOIN member AS T3 ON T3.member_id = T1.link_to_member WHERE T1.cost > ( SELECT AVG(T1.cost) FROM expense AS T1 INNER JOIN budget AS T2 ON T1.link_to_budget = T2.budget_id INNER JOIN member AS T3 ON T3.member_id = T1.link_to_member )

Database: thrombosis_prediction
Question: Among the patients whose total bilirubin is over the normal range, how many of them have a peripheral pattern observed in the sheet of ANA examination?
Evidence: total bilirubin is over the normal range refers to `T-BIL` > = 2.0; peripheral pattern is observed in the sheet of ANA examination refers to that ANA Pattern contains 'P';
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-BIL` >= 2 AND T3.`ANA Pattern` LIKE '%P%'

Database: card_games
Question: What is the number of cards are there in the set of "Rinascita di Alara"?
Evidence: number of cards refers to baseSetSize; set of "Rinascita di Alara" refers to translation = 'Rinascita di Alara'
SQL: SELECT T1.baseSetSize FROM sets AS T1 INNER JOIN set_translations AS T2 ON T2.setCode = T1.code WHERE T2.translation = 'Rinascita di Alara'

Database: formula_1
Question: Among all European Grand Prix races, what is the percentage of the races were hosted in Germany?
Evidence: European Grand Prix races refers to races.name = 'European Grand Prix';percentage = divide(COUNT(races where country = Germany and name = 'Europearn Grand Prix'),COUNT(races where name = 'Europearn Grand Prix'))*100
SQL: SELECT CAST(COUNT(CASE WHEN T1.country = 'Germany' THEN T2.circuitID END) AS REAL) * 100 / COUNT(T2.circuitId) FROM circuits AS T1 INNER JOIN races AS T2 ON T2.circuitID = T1.circuitId WHERE T2.name = 'European Grand Prix'

Database: superhero
Question: What is the total number of superheroes without full name?
Evidence: superheroes without full name refers to full_name IS NULL
SQL: SELECT COUNT(id) FROM superhero WHERE full_name IS NULL

Database: card_games
Question: Among the card designed by Matthew D. Wilson, how many are available only in the paper?
Evidence: card designed by Matthew D. Wilson refers to artist = 'Matthew D. Wilson'; available only in the paper refers to availability = 'paper'
SQL: SELECT COUNT(id) FROM cards WHERE artist = 'Matthew D. Wilson' AND availability = 'paper'

Database: formula_1
Question: What is the coordinates location of the circuits for Australian grand prix?
Evidence: coordinate position/location refers to lat, lng; circuits for Australian grand prix refers to races.name = 'Australian Grand Prix'
SQL: SELECT DISTINCT T1.lat, T1.lng FROM circuits AS T1 INNER JOIN races AS T2 ON T2.circuitID = T1.circuitId WHERE T2.name = 'Australian Grand Prix'

Database: superhero
Question: Which group does superhero A-Bomb belong to?
Evidence: group refers to race; A-Bomb refers to superhero_name = 'A-Bomb';
SQL: SELECT T2.race FROM superhero AS T1 INNER JOIN race AS T2 ON T1.race_id = T2.id WHERE T1.superhero_name = 'A-Bomb'

Database: thrombosis_prediction
Question: How many patients have a normal anti-DNA level, yet their data are not recorded.
Evidence: normal anti-DNA level refers to DNA < 8; data are not recorded refers to Description IS NULL; Should compute the number of unique ones
SQL: SELECT COUNT(DISTINCT T1.ID) FROM Patient AS T1 INNER JOIN Laboratory AS T2 ON T1.ID = T2.ID WHERE T2.DNA < 8 AND T1.Description IS NULL

Database: debit_card_specializing
Question: Please list the product descriptions of the transactions taken place in the gas stations in the Czech Republic.
Evidence: Czech Republic can be represented as the Country value in the gasstations table is 'CZE'; 
SQL: SELECT DISTINCT T3.Description FROM transactions_1k AS T1 INNER JOIN gasstations AS T2 ON T1.GasStationID = T2.GasStationID INNER JOIN products AS T3 ON T1.ProductID = T3.ProductID WHERE T2.Country = 'CZE'

Database: financial
Question: What is the amount of debt that client number 992 has, and how is this client doing with payments?
SQL: SELECT T4.amount, T4.status FROM client AS T1 INNER JOIN disp AS T2 ON T1.client_id = T2.client_id INNER JOIN account AS T3 on T2.account_id = T3.account_id INNER JOIN loan AS T4 ON T3.account_id = T4.account_id WHERE T1.client_id = 992

Database: thrombosis_prediction
Question: For the patients with an abnormal anti-SM, please list the IDs of the three youngest ones.
Evidence: abnormal anti-SM refers to SM NOT IN ('negative', '0'); youngest refers to MAX(Birthday);
SQL: SELECT T1.ID FROM Patient AS T1 INNER JOIN Laboratory AS T2 ON T1.ID = T2.ID WHERE T2.SM NOT IN ('negative','0') ORDER BY T1.Birthday DESC LIMIT 3

Database: codebase_community
Question: Identify the total views on the post 'Computer Game Datasets'. Name the user who posted it last time.
Evidence: total views refer to ViewCount; Name the user refers to DisplayName; post 'Computer Game Datasets' refers to Text = 'Computer Game Datasets';
SQL: SELECT T2.ViewCount, T3.DisplayName FROM postHistory AS T1 INNER JOIN posts AS T2 ON T1.PostId = T2.Id INNER JOIN users AS T3 ON T2.LastEditorUserId = T3.Id WHERE T1.Text = 'Computer Game Datasets'

Database: thrombosis_prediction
Question: Provide ID, sex and age of patient who has blood glucose (GLU) not within normal range but with total cholesterol(T-CHO) within normal range.
Evidence: age = SUBTRACT(year(current_timestamp), year(Birthday)); blood glucose (GLU) not within normal range refers to GLU > = 180; total cholesterol(T-CHO) within normal range refers to `T-CHO` < 250; 
SQL: SELECT DISTINCT T1.ID, T1.SEX , STRFTIME('%Y', CURRENT_TIMESTAMP) - STRFTIME('%Y', T1.Birthday) FROM Patient AS T1 INNER JOIN Laboratory AS T2 ON T1.ID = T2.ID WHERE T2.GLU >= 180 AND T2.`T-CHO` < 250

Database: codebase_community
Question: Write all comments made on the post titled 'How does gentle boosting differ from AdaBoost?'
Evidence: "How does gentle boosting differ from AdaBoost?" is the Title of post; comments refers to Text
SQL: SELECT T1.Text FROM comments AS T1 INNER JOIN posts AS T2 ON T1.PostId = T2.Id WHERE T2.Title = 'How does gentle boosting differ from AdaBoost?'