Database: thrombosis_prediction
Question: Are there more male patients with creatinine not within the normal range than female? True or False?
Evidence: creatinine (CRE) not within the normal range refers to CRE > = 1.5; male refers to Sex = 'M'; female refers to Sex = 'F'; calculation = (SUM(SEX = 'M') > SUM(SEX = 'F')) where CRE > = 1.5
SQL: SELECT CASE WHEN SUM(CASE WHEN T1.SEX = 'M' THEN 1 ELSE 0 END) > SUM(CASE WHEN T1.SEX = 'F' THEN 1 ELSE 0 END) THEN 'True' ELSE 'False' END FROM Patient AS T1 INNER JOIN Laboratory AS T2 ON T1.ID = T2.ID WHERE T2.CRE >= 1.5

Database: financial
Question: What is the gender of the oldest client who opened his/her account in the highest average salary branch?
Evidence: Earlier birthdate refers to older age; A11 refers to average salary
SQL: SELECT T2.gender FROM district AS T1 INNER JOIN client AS T2 ON T1.district_id = T2.district_id ORDER BY T1.A11 DESC, T2.birth_date ASC LIMIT 1

Database: student_club
Question: Among all events hold by the Student_Club in 2019, find the percentage share of events related to 'Community Service'
Evidence: DIVIDE(SUM(type = 'Community Service'), COUNT(event_id)) * 100 where event_date BETWEEN' 2019-01-01' and '2019-12-31'
SQL: SELECT CAST(SUM(CASE WHEN type = 'Community Service' THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(type) FROM event WHERE SUBSTR(event_date, 1, 4) = '2019'

Database: superhero
Question: How many green-skinned villains are there in the superhero universe?
Evidence: green-skinned refers to colour.colour = 'Green' WHERE skin_colour_id = colour.id; villains refers to alignment = 'Bad';
SQL: SELECT COUNT(T1.id) FROM superhero AS T1 INNER JOIN alignment AS T2 ON T1.alignment_id = T2.id INNER JOIN colour AS T3 ON T1.skin_colour_id = T3.id WHERE T2.alignment = 'Bad' AND T3.colour = 'Green'

Database: card_games
Question: What are the available printing types of the cards that doesn't have a text box created by Aleksi Briclot?
Evidence: created by Aleksi Briclot refers to artist = 'Aleksi Briclot'; doesn't have a text box refers to isTextless = 1; available printing types refers to availability
SQL: SELECT DISTINCT availability FROM cards WHERE artist = 'Aleksi Briclot' AND isTextless = 1

Database: student_club
Question: Was each expense in October Meeting on October 8, 2019 approved?
Evidence: event_name = 'October Meeting' where event_date = '2019-10-08'; approved = True means expenses was approved; approved = False means expenses was not approved
SQL: SELECT T3.approved 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 WHERE T1.event_name = 'October Meeting' AND T1.event_date LIKE '2019-10-08%'

Database: card_games
Question: How many cards with print rarity have ruling text printed on 01/02/2007?
Evidence: with print rarity refers to rarity = 'rare'; on 01/02/2007 refers to date = '2007-02-01'
SQL: SELECT COUNT(DISTINCT T1.id) FROM cards AS T1 INNER JOIN rulings AS T2 ON T1.uuid = T2.uuid WHERE T1.rarity = 'rare' AND T2.date = '2007-02-01'

Database: card_games
Question: List out the set name of the set code "ALL".
SQL: SELECT name FROM sets WHERE code = 'ALL'

Database: toxicology
Question: What are the atoms that are bonded in the molecule TR001 with the bond ID of TR001_2_6?
Evidence: TR001 is the molecule id; TR001_2_6 is the bond id
SQL: SELECT SUBSTR(T.bond_id, 1, 7) AS atom_id1 , T.molecule_id || SUBSTR(T.bond_id, 8, 2) AS atom_id2 FROM bond AS T WHERE T.molecule_id = 'TR001' AND T.bond_id = 'TR001_2_6'

Database: financial
Question: What was the growth rate of the total amount of loans across all accounts for a male client between 1996 and 1997?
Evidence: Growth rate = (sum of amount_1997 - sum of amount_1996) / (sum of amount_1996) * 100%; Male refers to gender = 'M'
SQL: SELECT CAST((SUM(CASE WHEN STRFTIME('%Y', T1.date) = '1997' THEN T1.amount ELSE 0 END) - SUM(CASE WHEN STRFTIME('%Y', T1.date) = '1996' THEN T1.amount ELSE 0 END)) AS REAL) * 100 / SUM(CASE WHEN STRFTIME('%Y', T1.date) = '1996' THEN T1.amount ELSE 0 END) FROM loan AS T1 INNER JOIN account AS T2 ON T1.account_id = T2.account_id INNER JOIN disp AS T3 ON T3.account_id = T2.account_id INNER JOIN client AS T4 ON T4.client_id = T3.client_id WHERE T4.gender = 'M' AND T3.type = 'OWNER'

Database: debit_card_specializing
Question: How many transactions taken place in the gas station in the Czech Republic are with a price of over 1000?
Evidence: Gas station in the Czech Republic implies that Country = 'CZE'
SQL: SELECT COUNT(T1.TransactionID) FROM transactions_1k AS T1 INNER JOIN gasstations AS T2 ON T1.GasStationID = T2.GasStationID WHERE T2.Country = 'CZE' AND T1.Price > 1000

Database: debit_card_specializing
Question: What kind of currency did the customer paid at 16:25:00 in 2012/8/24?
Evidence: '2012/8/24' can be represented by '2012-08-24'; 
SQL: SELECT DISTINCT T3.Currency FROM transactions_1k AS T1 INNER JOIN gasstations AS T2 ON T1.GasStationID = T2.GasStationID INNER JOIN customers AS T3 ON T1.CustomerID = T3.CustomerID WHERE T1.Date = '2012-08-24' AND T1.Time = '16:25:00'

Database: codebase_community
Question: Which user has a higher reputation, Harlan or Jarrod Dixon?
Evidence: "Harlan" and "Jarrod Dixon" are both DisplayName; highest reputation refers to Max(Reputation)
SQL: SELECT DisplayName FROM users WHERE DisplayName IN ('Harlan', 'Jarrod Dixon') AND Reputation = ( SELECT MAX(Reputation) FROM users WHERE DisplayName IN ('Harlan', 'Jarrod Dixon') )

Database: formula_1
Question: How many accidents did the driver who had the highest number accidents in the Canadian Grand Prix have?
Evidence: number of accidents refers to the number where statusid = 3; Canadian Grand Prix refers to the race of name

SQL: SELECT COUNT(T1.driverId) FROM results AS T1 INNER JOIN races AS T2 on T1.raceId = T2.raceId INNER JOIN status AS T3 on T1.statusId = T3.statusId WHERE T3.statusId = 3 AND T2.name = 'Canadian Grand Prix' GROUP BY T1.driverId ORDER BY COUNT(T1.driverId) DESC LIMIT 1

Database: student_club
Question: Give the event ID, location, and status of events conducted from November 2019 to March 2020.
Evidence: event_date BETWEEN '2019-11-01' and '2020-03-31'
SQL: SELECT event_id, location, status FROM event WHERE date(SUBSTR(event_date, 1, 10)) BETWEEN '2019-11-01' AND '2020-03-31'

Database: superhero
Question: Among the superheroes with height from 170 to 190, list the names of the superheroes with no eye color.
Evidence: height from 170 to 190 refers to height_cm BETWEEN 170 AND 190; no eye color refers to colour = 'No Colour'
SQL: SELECT DISTINCT T1.superhero_name FROM superhero AS T1 INNER JOIN colour AS T2 ON T1.eye_colour_id = T2.id WHERE T1.height_cm BETWEEN 170 AND 190 AND T2.colour = 'No Colour'

Database: european_football_2
Question: Give the name of the league had the most matches end as draw in the 2016 season?
Evidence: most matches end as draw refers to MAX(SUM(home_team_goal = away_team_goal)); 2016 season refers to season = '2015/2016';
SQL: SELECT t2.name FROM Match AS t1 INNER JOIN League AS t2 ON t1.league_id = t2.id WHERE t1.season = '2015/2016' AND t1.home_team_goal = t1.away_team_goal GROUP BY t2.name ORDER BY COUNT(t1.id) DESC LIMIT 1

Database: card_games
Question: How many cards are there in the set 'World Championship Decks 2004' with the converted mana cost as '3'.
Evidence: the set 'World Championship Decks 2004' refers to name = 'World Championship Decks 2004'
SQL: SELECT COUNT(id) FROM cards WHERE setCode IN ( SELECT code FROM sets WHERE name = 'World Championship Decks 2004' ) AND convertedManaCost = 3