Database: student_club
Question: What is the most popular size of t-shirt ordered by the club members?
Evidence: most popular size of t-shirt ordered refers to MAX(COUNT(t_shirt_size))
SQL: SELECT t_shirt_size FROM member GROUP BY t_shirt_size ORDER BY COUNT(t_shirt_size) DESC LIMIT 1

Database: california_schools
Question: What is the administrator's email address for the school with the highest number of test takers who received SAT scores of at least 1500?Provide the name of the school.
SQL: SELECT T2.AdmEmail1, T2.School FROM satscores AS T1 INNER JOIN schools AS T2 ON T1.cds = T2.CDSCode ORDER BY T1.NumGE1500 DESC LIMIT 1

Database: card_games
Question: How many cards designed by UDON and available in mtgo print type has a starting maximum hand size of -1?
Evidence: UDON refer to artist; availabe in mtgo refers to availability = 'mtgo'; starting maximum hand size of -1 refers to hand = -1
SQL: SELECT COUNT(id) FROM cards WHERE hAND = '-1' AND artist = 'UDON' AND Availability = 'mtgo'

Database: card_games
Question: Is the set of cards with Adarkar Valkyrie only available outside the United States?
Evidence: card set Adarkar Valkyrie refers to name = 'Adarkar Valkyrie'; isForeignOnly = 1 means only available outside the United States;
SQL: SELECT IIF(isForeignOnly = 1, 'YES', 'NO') FROM cards AS T1 INNER JOIN sets AS T2 ON T2.code = T1.setCode WHERE T1.name = 'Adarkar Valkyrie'

Database: toxicology
Question: Name the atoms' elements that form bond TR000_2_3.
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
SQL: SELECT T2.element FROM connected AS T1 INNER JOIN atom AS T2 ON T1.atom_id = T2.atom_id WHERE T1.bond_id = 'TR000_2_3'

Database: codebase_community
Question: How many posts did Jay Stevens have in 2010?
Evidence: DisplayName = 'Jay Stevens'; in 2010 refers to YEAR(CreationDate) = 2010;
SQL: SELECT COUNT(T1.Id) FROM users AS T1 INNER JOIN posts AS T2 ON T1.Id = T2.OwnerUserId WHERE STRFTIME('%Y', T2.CreaionDate) = '2010' AND T1.DisplayName = 'Jay Stevens'

Database: financial
Question: In 1996, which districts have the highest unemployment rate? List their branch location and district name.
Evidence: A2 refers to district names; A13 refers to unemploymant rate in 1996
SQL: SELECT district_id, A2 FROM district ORDER BY A13 DESC LIMIT 1

Database: debit_card_specializing
Question: For the customer who paid 634.8 in 2012/8/25, what was the consumption decrease rate from Year 2012 to 2013?
Evidence: '2012/8/24' can be represented by '2012-08-24'; Consumption decrease rate = (consumption_2012 - consumption_2013) / consumption_2012
SQL: SELECT CAST(SUM(IIF(SUBSTR(Date, 1, 4) = '2012', Consumption, 0)) - SUM(IIF(SUBSTR(Date, 1, 4) = '2013', Consumption, 0)) AS FLOAT) / SUM(IIF(SUBSTR(Date, 1, 4) = '2012', Consumption, 0)) FROM yearmonth WHERE CustomerID = ( SELECT T1.CustomerID FROM transactions_1k AS T1 INNER JOIN gasstations AS T2 ON T1.GasStationID = T2.GasStationID WHERE T1.Date = '2012-08-25' AND T1.Price = 634.8 )

Database: toxicology
Question: Name all bonds with single bond types and what atoms are connected to the molecules.
Evidence: single bond refers to bond_type = '-';
SQL: SELECT T1.bond_id, T2.atom_id, T2.atom_id2 FROM bond AS T1 INNER JOIN connected AS T2 ON T1.bond_id = T2.bond_id WHERE T1.bond_type = '-'

Database: toxicology
Question: What is the element of toxicology for the atom with the ID of TR000_1?
Evidence: atom with ID refers to atom_id; 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
SQL: SELECT T.element FROM atom AS T WHERE T.atom_id = 'TR000_1'

