Database: toxicology
Question: What are the labels for TR000, TR001 and TR002?
Evidence: TR000, TR001 and TR002 are molecule id; label = '+' mean molecules are carcinogenic; label = '-' means molecules are non-carcinogenic
SQL: SELECT molecule_id, T.label FROM molecule AS T WHERE T.molecule_id IN ('TR000', 'TR001', 'TR002')

Database: student_club
Question: Name the event with the highest amount spent on advertisement.
Evidence: Name of event refers to event_name; highest amount spent on advertisement refers to MAX(spent) where category = 'Advertisement'
SQL: SELECT T2.event_name FROM budget AS T1 INNER JOIN event AS T2 ON T1.link_to_event = T2.event_id WHERE T1.category = 'Advertisement' ORDER BY T1.spent DESC LIMIT 1

Database: card_games
Question: For the set of cards with "Ancestor's Chosen" in it, is there a Korean version of it?
Evidence: set of cards with "Ancestor''s Chosen" in it refers to name = 'Ancestor''s Chosen'; Korean version refers to language = 'Korean'
SQL: SELECT IIF(SUM(CASE WHEN T2.language = 'Korean' AND T2.translation IS NOT NULL THEN 1 ELSE 0 END) > 0, 'YES', 'NO') FROM cards AS T1 INNER JOIN set_translations AS T2 ON T2.setCode = T1.setCode WHERE T1.name = 'Ancestor''s Chosen'

Database: student_club
Question: What is the percentage of the cost for the meeting events?
Evidence: meeting events refers to type = 'Meeting'; percentage = DIVIDE( SUM(cost), COUNT(event_id)) * 100
SQL: SELECT SUM(CASE WHEN T1.type = 'Meeting' THEN T3.cost ELSE 0 END) * 100 / SUM(T3.cost) FROM event AS T1 INNER JOIN budget AS T2 ON T1.event_id = T2.link_to_event INNER JOIN expense AS T3 ON T2.budget_id = T3.link_to_budget

Database: codebase_community
Question: How many users were awarded with 'Citizen Patrol' badge?
Evidence: Citizen Patrol' is the name of the badge;
SQL: SELECT COUNT(id) FROM badges WHERE `Name` = 'Citizen Patrol'

Database: toxicology
Question: How many carcinogenic molecules that consisted of Nitrogen?
Evidence: nitrogen refers to element = 'n'; label = '+' mean molecules are carcinogenic;
SQL: SELECT COUNT(DISTINCT T1.molecule_id) FROM molecule AS T1 INNER JOIN atom AS T2 ON T1.molecule_id = T2.molecule_id WHERE T2.element = 'n' AND T1.label = '+'

Database: card_games
Question: Please list all the foreign languages in which the card "Ancestor's Chosen" has a flavor text.
Evidence: "Ancestor''s Chosen" refers to name = 'Ancestor''s Chosen'; has a flavor text refers to flavorText is not null
SQL: SELECT T2.language FROM cards AS T1 INNER JOIN foreign_data AS T2 ON T2.uuid = T1.uuid WHERE T1.name = 'Ancestor''s Chosen' AND T2.flavorText IS NOT NULL

Database: student_club
Question: List the name and location of events that underspend its budget.
Evidence: name of event refers to event_name; underspend its budget refers to remaining > 0
SQL: SELECT DISTINCT T1.event_name, T1.location FROM event AS T1 INNER JOIN budget AS T2 ON T1.event_id = T2.link_to_event WHERE T2.remaining > 0

Database: formula_1
Question: In which Formula_1 race did Lewis Hamilton rank the highest?
Evidence: rank the highest refers to min(rank); Lewis Hamilton refers to the full name of the driver; Full name of the driver refers to drivers.forename and drivers.surname;
SQL: SELECT name FROM races WHERE raceId IN ( SELECT raceId FROM results WHERE rank = 1 AND driverId = ( SELECT driverId FROM drivers WHERE forename = 'Lewis' AND surname = 'Hamilton' ) )

Database: formula_1
Question: What is the average of fastest lap speed in the 2009 Spanish Grand Prix race?
Evidence: Spanish Grand Prix is the name of race refers to name = 'Spanish Grand Prix'; average fastest lap speed refers to avg(fastestLapSpeed);
SQL: SELECT AVG(T1.fastestLapSpeed) FROM results AS T1 INNER JOIN races AS T2 on T1.raceId = T2.raceId WHERE T2.year = 2009 AND T2.name = 'Spanish Grand Prix'

