Database: thrombosis_prediction
Question: How long did it take after patient number 821298 arrived at the hospital for the first time before her evaluation began?
Evidence: DATEDIFF(`Examination Date`, `First Date`)
SQL: SELECT STRFTIME('%d', T3.`Examination Date`) - STRFTIME('%d', T1.`First Date`) FROM Patient AS T1 INNER JOIN Examination AS T3 ON T1.ID = T3.ID WHERE T1.ID = 821298

Database: formula_1
Question: For the race happened on 2015/11/29, how many drivers finished the game?
Evidence: game and race are synonyms; drivers who finished the race should have record in time;
SQL: SELECT COUNT(T2.driverId) FROM races AS T1 INNER JOIN results AS T2 ON T2.raceId = T1.raceId WHERE T1.date = '2015-11-29' AND T2.time IS NOT NULL

Database: superhero
Question: What is Abomination's eye colour?
Evidence: Abomination refers to superhero_name = 'Abomination'; eye colour refers to colour.colour where eye_colour_id = colour.id;
SQL: SELECT T2.colour FROM superhero AS T1 INNER JOIN colour AS T2 ON T1.eye_colour_id = T2.id WHERE T1.superhero_name = 'Abomination'

Database: card_games
Question: Among the cards with converted mana cost higher than 5 in the set Coldsnap, how many of them have unknown power?
Evidence: card set Coldsnap refers to name = 'Coldsnap'; converted mana cost higher than 5 refers to convertedManaCost > 5; unknown power refers to power = '*' or T1.power is null
SQL: SELECT SUM(CASE WHEN T1.power LIKE '*' OR T1.power IS NULL THEN 1 ELSE 0 END) FROM cards AS T1 INNER JOIN sets AS T2 ON T2.code = T1.setCode WHERE T2.name = 'Coldsnap' AND T1.convertedManaCost > 5

