Database: card_games
Question: What is the foreign name of the card in French of type Creature, normal layout and black border color, by artist Matthew D. Wilson?
Evidence: in French refers to language = 'French'; black border color refers to borderColor = 'black'
SQL: SELECT name FROM foreign_data WHERE uuid IN ( SELECT uuid FROM cards WHERE types = 'Creature' AND layout = 'normal' AND borderColor = 'black' AND artist = 'Matthew D. Wilson' ) AND language = 'French'

Database: thrombosis_prediction
Question: Please provide the diagnosis of patients with ALT glutamic pylvic transaminase beyond the normal range by ascending order of their date of birth.
Evidence: ALT glutamic pylvic transaminase beyond the normal range refers to GPT > 60; The larger the birthday value, the younger the person is, and vice versa; 
SQL: SELECT DISTINCT T1.Diagnosis FROM Patient AS T1 INNER JOIN Laboratory AS T2 ON T1.ID = T2.ID WHERE T2.GPT > 60 ORDER BY T1.Birthday ASC

Database: financial
Question: Among the accounts who have loan validity more than 24 months, list out the accounts that have the lowest approved amount and have account opening date before 1997.
SQL: SELECT T1.account_id FROM loan AS T1 INNER JOIN account AS T2 ON T1.account_id = T2.account_id WHERE T1.duration > 24 AND STRFTIME('%Y', T2.date) < '1997' ORDER BY T1.amount ASC LIMIT 1

Database: financial
Question: How many accounts have running contracts in Branch location 1?
Evidence: Status = 'C' stands for running contract, OK so far; Status = 'D' stands for running contract, client in debt
SQL: SELECT COUNT(T1.account_id) FROM account AS T1 INNER JOIN district AS T2 ON T1.district_id = T2.district_id INNER JOIN loan AS T3 ON T1.account_id = T3.account_id WHERE T1.district_id = 1 AND (T3.status = 'C' OR T3.status = 'D')

Database: codebase_community
Question: What is the comment's rating score of the post which was created on 7/19/2010 7:19:56 PM
Evidence: created on 7/19/2010 7:19:56 PM refers to CreationDate = '2010-07-19 19:19:56.0'
SQL: SELECT T1.Score FROM comments AS T1 INNER JOIN posts AS T2 ON T1.PostId = T2.Id WHERE T1.CreationDate = '2010-07-19 19:19:56.0'

Database: formula_1
Question: In which Formula_1 race was the lap record for the Austrian Grand Prix Circuit set?
Evidence: lap record means the fastest time recorded which refers to time
SQL: WITH fastest_lap_times AS ( SELECT T1.raceId, T1.FastestLapTime, (CAST(SUBSTR(T1.FastestLapTime, 1, INSTR(T1.FastestLapTime, ':') - 1) AS REAL) * 60) + (CAST(SUBSTR(T1.FastestLapTime, INSTR(T1.FastestLapTime, ':') + 1, INSTR(T1.FastestLapTime, '.') - INSTR(T1.FastestLapTime, ':') - 1) AS REAL)) + (CAST(SUBSTR(T1.FastestLapTime, INSTR(T1.FastestLapTime, '.') + 1) AS REAL) / 1000) as time_in_seconds FROM results AS T1 WHERE T1.FastestLapTime IS NOT NULL ) SELECT T2.name FROM races AS T2 INNER JOIN circuits AS T3 on T2.circuitId = T3.circuitId INNER JOIN results AS T1 on T2.raceId = T1.raceId INNER JOIN ( SELECT MIN(fastest_lap_times.time_in_seconds) as min_time_in_seconds FROM fastest_lap_times INNER JOIN races AS T2 on fastest_lap_times.raceId = T2.raceId INNER JOIN circuits AS T3 on T2.circuitId = T3.circuitId WHERE T2.name = 'Austrian Grand Prix') AS T4 ON (CAST(SUBSTR(T1.FastestLapTime, 1, INSTR(T1.FastestLapTime, ':') - 1) AS REAL) * 60) + (CAST(SUBSTR(T1.FastestLapTime, INSTR(T1.FastestLapTime, ':') + 1, INSTR(T1.FastestLapTime, '.') - INSTR(T1.FastestLapTime, ':') - 1) AS REAL)) + (CAST(SUBSTR(T1.FastestLapTime, INSTR(T1.FastestLapTime, '.') + 1) AS REAL) / 1000) = T4.min_time_in_seconds WHERE T2.name = 'Austrian Grand Prix'

Database: thrombosis_prediction
Question: How many patients who were female got white blood cells that were below 3.5?
Evidence: female refers to SEX = 'F'; white blood cells that were below 3.5 refers to WBC < 3.5
SQL: SELECT COUNT(T1.ID) FROM Patient AS T1 INNER JOIN Laboratory AS T2 ON T1.ID = T2.ID WHERE T2.WBC < 3.5 AND T1.SEX = 'F'

