Database: financial
Question: How many female clients' accounts are in the region of South Bohemia?
Evidence: Female refers to gender = 'F'; A3 contains the region 'south Bohemia'
SQL: SELECT COUNT(T1.client_id) FROM client AS T1 INNER JOIN district AS T2 ON T1.district_id = T2.district_id WHERE T1.gender = 'F' AND T2.A3 = 'south Bohemia'

Database: card_games
Question: How many cards that illusrtated in German have been reprinted?
Evidence: German' is the language; reprinted refers to isReprint = 1;
SQL: SELECT COUNT(T1.id) FROM cards AS T1 INNER JOIN foreign_data AS T2 ON T1.uuid = T2.uuid WHERE T2.language = 'German' AND T1.isReprint = 1

Database: thrombosis_prediction
Question: How many patients with a abnormal C-reactive protein don't have their data recorded?
Evidence: abnormal C-reactive protein refers to CRP ='+'; don't have data recorded refers to Description IS NULL;
SQL: SELECT COUNT(T1.ID) FROM Patient AS T1 INNER JOIN Laboratory AS T2 ON T1.ID = T2.ID WHERE (T2.CRP = '+' ) AND T1.Description IS NULL

Database: thrombosis_prediction
Question: What is the most common sign of patients with SLE disease?
Evidence: the most common sign refers to MAX(symptoms); 'SLE' refers to diagnosis
SQL: SELECT Symptoms FROM Examination WHERE Diagnosis = 'SLE' GROUP BY Symptoms ORDER BY COUNT(Symptoms) DESC LIMIT 1

Database: student_club
Question: What are the zip codes that have post office boxes in the country of the country of San Juan Municipio whose state is Puerto Rico?
Evidence: zip codes that have post office boxes refers to type = 'PO Box'
SQL: SELECT zip_code FROM zip_code WHERE type = 'PO Box' AND county = 'San Juan Municipio' AND state = 'Puerto Rico'

Database: card_games
Question: What was the release date for the set which card "Evacuation" in it?
Evidence: "Evacuation" refers to name = 'Evacuation'; release date refers to releaseDate
SQL: SELECT T2.releaseDate FROM cards AS T1 INNER JOIN sets AS T2 ON T2.code = T1.setCode WHERE T1.name = 'Evacuation'

Database: european_football_2
Question: List down most tallest players' name.
Evidence: tallest refers to rank based on the height in descending order; Most tallest players refers to rank = 1 
SQL: SELECT player_name FROM (SELECT player_name, height, DENSE_RANK() OVER (ORDER BY height DESC) as rank FROM Player) WHERE rank = 1

Database: formula_1
Question: How much faster in percentage is the champion than the driver who finished the race last in the 2008 Australian Grand Prix?
Evidence: how much faster in percentage = divide(subtract(incremental time, champion time), last_driver time) * 100; last driver finished time = incremental time + champion time; only champion's finished time is represented by 'HH:MM:SS.mmm'; finished the game refers to time is not null
SQL: WITH time_in_seconds AS ( SELECT T1.positionOrder, CASE WHEN T1.positionOrder = 1 THEN (CAST(SUBSTR(T1.time, 1, 1) AS REAL) * 3600) + (CAST(SUBSTR(T1.time, 3, 2) AS REAL) * 60) + CAST(SUBSTR(T1.time, 6) AS REAL) ELSE CAST(SUBSTR(T1.time, 2) AS REAL) END AS time_seconds FROM results AS T1 INNER JOIN races AS T2 ON T1.raceId = T2.raceId WHERE T2.name = 'Australian Grand Prix' AND T1.time IS NOT NULL AND T2.year = 2008 ), champion_time AS ( SELECT time_seconds FROM time_in_seconds WHERE positionOrder = 1), last_driver_incremental AS ( SELECT time_seconds FROM time_in_seconds WHERE positionOrder = (SELECT MAX(positionOrder) FROM time_in_seconds) ) SELECT (CAST((SELECT time_seconds FROM last_driver_incremental) AS REAL) * 100) / (SELECT time_seconds + (SELECT time_seconds FROM last_driver_incremental) FROM champion_time)

Database: thrombosis_prediction
Question: For patients with severe degree of thrombosis, list their ID, sex and disease the patient is diagnosed with.
Evidence: severe degree of thrombosis refers to thrombosis = 2; disease refers to diagnosis;
SQL: SELECT DISTINCT T1.ID, T1.SEX, T1.Diagnosis FROM Patient AS T1 INNER JOIN Examination AS T2 ON T1.ID = T2.ID WHERE T2.Thrombosis = 2

