Database: card_games
Question: Name all cards with 2015 frame style ranking below 100 on EDHRec.
Evidence: below 100 on EDHRec refers to EDHRec <100; with 2015 frame style refers to frameVersion = 2015;
SQL: SELECT id FROM cards WHERE edhrecRank < 100 AND frameVersion = 2015

Database: toxicology
Question: Identify whether the chemical compound that contains Calcium is carcinogenic.
Evidence: calcium refers to element = 'ca'; label = '+' mean molecules are carcinogenic; label = '-' means molecules are non-carcinogenic;
SQL: SELECT T2.label AS flag_carcinogenic FROM atom AS T1 INNER JOIN molecule AS T2 ON T1.molecule_id = T2.molecule_id WHERE T1.element = 'ca'

Database: card_games
Question: Among the cards that doesn't have multiple faces on the same card, who is the illustrator of the card art that has the highest cost of converted mana?
Evidence: doesn't have multiple faces refers to side IS NULL; illustrator refers to artist
SQL: SELECT artist FROM cards WHERE side IS NULL ORDER BY convertedManaCost DESC LIMIT 1

Database: thrombosis_prediction
Question: What is the highest anti-nucleus antibody concentration level of a patient with a normal creatinine level?
Evidence: highest anti-nucleus antibody concentration level refers to MAX(ANA); normal creatinine level refers to CRE < 1.5;
SQL: SELECT T2.ANA FROM Patient AS T1 INNER JOIN Examination AS T2 ON T1.ID = T2.ID INNER JOIN Laboratory AS T3 ON T1.ID = T3.ID WHERE T3.CRE < 1.5 ORDER BY T2.ANA DESC LIMIT 1

Database: california_schools
Question: What is the ratio of merged Unified School District schools in Orange County to merged Elementary School District schools?
Evidence: Elementary School District refers to DOC = 52; Unified School District refers to DOC = 54.
SQL: SELECT CAST(SUM(CASE WHEN DOC = 54 THEN 1 ELSE 0 END) AS REAL) / SUM(CASE WHEN DOC = 52 THEN 1 ELSE 0 END) FROM schools WHERE StatusType = 'Merged' AND County = 'Orange'

Database: financial
Question: What is the average number of crimes committed in 1995 in regions where the number exceeds 4000 and the region has accounts that are opened starting from the year 1997?
Evidence: A3 refers to region names; A15 stands for the average number of crimes commited in 1995.
SQL: SELECT AVG(T1.A15) FROM district AS T1 INNER JOIN account AS T2 ON T1.district_id = T2.district_id WHERE STRFTIME('%Y', T2.date) >= '1997' AND T1.A15 > 4000

Database: thrombosis_prediction
Question: How many male patients who underwent testing between 1995 and 1997 and were subsequently diagnosed with Behcet disease did not stay in the hospital for treatment?
Evidence: male refers to SEX = 'M'; underwent testing between 1995 and 1997 refers to `Examination Date` between '1995' and '1997'; Behcet refers to diagnosis; did not stay in the hospital refers to Admission = '-'
SQL: SELECT COUNT(T1.ID) FROM Patient AS T1 INNER JOIN Examination AS T2 ON T1.ID = T2.ID WHERE T2.Diagnosis = 'Behcet' AND T1.SEX = 'M' AND STRFTIME('%Y', T2.`Examination Date`) BETWEEN '1995' AND '1997' AND T1.Admission = '-'

Database: student_club
Question: How many income generated by Grant Gilmour?
Evidence: income generated refers to income.amount
SQL: SELECT T2.amount FROM member AS T1 INNER JOIN income AS T2 ON T1.member_id = T2.link_to_member WHERE T1.first_name = 'Grant' AND T1.last_name = 'Gilmour'

Database: superhero
Question: What is the hero's full name with the highest attribute in strength?
Evidence: highest attribute in strength refers to MAX(attribute_value) WHERE attribute_name = 'strength';
SQL: SELECT T1.full_name FROM superhero AS T1 INNER JOIN hero_attribute AS T2 ON T1.id = T2.hero_id INNER JOIN attribute AS T3 ON T2.attribute_id = T3.id WHERE T3.attribute_name = 'Strength' ORDER BY T2.attribute_value DESC LIMIT 1