Database: thrombosis_prediction
Question: For all patients who are older than 55 years old, what is the percentage of female who has abnormal prothrombin time (PT)?
Evidence: older than 55 years old = SUBTRACT(year(current_timestamp), year(Birthday)) > 55; abnormal prothrombin time (PT) refers to PT > = 14; percentage = DIVIDE(SUM(PT > = 14 AND SEX = 'F'), SUM(PT > = 14)) * 100; female refers to sex = 'F'; 
SQL: SELECT CAST(SUM(CASE WHEN T2.PT >= 14 AND T1.SEX = 'F' THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(*) FROM Patient AS T1 INNER JOIN Laboratory AS T2 ON T1.ID = T2.ID WHERE STRFTIME('%Y', CURRENT_TIMESTAMP) - STRFTIME('%Y', T1.Birthday) > 55

Database: superhero
Question: How many superheroes have a neutral alignment?
Evidence: neutral alignment refers to alignment_id = 3;
SQL: SELECT COUNT(T1.id) FROM superhero AS T1 INNER JOIN alignment AS T2 ON T1.alignment_id = T2.id WHERE T2.alignment = 'Neutral'

Database: formula_1
Question: As of the present, what is the full name of the youngest racer? Indicate her nationality and the name of the race to which he/she first joined.
Evidence: full name refers to forename+surname; Youngest racer = MAX(dob)
SQL: SELECT T1.forename, T1.surname, T1.nationality, T3.name FROM drivers AS T1 INNER JOIN driverStandings AS T2 on T1.driverId = T2.driverId INNER JOIN races AS T3 on T2.raceId = T3.raceId ORDER BY JULIANDAY(T1.dob) DESC LIMIT 1

Database: toxicology
Question: List the elements of all the triple bonds.
Evidence: triple bond refers to bond_type = '#';
SQL: SELECT DISTINCT T3.element FROM bond AS T1 INNER JOIN connected AS T2 ON T1.bond_id = T2.bond_id INNER JOIN atom AS T3 ON T2.atom_id = T3.atom_id WHERE T1.bond_type = '#'

Database: thrombosis_prediction
Question: When was the medical information on patient number 48473 first documented, and what disease did she have?
Evidence: medical information first documented refers to Description; disease refers to diagnosis; patient number refers to id
SQL: SELECT `First Date`, Diagnosis FROM Patient WHERE ID = 48473

Database: financial
Question: Please list the name of the districts with accounts that made withdrawal transactions.
Evidence: A2 refers to district name; type = 'VYDAJ' stands for withdrawal transactions
SQL: SELECT DISTINCT T1.A2 FROM district AS T1 INNER JOIN account AS T2 ON T1.district_id = T2.district_id INNER JOIN trans AS T3 ON T2.account_id = T3.account_id WHERE T3.type = 'VYDAJ'

Database: debit_card_specializing
Question: Among the customers who paid in euro, how many of them have a monthly consumption of over 1000?
Evidence: Pays in euro = Currency = 'EUR'.
SQL: SELECT COUNT(*) FROM yearmonth AS T1 INNER JOIN customers AS T2 ON T1.CustomerID = T2.CustomerID WHERE T2.Currency = 'EUR' AND T1.Consumption > 1000.00

Database: thrombosis_prediction
Question: List all patients who first came to the hospital after year 1992 with prothrombin time (PT) level that are normal.
Evidence: first came to the hospital after year 1992 refers to year(`First Date`) > 1992; prothrombin time (PT) level that are normal refers to PT < 14;
SQL: SELECT T1.ID FROM Patient AS T1 INNER JOIN Laboratory AS T2 ON T1.ID = T2.ID WHERE STRFTIME('%Y', T1.`First Date`) > '1992' AND T2.PT < 14

Database: student_club
Question: What was Brent Thomason's major?
Evidence: Brent Thomason is the full name; full name refers to first_name, last_name; major refers to major_name
SQL: SELECT T2.major_name FROM member AS T1 INNER JOIN major AS T2 ON T1.link_to_major = T2.major_id WHERE T1.first_name = 'Brent' AND T1.last_name = 'Thomason'

Database: thrombosis_prediction
Question: Provide IDs for male patients with ALT glutamic pylvic transaminase (GPT) that have history of ALT glutamic pylvic transaminase (GPT) exceed the normal range.
Evidence: male refers to SEX = 'M'; ALT glutamic pylvic transaminase (GPT) exceed the normal range refers to GPT > = 60
SQL: SELECT DISTINCT T1.ID FROM Patient AS T1 INNER JOIN Laboratory AS T2 ON T1.ID = T2.ID WHERE T1.SEX = 'M' AND T2.GPT >= 60

Database: superhero
Question: How many female superheroes are in Marvel Comics?
Evidence: female refers to gender = 'Female'; Marvel Comics 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 gender AS T3 ON T1.gender_id = T3.id WHERE T2.publisher_name = 'Marvel Comics' AND T3.gender = 'Female'

Database: card_games
Question: Among the sets whose expansion type is Commander, which set has the highest total number of cards including promotional and related supplemental products but excluding Alchemy modifications? Indicate the id of the set.
Evidence: expansion type refers to type where type = 'commander'; totalSetSize: The total number of cards in the set, including promotional and related supplemental products but excluding Alchemy modifications; highest total number of cards refers to MAX(totalSetSize)
SQL: SELECT id FROM sets WHERE type = 'commander' ORDER BY totalSetSize DESC LIMIT 1

Database: european_football_2
Question: Which player has the strongest overall strength?
Evidence: overall strength refers to overall_rating; strongest overall strength refers to MAX(overall_rating);
SQL: SELECT t1.player_name FROM Player AS t1 INNER JOIN Player_Attributes AS t2 ON t1.player_api_id = t2.player_api_id ORDER BY t2.overall_rating DESC LIMIT 1

Database: codebase_community
Question: How many users with more than 10 views created their account after the year 2013?
Evidence: more than 10 views refers to Views > 10; created after the year 2013 refers to year (CreationDate) > 2013
SQL: SELECT COUNT(id) FROM users WHERE STRFTIME('%Y', CreationDate) > '2013' AND Views > 10