Database: california_schools
Question: What are the webpages for the Los Angeles County school that has between 2,000 and 3,000 test takers?
SQL: SELECT T2.Website FROM satscores AS T1 INNER JOIN schools AS T2 ON T1.cds = T2.CDSCode WHERE T1.NumTstTakr BETWEEN 2000 AND 3000 AND T2.County = 'Los Angeles'

Database: codebase_community
Question: Under the vote type of 8, provide the display names and websites URLs of the user who got the highest bounty amount.
Evidence: vote type of 8 refers to VoteTypeId = 8; the highest bounty amount refers to MAX(BountyAmount);
SQL: SELECT DisplayName, WebsiteUrl FROM users WHERE Id = ( SELECT UserId FROM votes WHERE VoteTypeId = 8 ORDER BY BountyAmount DESC LIMIT 1 )

Database: student_club
Question: Write the full name of the club member with the position of 'Secretary' and list which college the club member belongs to.
Evidence: full name refers to first_name, last name
SQL: SELECT T1.first_name, T1.last_name, college FROM member AS T1 INNER JOIN major AS T2 ON T2.major_id = T1.link_to_major WHERE T1.position = 'Secretary'

Database: california_schools
Question: Of the schools with a mailing state address in California, what is the ratio of the schools located in the county of Colusa against the school located in the county of Humboldt?
Evidence: Ratio = count(schools in Colusa) / count(schools in Humboldt)
SQL: SELECT CAST(SUM(CASE WHEN County = 'Colusa' THEN 1 ELSE 0 END) AS REAL) / SUM(CASE WHEN County = 'Humboldt' THEN 1 ELSE 0 END) FROM schools WHERE MailState = 'CA'

Database: codebase_community
Question: Provide the text of the latest 10 comments to the post with the title 'Analysing wind data with R' and the display name of the user who left it.
Evidence: the latest comment refers to MAX(CreationDate);
SQL: SELECT T3.Text, T1.DisplayName FROM users AS T1 INNER JOIN posts AS T2 ON T1.Id = T2.OwnerUserId INNER JOIN comments AS T3 ON T2.Id = T3.PostId WHERE T2.Title = 'Analysing wind data with R' ORDER BY T1.CreationDate DESC LIMIT 10

Database: formula_1
Question: Which website should I go to if I want to know more about Anthony Davidson?
Evidence: website refers to url
SQL: SELECT url FROM drivers WHERE forename = 'Anthony' AND surname = 'Davidson'

Database: thrombosis_prediction
Question: When is the latest patient's medical data recorded? This patient should have an abnormal level of lactate dehydrogenase.
Evidence: latest patient refers to ID with MAX('First Date'); abnormal level of lactate dehydrogenase refers to LDH > = 500;
SQL: SELECT T1.`First Date` FROM Patient AS T1 INNER JOIN Laboratory AS T2 ON T1.ID = T2.ID WHERE T2.LDH >= 500 ORDER BY T1.`First Date` DESC LIMIT 1

Database: california_schools
Question: Name schools in Riverside which the average of average math score for SAT is grater than 400, what is the funding type of these schools?
Evidence: Average of average math = sum(average math scores) / count(schools).
SQL: SELECT T1.sname, T2.`Charter Funding Type` FROM satscores AS T1 INNER JOIN frpm AS T2 ON T1.cds = T2.CDSCode WHERE T2.`District Name` LIKE 'Riverside%' GROUP BY T1.sname, T2.`Charter Funding Type` HAVING CAST(SUM(T1.AvgScrMath) AS REAL) / COUNT(T1.cds) > 400

Database: california_schools
Question: What is the highest eligible free rate for K-12 students in the schools in Alameda County?
Evidence: Eligible free rate for K-12 = `Free Meal Count (K-12)` / `Enrollment (K-12)`
SQL: SELECT `Free Meal Count (K-12)` / `Enrollment (K-12)` FROM frpm WHERE `County Name` = 'Alameda' ORDER BY (CAST(`Free Meal Count (K-12)` AS REAL) / `Enrollment (K-12)`) DESC LIMIT 1