Database: thrombosis_prediction
Question: What is the most common illness that doctors identified among the patients whose lab work was done between 1/1/1985, and 12/31/1995?
Evidence: the most common illness refers to MAX(COUNT(Diagnosis)); lab work between 1/1/1985 and 12/31/1995 refers to `Examination Date` between '1985-01-01' and '1995-12-31 '
SQL: SELECT T2.Diagnosis FROM Examination AS T1 INNER JOIN Patient AS T2 ON T1.ID = T2.ID WHERE T1.`Examination Date` BETWEEN '1985-01-01' AND '1995-12-31' GROUP BY T2.Diagnosis ORDER BY COUNT(T2.Diagnosis) DESC LIMIT 1

Database: european_football_2
Question: List all the football player with the highest potential score.
Evidence: potential score refers to potential; highest potential score refers to MAX(potential);
SQL: SELECT DISTINCT(t1.player_name) FROM Player AS t1 INNER JOIN Player_Attributes AS t2 ON t1.player_api_id = t2.player_api_id WHERE t2.potential = (SELECT MAX(potential) FROM Player_Attributes)

Database: toxicology
Question: What are the elements of the atoms of TR144_8_19?
Evidence: TR144_8_19 is the bond id; 
SQL: SELECT T2.element FROM connected AS T1 INNER JOIN atom AS T2 ON T1.atom_id = T2.atom_id WHERE T1.bond_id = 'TR144_8_19'

Database: superhero
Question: Identify the weakest attribute of the Black Panther.
Evidence: weakest attribute refers to attribute_name WHERE MIN(attribute_value); Black Panther refers to superhero_name = 'Black Panther';
SQL: SELECT T3.attribute_name FROM superhero AS T1 INNER JOIN hero_attribute AS T2 ON T1.id = T2.hero_id INNER JOIN attribute AS T3 ON T2.attribute_id = T3.id WHERE T1.superhero_name = 'Black Panther' ORDER BY T2.attribute_value ASC LIMIT 1

Database: superhero
Question: Provide superheroes' names who have the adaptation power.
Evidence: adaptation power refers to power_name = 'Adaptation';
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 = 'Adaptation'

Database: toxicology
Question: What is the percentage of molecules that are carcinogenic? Please provide your answer as a percentage with three decimal places.
Evidence: label = '+' mean molecules are carcinogenic; percentage = DIVIDE(SUM(label = '+'), COUNT(molecule_id)) as percent
SQL: SELECT ROUND(CAST(COUNT(CASE WHEN T.label = '+' THEN T.molecule_id ELSE NULL END) AS REAL) * 100 / COUNT(T.molecule_id),3) FROM molecule t

Database: toxicology
Question: List all the elements of atoms that can not bond with any other atoms.
Evidence:  atoms cannot bond with other atoms means atom_id NOT in connected table;
SQL: SELECT DISTINCT T.element FROM atom AS T WHERE T.element NOT IN ( SELECT DISTINCT T1.element FROM atom AS T1 INNER JOIN connected AS T2 ON T1.atom_id = T2.atom_id )

Database: student_club
Question: Please list the phone numbers of the students from the Student_Club that has attended the event "Women's Soccer".
Evidence: Women's Soccer is an event name; phone numbers refers to phone
SQL: SELECT T3.phone FROM event AS T1 INNER JOIN attendance AS T2 ON T1.event_id = T2.link_to_event INNER JOIN member AS T3 ON T2.link_to_member = T3.member_id WHERE T1.event_name = 'Women''s Soccer'

Database: student_club
Question: List the names of closed event as "game" that was closed from 3/15/2019 to 3/20/2020.
Evidence: name of events refers event_name; game event that was closed refers to type = 'Game' where status = 'Closed'; event_date BETWEEN '2019-03-15' and '2020-03-20'; 
SQL: SELECT DISTINCT event_name FROM event WHERE type = 'Game' AND date(SUBSTR(event_date, 1, 10)) BETWEEN '2019-03-15' AND '2020-03-20' AND status = 'Closed'

Database: thrombosis_prediction
Question: Among the patients with a normal Ig G level, how many of them have symptoms?
Evidence: normal Ig G level refers to IGG > 900 and IGG < 2000; have symptoms refers to Symptoms IS NOT NULL;
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 T3.ID = T2.ID WHERE T2.IGG BETWEEN 900 AND 2000 AND T3.Symptoms IS NOT NULL

