Database: financial
Question: Please provide a list of clients who were born between 1983 and 1987 and whose account branch is in East Bohemia, along with their IDs.
SQL: SELECT T1.client_id, T3.account_id FROM client AS T1 INNER JOIN district AS T2 ON T1.district_id = T2.district_id INNER JOIN disp AS T4 ON T1.client_id = T4.client_id INNER JOIN account AS T3 ON T2.district_id = T3.district_id and T4.account_id = T3.account_id WHERE T2.A3 = 'east Bohemia' AND STRFTIME('%Y', T1.birth_date) BETWEEN '1983' AND '1987'

Database: codebase_community
Question: How many tags have post count between 5,000 to 7,000?
Evidence: post count between 5,000 to 7,000 refers to Count BETWEEN 5000 and 7000;
SQL: SELECT COUNT(Id) FROM tags WHERE Count BETWEEN 5000 AND 7000

Database: thrombosis_prediction
Question: What is the age gap between the youngest and oldest patient with a normal triglyceride recorded?
Evidence: age gap refers to SUBTRACT(MAX(year(Birthday)) - MIN(year(Birthday))); normal triglyceride refers to tg > = 200
SQL: SELECT STRFTIME('%Y', MAX(T1.Birthday)) - STRFTIME('%Y', MIN(T1.Birthday)) FROM Patient AS T1 INNER JOIN Laboratory AS T2 ON T1.ID = T2.ID WHERE T2.TG >= 200

Database: student_club
Question: What is the total expense for the Yearly Kickoff?
Evidence: 'Yearly Kickoff' is an event name; total expense refers to SUM(cost)
SQL: SELECT SUM(T3.cost) 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 = 'Yearly Kickoff'

Database: toxicology
Question: What is the composition of element chlorine in percentage among the single bond molecules?
Evidence: element chlorine refers to element = 'cl'; single bond refers to bond_type = '-'; percentage = DIVIDE(SUM(element = 'cl'), COUNT(atom_id)) as percent where bond_type = '-'
SQL: SELECT CAST(COUNT(CASE WHEN T.element = 'cl' THEN T.atom_id ELSE NULL END) AS REAL) * 100 / COUNT(T.atom_id) FROM ( SELECT T1.atom_id, T1.element FROM atom AS T1 INNER JOIN molecule AS T2 ON T1.molecule_id = T2.molecule_id INNER JOIN bond AS T3 ON T2.molecule_id = T3.molecule_id WHERE T3.bond_type = '-' ) AS T

Database: student_club
Question: What is the amount of the funds that the Vice President received?
Evidence: 'Vice President' is a position of Student Club; funds received refers to amount.
SQL: SELECT T2.amount FROM member AS T1 INNER JOIN income AS T2 ON T1.member_id = T2.link_to_member WHERE T1.position = 'Vice President'

Database: codebase_community
Question: How many users were from New York?
Evidence: New York refers to Location;
SQL: SELECT COUNT(Id) FROM users WHERE Location = 'New York'

Database: thrombosis_prediction
Question: For the male patients that have a normal prothrombin time, what is their average prothrombin time?
Evidence: male refers to Sex = 'M'; normal prothrombin time refer to PT < 14; average prothrombin time = AVG(PT);
SQL: SELECT AVG(T2.PT) FROM Patient AS T1 INNER JOIN Laboratory AS T2 ON T1.ID = T2.ID WHERE T2.PT < 14 AND T1.SEX = 'M'

Database: formula_1
Question: Which citizenship do the vast majority of the drivers hold?
Evidence: Citizenship of majority of drivers = MAX(nationality); citizenship and nationality are synonyms


SQL: SELECT nationality FROM drivers GROUP BY nationality ORDER BY COUNT(driverId) DESC LIMIT 1

Database: formula_1
Question: For the driver who set the fastest lap speed, what is his nationality?
Evidence: the fastest lap speed refers to (MAX) fastestLapSpeed;
SQL: SELECT T1.nationality FROM drivers AS T1 INNER JOIN results AS T2 ON T2.driverId = T1.driverId ORDER BY T2.fastestLapSpeed DESC LIMIT 1

