Database: student_club
Question: Please indicate the college of the person whose first name is Katy with the link to the major "rec1N0upiVLy5esTO".
SQL: SELECT T2.college FROM member AS T1 INNER JOIN major AS T2 ON T2.major_id = T1.link_to_major WHERE T1.link_to_major = 'rec1N0upiVLy5esTO' AND T1.first_name = 'Katy'

Database: codebase_community
Question: Count the number of posts with a tag specified as 'careers'.
Evidence: tag specified as 'careers' refers to TagName = 'careers';
SQL: SELECT COUNT(Id) FROM tags WHERE TagName = 'careers'

Database: codebase_community
Question: Calculate the difference in view count from post posted by Mornington and view count from posts posted by Amos.
Evidence: calculation = SUBTRACT(SUM(ViewCount where DisplayName = 'Mornington'), SUM(ViewCount where DisplayName = 'Amos'));
SQL: SELECT SUM(IIF(T1.DisplayName = 'Mornington', T3.ViewCount, 0)) - SUM(IIF(T1.DisplayName = 'Amos', T3.ViewCount, 0)) AS diff FROM users AS T1 INNER JOIN postHistory AS T2 ON T1.Id = T2.UserId INNER JOIN posts AS T3 ON T3.Id = T2.PostId

Database: superhero
Question: What is Abomination's superpower?
Evidence: Abomination refers to superhero_name = 'Abomination'; superpower refers to power_name;
SQL: SELECT T3.power_name FROM superhero AS T1 INNER JOIN hero_power AS T2 ON T1.id = T2.hero_id INNER JOIN superpower AS T3 ON T2.power_id = T3.id WHERE T1.superhero_name = 'Abomination'

Database: financial
Question: How often does account number 3 request an account statement to be released? What was the aim of debiting 3539 in total?
Evidence: k_symbol refers to the purpose of payments
SQL: SELECT T1.frequency, T2.k_symbol FROM account AS T1 INNER JOIN (SELECT account_id, k_symbol, SUM(amount) AS total_amount FROM `order` GROUP BY account_id, k_symbol) AS T2 ON T1.account_id = T2.account_id WHERE T1.account_id = 3 AND T2.total_amount = 3539

Database: formula_1
Question: Which drivers who were born in 1971 and has the fastest lap time on the race? Give id and code of these drivers.
Evidence: born in 1971 refers to year(dob) = 1971; has the fastest lap time refers to fastestLapTime has values
SQL: SELECT T2.driverId, T2.code FROM results AS T1 INNER JOIN drivers AS T2 on T1.driverId = T2.driverId WHERE STRFTIME('%Y', T2.dob) = '1971' AND T1.fastestLapTime IS NOT NULL

Database: student_club
Question: How much did the Student_Club members spend on advertisement in September Meeting?
Evidence: amount spent refers to spent; spend on food in September Meeting refers to category = 'Advertisement' where event_name = 'September Meeting'
SQL: SELECT T2.spent FROM event AS T1 INNER JOIN budget AS T2 ON T1.event_id = T2.link_to_event WHERE T1.event_name = 'September Meeting' AND T2.category = 'Advertisement' AND SUBSTR(T1.event_date, 6, 2) = '09'

Database: toxicology
Question: Please list top three molecules that have single bonds between two atoms and are not carcinogenic in alphabetical order.
Evidence: label = '-' means molecules are not carcinogenic; single type bond refers to bond_type = '-'; list top three molecules refers to return molecule_id and order by molecule_id;
SQL: SELECT DISTINCT T2.molecule_id FROM bond AS T1 INNER JOIN molecule AS T2 ON T1.molecule_id = T2.molecule_id WHERE T1.bond_type = '-' AND T2.label = '-' ORDER BY T2.molecule_id LIMIT 3

Database: formula_1
Question: Show me the season page of year when the race No. 901 took place.
Evidence: race number refers to raceId;
SQL: SELECT T2.url FROM races AS T1 INNER JOIN seasons AS T2 ON T2.year = T1.year WHERE T1.raceId = 901

Database: formula_1
Question: Show me the season page of year when the race No. 901 took place.
Evidence: the season page refers to url; race number refers to raceId;
SQL: SELECT T2.url FROM races AS T1 INNER JOIN seasons AS T2 ON T2.year = T1.year WHERE T1.raceId = 901