Database: thrombosis_prediction
Question: For the patients with the normal glutamic pylvic transaminase level, how many of them are male?
Evidence: normal glutamic pylvic transaminase level refers to GOT < 60; male refers to Sex = 'M';
SQL: SELECT COUNT(T1.ID) FROM Patient AS T1 INNER JOIN Laboratory AS T2 ON T1.ID = T2.ID WHERE T2.GOT < 60 AND T1.SEX = 'M'

Database: financial
Question: How many credit card withdrawals were recorded after 1995?
Evidence: Operation = 'VYBER KARTOU' means credit card withdrawals
SQL: SELECT COUNT(account_id) FROM trans WHERE STRFTIME('%Y', date) > '1995' AND operation = 'VYBER KARTOU'

Database: toxicology
Question: Which bond ids are double-bond with carcinogenic compound?
Evidence: label = '+' mean molecules are carcinogenic; double bond refers to bond_type = ' = ';
SQL: SELECT T1.bond_id FROM bond AS T1 INNER JOIN molecule AS T2 ON T1.molecule_id = T2.molecule_id WHERE T2.label = '+' AND T1.bond_type = '='

Database: european_football_2
Question: What is the ADO Den Haag team freedom of movement in the 1st two thirds of the pitch?
Evidence: ADO Den Haag refers to team_long_name = 'ADO Den Haag'; freedom of movement in the 1st two thirds of the pitch refers to buildUpPlayPositioningClass;
SQL: SELECT DISTINCT t2.buildUpPlayPositioningClass FROM Team AS t1 INNER JOIN Team_attributes AS t2 ON t1.team_fifa_api_id = t2.team_fifa_api_id WHERE t1.team_long_name = 'ADO Den Haag'

Database: thrombosis_prediction
Question: List the patient ID, sex and birthday who has abnormal white blood cell count. Group them by sex and list the patient by age in ascending order.
Evidence: abnormal white blood cell count refers to WBC < = 3.5 or WBC > = 9.0;
SQL: SELECT DISTINCT T1.ID, T1.SEX, T1.Birthday FROM Patient AS T1 INNER JOIN Laboratory AS T2 ON T1.ID = T2.ID WHERE T2.WBC <= 3.5 OR T2.WBC >= 9.0 GROUP BY T1.SEX,T1.ID ORDER BY T1.Birthday ASC

Database: superhero
Question: What is the average weight of all female superheroes?
Evidence: female refers to gender = 'Female'; average weight refers to AVG(weight_kg)
SQL: SELECT AVG(T1.weight_kg) FROM superhero AS T1 INNER JOIN gender AS T2 ON T1.gender_id = T2.id WHERE T2.gender = 'Female'

Database: financial
Question: How many accounts who choose issuance after transaction are staying in East Bohemia region?
Evidence: A3 contains the data of region; 'POPLATEK PO OBRATU' represents for 'issuance after transaction'.
SQL: SELECT COUNT(T2.account_id) FROM district AS T1 INNER JOIN account AS T2 ON T1.district_id = T2.district_id WHERE T1.A3 = 'east Bohemia' AND T2.frequency = 'POPLATEK PO OBRATU'

Database: codebase_community
Question: How old is the most influential user?
Evidence: How old describes age; the most influential refers to user where MAX(Reputation);
SQL: SELECT Age FROM users WHERE Reputation = ( SELECT MAX(Reputation) FROM users )

Database: thrombosis_prediction
Question: How many male patients have elevated total bilirubin count?
Evidence: male refers to SEX = 'M'; elevated means above the normal range; total bilirubin above the normal range refers to `T-BIL` >= '2.0'
SQL: SELECT COUNT(DISTINCT T1.ID) FROM Patient AS T1 INNER JOIN Laboratory AS T2 ON T1.ID = T2.ID WHERE T2.`T-BIL` >= 2.0 AND T1.SEX = 'M'

Database: thrombosis_prediction
Question: Provide all ID, sex and birthday of patients whose urea nitrogen (UN) just within the borderline of passing?
Evidence: urea nitrogen (UN) just within the borderline of passing refers to UN = 29; 
SQL: SELECT DISTINCT T1.ID, T1.SEX, T1.Birthday FROM Patient AS T1 INNER JOIN Laboratory AS T2 ON T1.ID = T2.ID WHERE T2.UN = 29