Database: formula_1
Question: How many Italian drivers haven't finished the race?
Evidence: haven't finished the race refers to time is null;
SQL: SELECT COUNT(T1.driverId) FROM results AS T1 INNER JOIN drivers AS T2 on T1.driverId = T2.driverId WHERE T2.nationality = 'Italian' AND T1.time IS NULL

Database: debit_card_specializing
Question: What is the difference in the annual average consumption of the customers with the least amount of consumption paid in CZK for 2013 between SME and LAM, LAM and KAM, and KAM and SME?
Evidence: annual average consumption of customer with the lowest consumption in each segment = total consumption per year / the number of customer with lowest consumption in each segment; Difference in annual average = SME's annual average - LAM's annual average; Difference in annual average = LAM's annual average - KAM's annual average; Year 2013 can be presented as Between 201301 And 201312; The first 4 strings of the Date values in the yearmonth table can represent year.
SQL: SELECT CAST(SUM(IIF(T1.Segment = 'SME', T2.Consumption, 0)) AS REAL) / COUNT(T1.CustomerID) - CAST(SUM(IIF(T1.Segment = 'LAM', T2.Consumption, 0)) AS REAL) / COUNT(T1.CustomerID) , CAST(SUM(IIF(T1.Segment = 'LAM', T2.Consumption, 0)) AS REAL) / COUNT(T1.CustomerID) - CAST(SUM(IIF(T1.Segment = 'KAM', T2.Consumption, 0)) AS REAL) / COUNT(T1.CustomerID) , CAST(SUM(IIF(T1.Segment = 'KAM', T2.Consumption, 0)) AS REAL) / COUNT(T1.CustomerID) - CAST(SUM(IIF(T1.Segment = 'SME', T2.Consumption, 0)) AS REAL) / COUNT(T1.CustomerID) FROM customers AS T1 INNER JOIN yearmonth AS T2 ON T1.CustomerID = T2.CustomerID WHERE T1.Currency = 'CZK' AND T2.Consumption = ( SELECT MIN(Consumption) FROM yearmonth ) AND T2.Date BETWEEN 201301 AND 201312

Database: thrombosis_prediction
Question: How old was the patient who had the highest hemoglobin count at the time of the examination, and what is the doctor's diagnosis?
Evidence: How old the patient refers to SUBTRACT(year(`Examination Date`), year(Birthday)); the highest hemoglobin count refers to MAX(HGB)
SQL: SELECT STRFTIME('%Y', T2.Date) - STRFTIME('%Y', T1.Birthday), T1.Diagnosis FROM Patient AS T1 INNER JOIN Laboratory AS T2 ON T1.ID = T2.ID ORDER BY T2.HGB DESC LIMIT 1

Database: student_club
Question: List all the expenses incurred by the vice president.
Evidence: expense refers to expense_description; 'Vice President' is a position of the Student Club
SQL: SELECT T2.expense_id, T2.expense_description FROM member AS T1 INNER JOIN expense AS T2 ON T1.member_id = T2.link_to_member WHERE T1.position = 'Vice President'

Database: toxicology
Question: Is the molecule with the most double bonds carcinogenic?
Evidence: double bond refers to bond_type = ' = '; label = '+' mean molecules are carcinogenic
SQL: SELECT T1.label FROM molecule AS T1 INNER JOIN ( SELECT T.molecule_id, COUNT(T.bond_type) FROM bond AS T WHERE T.bond_type = '=' GROUP BY T.molecule_id ORDER BY COUNT(T.bond_type) DESC LIMIT 1 ) AS T2 ON T1.molecule_id = T2.molecule_id

Database: thrombosis_prediction
Question: For the patients with an abnormal Ig M level, what is the most common disease they are diagnosed with?
Evidence: abnormal Ig M level refers to IGM <=40 OR IGM >= 400; most common disease refers to MAX(COUNT(Diagnosis));
SQL: SELECT T1.Diagnosis FROM Patient AS T1 INNER JOIN Laboratory AS T2 ON T1.ID = T2.ID WHERE T2.IGM NOT BETWEEN 40 AND 400 GROUP BY T1.Diagnosis ORDER BY COUNT(T1.Diagnosis) DESC LIMIT 1

Database: codebase_community
Question: How many votes did the user No.58 take on 2010/7/19?
Evidence: user no. 58 refers to UserId = 58; on 2010/7/19 refers to CreationDate = '2010-07-19'
SQL: SELECT COUNT(Id) FROM votes WHERE UserId = 58 AND CreationDate = '2010-07-19'