Database: student_club
Question: Calculate the total cost spent for Parking in the list.
Evidence: total cost spent for Parking refers to SUM(cost) where expense_description = 'Parking'
SQL: SELECT SUM(cost) FROM expense WHERE expense_description = 'Parking'

Database: financial
Question: There was a loan approved in 1994/8/25, where was that account opened, give the district Id of the branch.
SQL: SELECT T1.district_id FROM account AS T1 INNER JOIN loan AS T2 ON T1.account_id = T2.account_id WHERE T2.date = '1994-08-25'

Database: toxicology
Question: Calculate the total carcinogenic molecules for molecule id from TR000 to TR030.
Evidence: label = '+' mean molecules are carcinogenic
SQL: SELECT COUNT(T.molecule_id) FROM molecule AS T WHERE T.molecule_id BETWEEN 'TR000' AND 'TR030' AND T.label = '+'

Database: student_club
Question: How many members attended the "Women's Soccer" event?
Evidence: 'Women's Soccer' is the event name;
SQL: SELECT COUNT(T2.link_to_member) FROM event AS T1 INNER JOIN attendance AS T2 ON T1.event_id = T2.link_to_event WHERE T1.event_name = 'Women''s Soccer'

Database: thrombosis_prediction
Question: List ID, sex and date of birth of patient whose total protein (TP) below the lower range of the normal index.
Evidence: total protein (TP) below the lower range of the normal index refers to TP < 6.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.TP < 6.0

Database: student_club
Question: Among the members with t-shirt size of medium, what is the percentage of the amount 50 received by the Student_Club?
Evidence: t_shirt_size = 'Medium' where position = 'Member'; percentage = DIVIDE(COUNT(amount = 50), COUNT(member_id)) * 100
SQL: SELECT CAST(SUM(CASE WHEN T2.amount = 50 THEN 1.0 ELSE 0 END) AS REAL) * 100 / COUNT(T2.income_id) FROM member AS T1 INNER JOIN income AS T2 ON T1.member_id = T2.link_to_member WHERE T1.position = 'Member' AND T1.t_shirt_size = 'Medium'

Database: formula_1
Question: How many times the circuits were held in Austria? Please give their location and coordinates.
Evidence: location coordinates refers to (lat,lng); Austria refers to country = 'Austria';
SQL: SELECT DISTINCT location, lat, lng FROM circuits WHERE country = 'Austria'

Database: student_club
Question: How many income are received with an amount of 50?
Evidence: amount of 50 refers to amount = 50
SQL: SELECT COUNT(income_id) FROM income WHERE amount = 50

Database: california_schools
Question: What is the average number of test takers from Fresno schools that opened between 1/1/1980 and 12/31/1980?
Evidence: between 1/1/1980 and 12/31/1980 means the year = 1980
SQL: SELECT AVG(T1.NumTstTakr) FROM satscores AS T1 INNER JOIN schools AS T2 ON T1.cds = T2.CDSCode WHERE strftime('%Y', T2.OpenDate) = '1980' AND T2.County = 'Fresno'

Database: toxicology
Question: List the atom ID of the carcinogenic molecule that contains oxygen?
Evidence: label = '+' mean molecules are carcinogenic; oxygen refers to element = 'o'
SQL: SELECT T1.atom_id FROM atom AS T1 INNER JOIN molecule AS T2 ON T1.molecule_id = T2.molecule_id WHERE T1.element = 'o' AND T2.label = '+'

Database: formula_1
Question: Which race has the shortest actual finishing time? Please give the name and year.
Evidence: shortest actual finishing time refers to Min(milliseconds) except milliseconds = null;
SQL: SELECT T1.name, T1.year FROM races AS T1 INNER JOIN results AS T2 on T1.raceId = T2.raceId WHERE T2.milliseconds IS NOT NULL ORDER BY T2.milliseconds LIMIT 1

Database: thrombosis_prediction
Question: For patients with alkaliphophatase (ALP) within normal range, were they treated as inpatient or outpatient?
Evidence: alkaliphophatase (ALP) within normal range refers to ALP < 300; inpatient refers to admission = '+'; outpatient refers to admission = '-'
SQL: SELECT T1.Admission FROM Patient AS T1 INNER JOIN Laboratory AS T2 ON T1.ID = T2.ID WHERE T2.ALP < 300

