Database: student_club
Question: With the biggest budget for the "Food", what was the remaining of it?
Evidence: remaining of budget refers to remaining, biggest budget for 'Food' refers to MAX(budget.amount) where category = 'Food'
SQL: SELECT remaining FROM budget WHERE category = 'Food' AND amount = ( SELECT MAX(amount) FROM budget WHERE category = 'Food' )

Database: toxicology
Question: How many connections does the atom 19 have?
Evidence: connections refers to bond_id; atom 19 refers to atom_id like 'TR%_19';
SQL: SELECT COUNT(T.bond_id) FROM connected AS T WHERE SUBSTR(T.atom_id, -2) = '19'

Database: codebase_community
Question: Which user added a bounty amount of 50 to the post title mentioning variance?
Evidence: bounty amount of 50 refers to BountyAmount = 50; user refers to DisplayName; title mentioning variance refers to Title include 'variance'
SQL: SELECT T3.DisplayName, T1.Title FROM posts AS T1 INNER JOIN votes AS T2 ON T1.Id = T2.PostId INNER JOIN users AS T3 ON T3.Id = T2.UserId WHERE T2.BountyAmount = 50 AND T1.Title LIKE '%variance%'

Database: european_football_2
Question: List the football players with a birthyear of 1970 and a birthmonth of October.
Evidence: players with a birthyear of 1970 and a birthmonth of October refers to substr(birthday,1,7) AS 'year-month',WHERE year = '1970' AND month = '10';
SQL: SELECT player_name FROM Player WHERE SUBSTR(birthday, 1, 7) = '1970-10'

Database: toxicology
Question: Name chemical elements that form a bond TR001_10_11.
Evidence: element = 'cl' means Chlorine; element = 'c' means Carbon; element = 'h' means Hydrogen; element = 'o' means Oxygen, element = 's' means Sulfur; element = 'n' means Nitrogen, element = 'p' means Phosphorus, element = 'na' means Sodium, element = 'br' means Bromine, element = 'f' means Fluorine; element = 'i' means Iodine; element = 'sn' means Tin; element = 'pb' means Lead; element = 'te' means Tellurium; element = 'ca' means Calcium; TR001_10_11 is the bond id; molecule id refers to SUBSTR(bond_id, 1, 5); atom 1 refers to SUBSTR(bond_id, 7, 2); atom 2 refers to SUBSTR(bond_id, 10, 2)
SQL: SELECT T1.element FROM atom AS T1 INNER JOIN connected AS T2 ON T1.atom_id = T2.atom_id INNER JOIN bond AS T3 ON T2.bond_id = T3.bond_id WHERE T3.bond_id = 'TR001_10_11'

Database: card_games
Question: Please provide top three sets that don't appear in Magic: The Gathering Online, along with their names in in alphabetical order.
Evidence: don't appear in Magic: The Gathering Online refers to mtgoCode is NULL or mtgoCode = ''
SQL: SELECT name FROM sets WHERE mtgoCode IS NULL ORDER BY name LIMIT 3

Database: codebase_community
Question: What is the percentage difference of student badges given during 2010 and 2011?
Evidence: student badges refers to badge's name = 'Student'; during 2010 refers to Year(Date) = 2010; during 2011 refers to Year(Date) = 2011; percentage difference = Subtract (Divide(Count(Name where Year(Date) = 2010), Count (Name)) *100, Divide(Count(Name where Year(Date) = 2011), Count(Name)) * 100)
SQL: SELECT CAST(SUM(IIF(STRFTIME('%Y', Date) = '2010', 1, 0)) AS REAL) * 100 / COUNT(Id) - CAST(SUM(IIF(STRFTIME('%Y', Date) = '2011', 1, 0)) AS REAL) * 100 / COUNT(Id) FROM badges WHERE Name = 'Student'

Database: card_games
Question: How many rare enchantment Abundance cards are there whose play format status are all legal?
Evidence: rare refers to rarity = 'rare'; enchantment card refers to types = 'Enchantment'; Abundance cards refers to name = 'Abundance'; format status are all legal refers to status = 'Legal'
SQL: SELECT COUNT(T1.id) FROM cards AS T1 INNER JOIN legalities AS T2 ON T2.uuid = T1.uuid WHERE T1.rarity = 'rare' AND T1.types = 'Enchantment' AND T1.name = 'Abundance' AND T2.status = 'Legal'

