Database: california_schools
Question: What is the Percent (%) Eligible Free (K-12) in the school administered by an administrator whose first name is Alusine. List the district code of the school.
Evidence: Percent (%) Eligible Free (K-12) = `Free Meal Count (K-12)` / `Enrollment (K-12)` * 100%
SQL: SELECT T1.`Free Meal Count (K-12)` * 100 / T1.`Enrollment (K-12)`, T1.`District Code` FROM frpm AS T1 INNER JOIN schools AS T2 ON T1.CDSCode = T2.CDSCode WHERE T2.AdmFName1 = 'Alusine'

Database: debit_card_specializing
Question: Which country was the card owner of No.667467 in?
SQL: SELECT T2.Country FROM transactions_1k AS T1 INNER JOIN gasstations AS T2 ON T1.GasStationID = T2.GasStationID WHERE T1.CardID = '667467'

Database: formula_1
Question: Please list the surnames of all the Italian drivers.
Evidence: Italian refers to nationality = 'italian'
SQL: SELECT surname FROM drivers WHERE nationality = 'Italian'

Database: thrombosis_prediction
Question: Among the patients who has a normal anti-scl70, how many of them are female and does not have any symptom?
Evidence: normal anti-scl70 refers to SC170 IN('negative', '0'); female refers to Sex = 'F'; does not have any symptom refers to symptoms IS NULL; Should consider DISTINCT in the final result;
SQL: SELECT COUNT(DISTINCT 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.SC170 = 'negative' OR T2.SC170 = '0') AND T1.SEX = 'F' AND T3.Symptoms IS NULL

Database: financial
Question: List all the withdrawals in cash transactions that the client with the id 3356 makes.
Evidence: operation = 'VYBER' refers to withdrawal in cash
SQL: SELECT T4.trans_id FROM client AS T1 INNER JOIN disp AS T2 ON T1.client_id = T2.client_id INNER JOIN account AS T3 ON T2.account_id = T3.account_id INNER JOIN trans AS T4 ON T3.account_id = T4.account_id WHERE T1.client_id = 3356 AND T4.operation = 'VYBER'

Database: student_club
Question: What kind of expenses incurred by members who have X-Large in size of tee shirt?
Evidence: kind of expenses refers to expense_description; t_shirt_size = 'X-Large'
SQL: SELECT T2.expense_description FROM member AS T1 INNER JOIN expense AS T2 ON T1.member_id = T2.link_to_member WHERE T1.t_shirt_size = 'X-Large'

Database: formula_1
Question: Please list the Formula_1 races that Lewis Hamilton participated.
SQL: SELECT T1.name FROM races AS T1 INNER JOIN results AS T2 ON T2.raceId = T1.raceId INNER JOIN drivers AS T3 ON T3.driverId = T2.driverId WHERE T3.forename = 'Lewis' AND T3.surname = 'Hamilton'

Database: california_schools
Question: What is the postal street address for the school with the 7th highest Math average? Indicate the school's name.
Evidence: Postal street and mailing street are synonyms.
SQL: SELECT T2.MailStreet, T2.School FROM satscores AS T1 INNER JOIN schools AS T2 ON T1.cds = T2.CDSCode ORDER BY T1.AvgScrMath DESC LIMIT 6, 1

Database: debit_card_specializing
Question: How much did the KAM customers consume in total in May 2013?
Evidence: May 2013 refers to yearmonth.date = 201305
SQL: SELECT SUM(T2.Consumption) FROM customers AS T1 INNER JOIN yearmonth AS T2 ON T1.CustomerID = T2.CustomerID WHERE T2.Date = '201305' AND T1.Segment = 'KAM'

Database: card_games
Question: Name the cards that were illustrated by Aaron Boyd.
Evidence: Aaron Boyd' is artist;
SQL: SELECT DISTINCT name FROM cards WHERE artist = 'Aaron Boyd'

Database: card_games
Question: How many Brazilian Portuguese translated sets are inside the Commander block?
Evidence: Commander block refer to block = 'Commander'; sets refer to code = setCode; Portuguese refer to language = 'Portuguese (Brasil)'
SQL: SELECT COUNT(T1.id) FROM sets AS T1 INNER JOIN set_translations AS T2 ON T1.code = T2.setCode WHERE T2.language = 'Portuguese (Brazil)' AND T1.block = 'Commander'