Database: card_games
Question: Find the uuid of cards in which the old school format is restricted or banned.
Evidence: old school format refers to format = 'oldschool'; restricted or banned refers to status = 'banned' or 'restricted'
SQL: SELECT uuid FROM legalities WHERE format = 'oldschool' AND (status = 'Banned' OR status = 'Restricted')

Database: financial
Question: Name the account numbers of female clients who are oldest and have lowest average salary?
Evidence: Female refers to 'F' in the gender; A11 contains information about average salary
SQL: SELECT T3.account_id FROM client AS T1 INNER JOIN district AS T2 ON T1.district_id = T2.district_id INNER JOIN account AS T3 ON T2.district_id = T3.district_id INNER JOIN disp AS T4 ON T1.client_id = T4.client_id AND T4.account_id = T3.account_id  WHERE T1.gender = 'F' ORDER BY T1.birth_date ASC, T2.A11 ASC LIMIT 1

Database: european_football_2
Question: State the chance creation passing class for "PEC Zwolle" on 2013/9/20.
Evidence: "PEC Zwolle" refers to team_long_name = 'PEC Zwolle'; on 2013/9/20 refers to date = '2013-09-20 00:00:00'
SQL: SELECT t2.chanceCreationPassingClass FROM Team AS t1 INNER JOIN Team_Attributes AS t2 ON t1.team_api_id = t2.team_api_id WHERE t1.team_long_name = 'PEC Zwolle' AND SUBSTR(t2.`date`, 1, 10) = '2013-09-20'

Database: superhero
Question: Which publisher published the slowest superhero?
Evidence: the slowest superhero refers to attribute_name = 'Speed' where MIN(attribute_value); publisher refers to publisher_name
SQL: SELECT T2.publisher_name FROM superhero AS T1 INNER JOIN publisher AS T2 ON T1.publisher_id = T2.id INNER JOIN hero_attribute AS T3 ON T1.id = T3.hero_id INNER JOIN attribute AS T4 ON T3.attribute_id = T4.id WHERE T4.attribute_name = 'Speed' ORDER BY T3.attribute_value LIMIT 1

Database: california_schools
Question: How many schools with an average score in Math greater than 400 in the SAT test are exclusively virtual?
Evidence: Exclusively virtual refers to Virtual = 'F'
SQL: SELECT COUNT(DISTINCT T2.School) FROM satscores AS T1 INNER JOIN schools AS T2 ON T1.cds = T2.CDSCode WHERE T2.Virtual = 'F' AND T1.AvgScrMath > 400

Database: card_games
Question: Mention the base set size and set code of the set that was in block named "Masques" and "Mirage".
SQL: SELECT DISTINCT T1.baseSetSize, T2.setCode FROM sets AS T1 INNER JOIN set_translations AS T2 ON T2.setCode = T1.code WHERE T1.block IN ('Masques', 'Mirage')

Database: student_club
Question: What's Christof Nielson's zip code type?
SQL: SELECT T2.type FROM member AS T1 INNER JOIN zip_code AS T2 ON T1.zip = T2.zip_code WHERE T1.first_name = 'Christof' AND T1.last_name = 'Nielson'

Database: formula_1
Question: What is his number of the driver who finished 0:01:54 in the Q3 of qualifying race No.903?
Evidence: race number refers to raceId; finished 0:0M:SS in the Q3 refers to q3 LIKE 'M:SS%'
SQL: SELECT T2.number FROM qualifying AS T1 INNER JOIN drivers AS T2 ON T2.driverId = T1.driverId WHERE T1.raceId = 903 AND T1.q3 LIKE '1:54%'

Database: student_club
Question: Mention the total expense used on 8/20/2019.
Evidence: total expense refers SUM(cost) where expense_date = '2019-08-20'
SQL: SELECT SUM(cost) FROM expense WHERE expense_date = '2019-08-20'

Database: student_club
Question: Which department was the President of the club in?
Evidence: 'President' is a position of Student Club
SQL: SELECT T2.department FROM member AS T1 INNER JOIN major AS T2 ON T1.link_to_major = T2.major_id WHERE T1.position = 'President'

Database: student_club
Question: State the name of students from Georgetown, South Carolina.
Evidence: name of students means the full name; full name refers to first_name, last_name; Georgetown is a city; South Carolina is a state
SQL: SELECT T1.first_name, T1.last_name FROM member AS T1 INNER JOIN zip_code AS T2 ON T1.zip = T2.zip_code WHERE T2.city = 'Georgetown' AND T2.state = 'South Carolina'