Database: toxicology
Question: What is the percentage of double bonds in the molecule TR008? Please provide your answer as a percentage with five decimal places.
Evidence: double bond refers to bond_type = '='; TR008 is the molecule id; percentage = DIVIDE(SUM(bond_type = '='), COUNT(bond_id)) as percent where molecule_id = 'TR008'
SQL: SELECT ROUND(CAST(COUNT(CASE WHEN T.bond_type = '=' THEN T.bond_id ELSE NULL END) AS REAL) * 100 / COUNT(T.bond_id),5) FROM bond AS T WHERE T.molecule_id = 'TR008'

Database: debit_card_specializing
Question: What is the average total price of the transactions taken place in gas stations in the Czech Republic?
Evidence: Gas station in the Czech Republic implies that Country = 'CZE'
SQL: SELECT AVG(T1.Price) FROM transactions_1k AS T1 INNER JOIN gasstations AS T2 ON T1.GasStationID = T2.GasStationID WHERE T2.Country = 'CZE'

Database: toxicology
Question: List down the molecule id for non carcinogenic molecules.
Evidence: label = '-' means molecules are non-carcinogenic
SQL: SELECT T.molecule_id FROM molecule AS T WHERE T.label = '-'

Database: card_games
Question: What are the rulings for the card named and designed by Kev Walker? List them in descending order of dates.
Evidence: rulings refers to text; card named and designed by Kev Walker refers to artist = 'Kev Walker'; descending order of dates refers to MAX(date);
SQL: SELECT T2.text FROM cards AS T1 INNER JOIN rulings AS T2 ON T2.uuid = T1.uuid WHERE T1.artist = 'Kev Walker' ORDER BY T2.date DESC

Database: card_games
Question: Name all the cards which have alternative language in Japanese.
Evidence: Japanese' is the language;
SQL: SELECT T1.name FROM cards AS T1 INNER JOIN foreign_data AS T2 ON T1.uuid = T2.uuid WHERE T2.language = 'Japanese'

Database: student_club
Question: What are the expenses of the budget with the lowest remaining?
Evidence: expense of budget refers to expense_description; lowest remaining refers to MIN(remaining)
SQL: SELECT T2.expense_description FROM budget AS T1 INNER JOIN expense AS T2 ON T1.budget_id = T2.link_to_budget ORDER BY T1.remaining LIMIT 1

Database: formula_1
Question: Which constructors have been ranked 1?
SQL: SELECT DISTINCT T2.name FROM results AS T1 INNER JOIN constructors AS T2 on T1.constructorId = T2.constructorId WHERE T1.rank = 1

Database: thrombosis_prediction
Question: What is the anti Cardiolipin antibody concentration of the female patient with the highest uric acid level in the normal range?
Evidence: anti Cardiolipin antibody concentration refers to `aCL IgG`, `aCL IgM`, `aCL IgA`; female patient refers to Sex = F'; highest uric acid level in the normal range refers to MAX(UA > 6.50);
SQL: SELECT T3.`aCL IgG`, T3.`aCL IgM`, T3.`aCL IgA` 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 T1.SEX = 'F' AND T2.UA > 6.5 ORDER BY T2.UA DESC LIMIT 1

Database: codebase_community
Question: For the user whose display name is "DatEpicCoderGuyWhoPrograms", what is his/her badge's name?
Evidence: "DatEpicCoderGuyWhoPrograms" is the DisplayName;
SQL: SELECT T2.Name FROM users AS T1 INNER JOIN badges AS T2 ON T1.Id = T2.UserId WHERE T1.DisplayName = 'DatEpicCoderGuyWhoPrograms'

Database: codebase_community
Question: What is the name of user with the ID of 30?
Evidence: name of user refers to DisplayName;
SQL: SELECT DisplayName FROM users WHERE Id = 30

Database: toxicology
Question: Indicate which atoms are connected in non-carcinogenic type molecules.
Evidence: label = '-' means molecules are non-carcinogenic
SQL: SELECT DISTINCT T1.atom_id FROM atom AS T1 INNER JOIN molecule AS T2 ON T1.molecule_id = T2.molecule_id INNER JOIN connected AS T3 ON T1.atom_id = T3.atom_id WHERE T2.label = '-'

Database: student_club
Question: List out the type of events which have remaining budget more than 30 USD.
Evidence: remaining budget more than 30 USD refers to remaining > 30
SQL: SELECT T1.type FROM event AS T1 INNER JOIN budget AS T2 ON T1.event_id = T2.link_to_event WHERE T2.remaining > 30