Database: formula_1
Question: Who is the champion of the Canadian Grand Prix in 2008? Indicate his finish time.
Evidence: Only the time of the champion shows in the format of "hour: minutes: seconds.millionsecond";
SQL: SELECT T1.time FROM results AS T1 INNER JOIN races AS T2 ON T1.raceId = T2.raceId WHERE T2.name = 'Canadian Grand Prix' AND T2.year = 2008 AND T1.time LIKE '_:%:__.___'

Database: california_schools
Question: What is the number of SAT test takers of the schools with the highest FRPM count for K-12 students?
SQL: SELECT NumTstTakr FROM satscores WHERE cds = ( SELECT CDSCode FROM frpm ORDER BY `FRPM Count (K-12)` DESC LIMIT 1 )

Database: codebase_community
Question: How many posts have a score less than 20?
Evidence: score less than 20 refers to Score < 20;
SQL: SELECT COUNT(id) FROM posts WHERE Score < 20

Database: card_games
Question: List down the uuid for legacy cards and the foreign language of these cards.
Evidence: legacy card refers to format = 'legacy'; foreign language refers to language in foreign_data
SQL: SELECT T1.uuid, T3.language FROM cards AS T1 INNER JOIN legalities AS T2 ON T1.uuid = T2.uuid INNER JOIN foreign_data AS T3 ON T1.uuid = T3.uuid WHERE T2.format = 'legacy'

Database: student_club
Question: What category was budgeted for the 'January Speaker' event and how much was the amount budgeted for that category?
Evidence: amount budgeted refers to amount, 'January Speaker' is the event name;
SQL: SELECT T2.category, T2.amount FROM event AS T1 INNER JOIN budget AS T2 ON T1.event_id = T2.link_to_event WHERE T1.event_name = 'January Speaker'

Database: toxicology
Question: Calculate the percentage of molecules containing carcinogenic compounds that element is hydrogen.
Evidence: hydrogen refers to element = 'h'; label = '+' mean molecules are carcinogenic; percentage = DIVIDE(SUM(label = '+' and element = 'h'), COUNT(molecule_id)) * 100.0
SQL: SELECT CAST(COUNT(CASE WHEN T1.element = 'h' AND T2.label = '+' THEN T2.molecule_id ELSE NULL END) AS REAL) * 100 / COUNT(T2.molecule_id) FROM atom AS T1 INNER JOIN molecule AS T2 ON T1.molecule_id = T2.molecule_id

Database: formula_1
Question: For all the drivers who finished the game in race No. 872, who is the youngest?
Evidence: race number refers to raceId; drivers who finished the race refers to time has value; the youngest is a driver where MAX(dob);
SQL: SELECT T1.forename, T1.surname FROM drivers AS T1 INNER JOIN results AS T2 ON T2.driverId = T1.driverId WHERE T2.raceId = 872 AND T2.time IS NOT NULL ORDER BY T1.dob DESC LIMIT 1

Database: codebase_community
Question: In posts with 1 comment, how many of the comments have 0 score?
Evidence: in posts with 1 comment refers to CommentCount = 1;
SQL: SELECT COUNT(T1.id) FROM comments AS T1 INNER JOIN posts AS T2 ON T1.PostId = T2.Id WHERE T2.CommentCount = 1 AND T2.Score = 0

Database: codebase_community
Question: How many views did the post titled 'Integration of Weka and/or RapidMiner into Informatica PowerCenter/Developer' get?
Evidence: "Integration of Weka and/or RapidMiner into Informatica PowerCenter/Developer" is the Title of post; views refers to ViewCount
SQL: SELECT ViewCount FROM posts WHERE Title = 'Integration of Weka and/or RapidMiner into Informatica PowerCenter/Developer'

Database: student_club
Question: Identify the type of expenses and their total value approved for 'October Meeting' event.
Evidence: total value refers to SUM(cost); 'October Meeting' is an event name;
SQL: SELECT T1.type, 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 = 'October Meeting'