Database: toxicology
Question: Among all the atoms from 21 to 25, list all the molecules that are carcinogenic.
Evidence: atoms from 21 to 25 refers to SUBSTR(atom_id, 7, 2) between '21' and '25'; label = '+' mean molecules are carcinogenic
SQL: SELECT DISTINCT T2.molecule_id FROM atom AS T1 INNER JOIN molecule AS T2 ON T1.molecule_id = T2.molecule_id WHERE SUBSTR(T1.atom_id, -2) BETWEEN '21' AND '25' AND T2.label = '+'

Database: superhero
Question: Provide the eye colour of the superhero who has Karen Beecher-Duncan as their full name.
Evidence: eye colour refers to colour.colour where eye_colour_id = colour.id; Karen Beecher-Duncan 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 = 'Karen Beecher-Duncan'

Database: codebase_community
Question: How many users from India have the teacher badges?
Evidence: "India" is the Location; "Teacher" is the Name of badge
SQL: SELECT COUNT(T1.Id) FROM badges AS T1 INNER JOIN users AS T2 ON T1.UserId = T2.Id WHERE T2.Location = 'India' AND T1.Name = 'Teacher'

Database: superhero
Question: List the powers of Hunter Zolomon.
Evidence: Hunter Zolomon is the full name of superhero; list the powers refers to power_name;
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.full_name = 'Hunter Zolomon'

Database: formula_1
Question: What is the average fastest lap time of the top 10 drivers in the 2006 United States Grand Prix?
Evidence: top 10 refers to rank <11; AVG(fastestLapTime);
SQL: SELECT AVG(T1.fastestLapTime) FROM results AS T1 INNER JOIN races AS T2 on T1.raceId = T2.raceId WHERE T1.rank < 11 AND T2.year = 2006 AND T2.name = 'United States Grand Prix'

Database: card_games
Question: When was the oldest mythic card released and what are its legal play formats?
Evidence: the oldest card refers to MIN(originalReleaseDate); mythic card refers to rarity = 'mythic'; legal play refers to status = 'legal'; play format refers to format
SQL: SELECT T1.originalReleaseDate, T2.format FROM cards AS T1 INNER JOIN legalities AS T2 ON T1.uuid = T2.uuid WHERE T1.rarity = 'mythic' AND T1.originalReleaseDate IS NOT NULL AND T2.status = 'Legal' ORDER BY T1.originalReleaseDate LIMIT 1

Database: codebase_community
Question: Which user created post ID 1 and what is the reputation of this user?
SQL: SELECT T2.Id, T2.Reputation FROM comments AS T1 INNER JOIN users AS T2 ON T1.UserId = T2.Id WHERE T1.PostId = 1

Database: thrombosis_prediction
Question: For all patients with triglyceride (TG) level beyond the normal range, how many are age more than 50 years?
Evidence: triglyceride (TG) level beyond the normal range refers to TG > = 200; more than 50 years of age = SUBTRACT(year(current_timestamp), year(Birthday)) > 50; Should consider DISTINCT in the final result;
SQL: SELECT COUNT(DISTINCT T1.ID) FROM Patient AS T1 INNER JOIN Laboratory AS T2 ON T1.ID = T2.ID WHERE T2.TG >= 200 AND STRFTIME('%Y', CURRENT_TIMESTAMP) - STRFTIME('%Y', T1.Birthday) > 50

Database: european_football_2
Question: Locate players with vision scores of 90 and above, state the country of these players.
Evidence: vision scores of 90 and above refers to vision > 89
SQL: SELECT DISTINCT t4.name FROM Player_Attributes AS t1 INNER JOIN Player AS t2 ON t1.player_api_id = t2.player_api_id INNER JOIN Match AS t3 ON t2.player_api_id = t3.home_player_8 INNER JOIN Country AS t4 ON t3.country_id = t4.id WHERE t1.vision > 89

Database: card_games
Question: What language is the set of 180 cards that belongs to the Ravnica block translated into?
Evidence: set of 180 cards refers to baseSetSize = 180
SQL: SELECT T2.language FROM sets AS T1 INNER JOIN set_translations AS T2 ON T1.code = T2.setCode WHERE T1.block = 'Ravnica' AND T1.baseSetSize = 180