Database: superhero
Question: What is the average height of a non-human superhero in Dark Horse Comics?
Evidence: average = AVG(height_cm); non-human superhero refers to race <> 'Human'; Dark Horse Comics refers to publisher_name = 'Dark Horse Comics';
SQL: SELECT AVG(T1.height_cm) FROM superhero AS T1 INNER JOIN publisher AS T2 ON T1.publisher_id = T2.id INNER JOIN race AS T3 ON T1.race_id = T3.id WHERE T2.publisher_name = 'Dark Horse Comics' AND T3.race != 'Human'

Database: debit_card_specializing
Question: For the customers who paid in the euro, what is their average total price of the transactions?
SQL: SELECT AVG(T1.Price) FROM transactions_1k AS T1 INNER JOIN gasstations AS T2 ON T1.GasStationID = T2.GasStationID INNER JOIN customers AS T3 ON T1.CustomerID = T3.CustomerID WHERE T3.Currency = 'EUR'

Database: codebase_community
Question: Which user have only one post history per post and having at least 1000 views?
Evidence: having at least 1000 view refers to Views > = 1000; user refers to UserId
SQL: SELECT T2.UserId FROM users AS T1 INNER JOIN postHistory AS T2 ON T1.Id = T2.UserId INNER JOIN posts AS T3 ON T2.PostId = T3.Id WHERE T3.ViewCount >= 1000 GROUP BY T2.UserId HAVING COUNT(DISTINCT T2.PostHistoryTypeId) = 1

Database: card_games
Question: What percentage of cards with format commander and legal status do not have a content warning?
Evidence: do not have a content warning refers to hasContentWarning = 0; percentage refers to DIVIDE(COUNT(hasContentWarning = 0),COUNT(ID))*100 where format = 'commander' AND Status = 'legal';
SQL: SELECT CAST(SUM(CASE WHEN T1.hasContentWarning = 0 THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(T1.id) FROM cards AS T1 INNER JOIN legalities AS T2 ON T1.uuid = T2.uuid WHERE T2.format = 'commander' AND T2.status = 'Legal'

Database: california_schools
Question: How many schools in Amador which the Low Grade is 9 and the High Grade is 12?
SQL: SELECT COUNT(T1.`School Name`) FROM frpm AS T1 INNER JOIN schools AS T2 ON T1.CDSCode = T2.CDSCode WHERE T2.County = 'Amador' AND T1.`Low Grade` = 9 AND T1.`High Grade` = 12

Database: toxicology
Question: What are the elements of the toxicology and label of molecule TR060?
Evidence: TR060 is the molecule id; 
SQL: SELECT DISTINCT T1.element, T2.label FROM atom AS T1 INNER JOIN molecule AS T2 ON T1.molecule_id = T2.molecule_id WHERE T2.molecule_id = 'TR060'

Database: toxicology
Question: How many molecules are carcinogenic and have the bromine element?
Evidence: label = '+' mean molecules are carcinogenic; have bromine element refers to element = 'br'
SQL: SELECT COUNT(DISTINCT T2.molecule_id) FROM atom AS T1 INNER JOIN molecule AS T2 ON T1.molecule_id = T2.molecule_id WHERE T2.label = '+' AND T1.element = 'br'

Database: california_schools
Question: What is the grade span offered in the school with the highest longitude?
Evidence: the highest longitude refers to the school with the maximum absolute longitude value.
SQL: SELECT GSoffered FROM schools ORDER BY ABS(longitude) DESC LIMIT 1

Database: card_games
Question: Calculate the percentage of the cards availabe in Chinese Simplified.
Evidence: Chinese Simplified' is the language; percentage = Divide(Sum(id where language = 'Chinese Simplified'), Count(id)) *100
SQL: SELECT CAST(SUM(CASE WHEN T2.language = 'Chinese Simplified' THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(T1.id) FROM cards AS T1 INNER JOIN foreign_data AS T2 ON T1.uuid = T2.uuid

Database: codebase_community
Question: What is the display name of the user who acquired the first Autobiographer badge?
Evidence: Autobiographer is the name of the badge; acquired the first refers to MIN(Date);
SQL: SELECT T1.DisplayName FROM users AS T1 INNER JOIN badges AS T2 ON T1.Id = T2.UserId WHERE T2.`Name` = 'Autobiographer' ORDER BY T2.Date LIMIT 1

Database: codebase_community
Question: Name 10 users with the badge name 'Necromancer.'
Evidence: "Necromancer" is the Name of badge; users refers to DisplayName
SQL: SELECT T1.DisplayName FROM users AS T1 INNER JOIN badges AS T2 ON T1.Id = T2.UserId WHERE T2.Name = 'Necromancer' LIMIT 10