Database: superhero
Question: List down at least five superpowers of male superheroes.
Evidence: male refers to gender = 'Male'; superpowers 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 T3.id = T2.power_id INNER JOIN gender AS T4 ON T4.id = T1.gender_id WHERE T4.gender = 'Male' LIMIT 5

Database: financial
Question: For the client who applied 98832 USD loan in 1996/1/3, when was his/her birthday?
SQL: SELECT T4.birth_date FROM loan AS T1 INNER JOIN account AS T2 ON T1.account_id = T2.account_id INNER JOIN disp AS T3 ON T2.account_id = T3.account_id INNER JOIN client AS T4 ON T3.client_id = T4.client_id WHERE T1.date = '1996-01-03' AND T1.amount = 98832

Database: superhero
Question: Calculate the average height of all neutral superheroes.
SQL: SELECT AVG(T1.height_cm) FROM superhero AS T1 INNER JOIN alignment AS T2 ON T1.alignment_id = T2.id WHERE T2.alignment = 'Neutral'

Database: superhero
Question: What is the gender of Agent 13 hero?
Evidence: Agent 13 hero refers to superhero_name = 'Agent 13';
SQL: SELECT T2.gender FROM superhero AS T1 INNER JOIN gender AS T2 ON T1.gender_id = T2.id WHERE T1.superhero_name = 'Agent 13'

Database: codebase_community
Question: List out the age of users who located in Vienna, Austria obtained the badge?
Evidence: "Vienna, Austria" is the Location
SQL: SELECT T1.Age FROM users AS T1 INNER JOIN badges AS T2 ON T1.Id = T2.UserId WHERE T1.Location = 'Vienna, Austria'

Database: student_club
Question: Who was the first one paid his/her dues? Tell the full name.
Evidence: full name refers to first_name, last_name; first paid dues refers to MIN(received_date) where source = 'Dues'
SQL: SELECT T1.first_name, T1.last_name FROM member AS T1 INNER JOIN income AS T2 ON T1.member_id = T2.link_to_member WHERE T2.source = 'Dues' ORDER BY T2.date_received LIMIT 1

Database: debit_card_specializing
Question: Who among KAM's customers consumed the most? How much did it consume?
SQL: SELECT T2.CustomerID, SUM(T2.Consumption) FROM customers AS T1 INNER JOIN yearmonth AS T2 ON T1.CustomerID = T2.CustomerID WHERE T1.Segment = 'KAM' GROUP BY T2.CustomerID ORDER BY SUM(T2.Consumption) DESC LIMIT 1

Database: codebase_community
Question: List the title of posts which were edited by Vebjorn Ljosa.
Evidence: "Vebjorn Ljosa" is the DisplayName; last edited refers to LastEditorUserId
SQL: SELECT T1.Title FROM posts AS T1 INNER JOIN users AS T2 ON T1.OwnerUserId = T2.Id WHERE T2.DisplayName = 'Vebjorn Ljosa'

Database: card_games
Question: What proportion of cards do not have a text box with a normal layout?
Evidence: do not have a text box refers to isTextless = 1; proportion refers to DIVIDE(COUNT(Textless = 1 and layout = 'normal'),COUNT(Textless))*100
SQL: SELECT CAST(SUM(CASE WHEN isTextless = 1 AND layout = 'normal' THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(*) FROM cards

Database: financial
Question: List all ID and district for clients that can only have the right to issue permanent orders or apply for loans.
Evidence: Only the owner accounts have the right to issue permanent orders or apply for loans
SQL: SELECT T3.client_id, T2.district_id, T2.A2 FROM account AS T1 INNER JOIN district AS T2 ON T1.district_id = T2.district_id INNER JOIN disp AS T3 ON T1.account_id = T3.account_id WHERE T3.type = 'OWNER'

Database: california_schools
Question: What is the total number of schools with a mailing city in Hickman belonging to the charter number 00D4?
SQL: SELECT COUNT(*) FROM schools WHERE CharterNum = '00D4' AND MailCity = 'Hickman'

Database: california_schools
Question: How many active and closed District Community Day Schools are there in the county of Alpine?
SQL: SELECT COUNT(School) FROM schools WHERE (StatusType = 'Closed' OR StatusType = 'Active') AND SOC = 69 AND County = 'Alpine'