Database: student_club
Question: Calculate the difference of the total amount spent in all events by the Student_Club in year 2019 and 2020.
Evidence: The first 4 strings of the event_date values in the event table can represent year; The difference of the total amount spent = SUBTRACT(spent where YEAR(event_date) = 2019, spent where YEAR(event_date) = 2020)
SQL: SELECT SUM(CASE WHEN SUBSTR(T1.event_date, 1, 4) = '2019' THEN T2.spent ELSE 0 END) - SUM(CASE WHEN SUBSTR(T1.event_date, 1, 4) = '2020' THEN T2.spent ELSE 0 END) AS num FROM event AS T1 INNER JOIN budget AS T2 ON T1.event_id = T2.link_to_event

Database: california_schools
Question: Please list the zip code of all the charter schools in Fresno County Office of Education.
Evidence: Charter schools refers to `Charter School (Y/N)` = 1 in the table fprm
SQL: SELECT T2.Zip FROM frpm AS T1 INNER JOIN schools AS T2 ON T1.CDSCode = T2.CDSCode WHERE T1.`District Name` = 'Fresno County Office of Education' AND T1.`Charter School (Y/N)` = 1

Database: card_games
Question: Please list the Italian text ruling of all the cards in the set Coldsnap.
Evidence: card set Coldsnap refers to name = 'Coldsnap'; Italian refers to language = 'Italian'
SQL: SELECT DISTINCT T1.text FROM foreign_data AS T1 INNER JOIN cards AS T2 ON T2.uuid = T1.uuid INNER JOIN sets AS T3 ON T3.code = T2.setCode WHERE T3.name = 'Coldsnap' AND T1.language = 'Italian'

Database: debit_card_specializing
Question: Which client ID consumed the most in September 2013?
Evidence: September 2013 refers to yearmonth.date = '201309'
SQL: SELECT T1.CustomerID FROM customers AS T1 INNER JOIN yearmonth AS T2 ON T1.CustomerID = T2.CustomerID WHERE T2.Date = '201309' GROUP BY T1.CustomerID ORDER BY SUM(T2.Consumption) DESC LIMIT 1

Database: card_games
Question: Which card name in the set 'Journey into Nyx Hero's Path' has the highest converted mana cost.
Evidence: set 'Journey into Nyx Hero's Path' refers to name = 'Journey into Nyx Hero''s Path'
SQL: SELECT T1.name FROM cards AS T1 INNER JOIN sets AS T2 ON T2.code = T1.setCode WHERE T2.name = 'Journey into Nyx Hero''s Path' ORDER BY T1.convertedManaCost DESC LIMIT 1

Database: superhero
Question: Provide the full names of vampire heroes.
Evidence: vampire heroes refers to race = 'Vampire';
SQL: SELECT T1.full_name FROM superhero AS T1 INNER JOIN race AS T2 ON T1.race_id = T2.id WHERE T2.race = 'Vampire'

Database: thrombosis_prediction
Question: For patient born between Year 1930 to 1940, how many percent of them were inpatient?
Evidence: patient born between Year 1930 to 1940 refers to year(Birthday) BETWEEN '1930-01-01' AND '1940-12-31'; inpatient refers to Admission = '+'
SQL: SELECT CAST(SUM(CASE WHEN Admission = '+' THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(*) FROM Patient WHERE STRFTIME('%Y', Birthday) BETWEEN '1930' AND '1940'

Database: codebase_community
Question: Among the comments with scores between 5 to 10, what is the percentage of the users with 0 up votes?
Evidence: percentage = DIVIDE(COUNT(UserId where UpVotes = 0 and Score BETWEEN 5 and 10))*100, (COUNT(UserId where Score BETWEEN 5 and 10));
SQL: SELECT CAST(SUM(IIF(T1.UpVotes = 0, 1, 0)) AS REAL) * 100/ COUNT(T1.Id) AS per FROM users AS T1 INNER JOIN comments AS T2 ON T1.Id = T2.UserId WHERE T2.Score BETWEEN 5 AND 10

Database: card_games
Question: Please list top three unknown power cards that have promotional types for arena league in alphabetical order.
Evidence: unknown power cards refers to power is null or power = '*'; promotional types for arena league refers to promoTypes = 'arenaleague'
SQL: SELECT name FROM cards WHERE (power IS NULL OR power LIKE '%*%') AND promoTypes = 'arenaleague' ORDER BY name LIMIT 3

Database: financial
Question: Which client issued his/her card in 1994/3/3, give his/her client id.
SQL: SELECT T2.client_id FROM client AS T1 INNER JOIN disp AS T2 ON T1.client_id = T2.client_id INNER JOIN card AS T3 ON T2.disp_id = T3.disp_id WHERE T3.issued = '1994-03-03'