Database: superhero
Question: Please list the full names of all the superheroes with over 15 super powers.
Evidence: 15 super powers refers to COUNT(full_name) > 15
SQL: SELECT DISTINCT T1.full_name FROM superhero AS T1 INNER JOIN hero_power AS T2 ON T1.id = T2.hero_id GROUP BY T1.full_name HAVING COUNT(T2.power_id) > 15

Database: financial
Question: How many accounts have an owner disposition and request for a statement to be generated upon a transaction?
Evidence: Frequency = 'POPLATEK PO OBRATU' stands for issuance after transaction
SQL: SELECT COUNT(T1.account_id) FROM account AS T1 INNER JOIN disp AS T2 ON T1.account_id = T2.account_id WHERE T2.type = 'OWNER' AND T1.frequency = 'POPLATEK PO OBRATU'

Database: card_games
Question: How many white bordered cards are powerful?
Evidence: white bordered cards refer to borderColor = 'white'; powerful cards refers to cardKingdomFoilId is not null AND cardKingdomId is not null (replace)
SQL: SELECT COUNT(id) FROM cards WHERE borderColor = 'white' AND cardKingdomId IS NOT NULL AND cardKingdomFoilId IS NOT NULL

Database: debit_card_specializing
Question: Among the transactions made in the gas stations in the Czech Republic, how many of them are taken place after 2012/1/1?
Evidence: Czech Republic can be represented as the Country value in the gasstations table is '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 STRFTIME('%Y', T1.Date) >= '2012'

Database: card_games
Question: Name the foreign name of the card that has boros watermark? List out the type of this card.
SQL: SELECT DISTINCT T1.name, T1.type FROM cards AS T1 INNER JOIN foreign_data AS T2 ON T2.uuid = T1.uuid WHERE T1.watermark = 'boros'

Database: codebase_community
Question: How many posts does the user csgillespie own?
Evidence: "csgillespie" is the DisplayName of user
SQL: SELECT COUNT(T1.id) FROM posts AS T1 INNER JOIN users AS T2 ON T1.OwnerUserId = T2.Id WHERE T2.DisplayName = 'csgillespie'

Database: codebase_community
Question: Which users have posted the most comments. List out the user's badge?
Evidence: user with the most comments refers to UserId where Max(Count(Id)
SQL: SELECT Name FROM badges AS T1 INNER JOIN comments AS T2 ON T1.UserId = t2.UserId GROUP BY T2.UserId ORDER BY COUNT(T2.UserId) DESC LIMIT 1

Database: codebase_community
Question: What is the total number of comments of all the posts owned by csgillespie?
Evidence: "csgillespie" is the DisplayName of user; total number of comments refers to Sum(CommentCount)
SQL: SELECT SUM(T1.CommentCount) FROM posts AS T1 INNER JOIN users AS T2 ON T1.OwnerUserId = T2.Id WHERE T2.DisplayName = 'csgillespie'

Database: financial
Question: How many accounts in North Bohemia has made a transaction with the partner's bank being AB?
Evidence: A3 contains the region names; North Bohemia is a region.
SQL: SELECT COUNT(T2.account_id) 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.bank = 'AB' AND T1.A3 = 'north Bohemia'

Database: student_club
Question: When did the member, Casey Mason, received the income?
Evidence: when the income was received refers to date_received
SQL: SELECT T2.date_received FROM member AS T1 INNER JOIN income AS T2 ON T1.member_id = T2.link_to_member WHERE T1.first_name = 'Casey' AND T1.last_name = 'Mason'

Database: california_schools
Question: What are the websites for all the partially virtual chartered schools located in San Joaquin?
Evidence: Virtual = 'P' means partially virtual; Charter schools refers to Charter = 1 in the table schools
SQL: SELECT Website FROM schools WHERE County = 'San Joaquin' AND Virtual = 'P' AND Charter = 1

Database: european_football_2
Question: Does the KSV Cercle Brugge team have a slow, balanced or fast speed class?
Evidence: KSV Cercle Brugge refers to team_long_name = 'KSV Cercle Brugge'; speed class refers to buildUpPlaySpeedClass
SQL: SELECT DISTINCT t1.buildUpPlaySpeedClass FROM Team_Attributes AS t1 INNER JOIN Team AS t2 ON t1.team_api_id = t2.team_api_id WHERE t2.team_long_name = 'KSV Cercle Brugge'