Database: card_games
Question: What's the unconverted mana cost of the card "Ancestor's Chosen"?
Evidence: card "Ancestor's Chosen" refers to name = 'Ancestor`s Chosen'
SQL: SELECT DISTINCT manaCost FROM cards WHERE name = 'Ancestor''s Chosen'

Database: european_football_2
Question: What was the average overall rating for Marko Arnautovic from 2007/2/22 to 2016/4/21?
Evidence: average overall rating refers to avg(overall_rating); Marko Arnautovic refers to player_name = 'Marko Arnautovic'; from 2007/2/22 to 2016/4/21 refers to the first 10 characters of date BETWEEN '2007-02-22' and '2016-04-21'
SQL: SELECT CAST(SUM(t2.overall_rating) AS REAL) / COUNT(t2.id) FROM Player AS t1 INNER JOIN Player_Attributes AS t2 ON t1.player_fifa_api_id = t2.player_fifa_api_id WHERE t1.player_name = 'Marko Arnautovic' AND SUBSTR(t2.`date`, 1, 10) BETWEEN '2007-02-22' AND '2016-04-21'

Database: debit_card_specializing
Question: Which are the top five best selling products? Please state the full name of them.
Evidence: Description of products contains full name
SQL: SELECT T2.Description FROM transactions_1k AS T1 INNER JOIN products AS T2 ON T1.ProductID = T2.ProductID ORDER BY T1.Amount DESC LIMIT 5

Database: toxicology
Question: Which molecule does the atom TR001_10 belong to? Please state whether this molecule is carcinogenic or not.
Evidence: TR001_10 is the atom id; label = '+' mean molecules are carcinogenic
SQL: SELECT T2.molecule_id , IIF(T2.label = '+', 'YES', 'NO') AS flag_carcinogenic FROM atom AS T1 INNER JOIN molecule AS T2 ON T1.molecule_id = T2.molecule_id WHERE T1.atom_id = 'TR001_10'

Database: european_football_2
Question: Give the name of the league with the highest matches of all time and how many matches were played in the said league.
Evidence:  league with highest matches of all time refers to MAX(COUNT(league_id));
SQL: SELECT t2.name, t1.max_count FROM League AS t2 JOIN (SELECT league_id, MAX(cnt) AS max_count FROM (SELECT league_id, COUNT(id) AS cnt FROM Match GROUP BY league_id) AS subquery) AS t1 ON t1.league_id = t2.id

Database: codebase_community
Question: When did the user known as 'IrishStat' create his or her account?
Evidence: DisplayName = 'IrishStat'; when create his or her account refers to CreationDate;
SQL: SELECT CreationDate FROM users WHERE DisplayName = 'IrishStat'

Database: student_club
Question: State the name of major that Vice President has joined.
Evidence: name of major refers to major_name; 'Vice President' is position of Student Club
SQL: SELECT T1.major_name FROM major AS T1 INNER JOIN member AS T2 ON T1.major_id = T2.link_to_major WHERE T2.position = 'Vice President'

Database: california_schools
Question: List the names of schools with more than 30 difference in enrollements between K-12 and ages 5-17? Please also give the full street adress of the schools.
Evidence: Diffrence in enrollement = `Enrollment (K-12)` - `Enrollment (Ages 5-17)`
SQL: SELECT T1.School, T1.Street FROM schools AS T1 INNER JOIN frpm AS T2 ON T1.CDSCode = T2.CDSCode WHERE T2.`Enrollment (K-12)` - T2.`Enrollment (Ages 5-17)` > 30

Database: student_club
Question: List the expenses that spend more than fifty dollars on average.
Evidence: expense refers to expense_description; spend more than fifty dollars on average refers to DIVIDE( SUM(cost), COUNT(expense_id) ) > 50
SQL: SELECT expense_description FROM expense GROUP BY expense_description HAVING AVG(cost) > 50

Database: california_schools
Question: Please provide the National Center for Educational Statistics school district identification number for all schools with a School Ownership Code that are part of the State Special Schools.
Evidence: State Special Schools means that SOC = 31.
SQL: SELECT NCESDist FROM schools WHERE SOC = 31

Database: formula_1
Question: Paul di Resta was in the No. 853 race, what percent faster did he finish in the 853rd race than the next race for the fastest lap speed?
Evidence: Paul di Resta refers to the full name of the driver; Full name of the driver refers to drivers.forename ='Paul' and drivers.surname = 'di Resta'; race number refers to raceId; percentage = DIVIDE(SUBTRACT(fastestLapSpeed(raceId = 853), (fastestLapSpeed (raceId = 854)) * 100 , (fastestLapSpeed(raceId = 853))
SQL: SELECT (SUM(IIF(T2.raceId = 853, T2.fastestLapSpeed, 0)) - SUM(IIF(T2.raceId = 854, T2.fastestLapSpeed, 0))) * 100 / SUM(IIF(T2.raceId = 853, T2.fastestLapSpeed, 0)) FROM drivers AS T1 INNER JOIN results AS T2 ON T2.driverId = T1.driverId WHERE T1.forename = 'Paul' AND T1.surname = 'di Resta'

Database: superhero
Question: How many heroes have stealth power?
Evidence: stealth power refers to power_name = 'stealth';
SQL: SELECT COUNT(T1.hero_id) FROM hero_power AS T1 INNER JOIN superpower AS T2 ON T1.power_id = T2.id WHERE T2.power_name = 'Stealth'

Database: european_football_2
Question: How many matches in the 2015/2016 season were held in Scotland Premier League
?
Evidence: Scotland Premier League refers to League.name = 'Scotland Premier League';
SQL: SELECT COUNT(t2.id) FROM League AS t1 INNER JOIN Match AS t2 ON t1.id = t2.league_id WHERE t2.season = '2015/2016' AND t1.name = 'Scotland Premier League'

Database: superhero
Question: Provide the weight and race of the superhero with superhero ID 40.
Evidence: weight refers to weight_kg; superhero ID 40 refers to superhero.id = 40;
SQL: SELECT T1.weight_kg, T2.race FROM superhero AS T1 INNER JOIN race AS T2 ON T1.race_id = T2.id WHERE T1.id = 40

Database: student_club
Question: What is the name and major of members who had to spend more than a hundred dollars on an expense?
Evidence: full name refers to first_name, last_name; major of members refers to major_name; spend more than a hundred dollars on an expense refers to cost > 100
SQL: SELECT DISTINCT T1.first_name, T1.last_name, T2.major_name FROM member AS T1 INNER JOIN major AS T2 ON T2.major_id = T1.link_to_major INNER JOIN expense AS T3 ON T1.member_id = T3.link_to_member WHERE T3.cost > 100

Database: codebase_community
Question: Based on posts posted by Community, calculate the percentage of posts that use the R language.
Evidence: DIVIDE(COUNT(PostId WHERE TagName = 'r')), (COUNT(PostId WHERE DisplayName = 'Community')) as percentage; R language refers to tagname = 'r'
SQL: SELECT CAST(SUM(IIF(T3.TagName = 'r', 1, 0)) AS REAL) * 100 / COUNT(T1.Id) FROM users AS T1 INNER JOIN postHistory AS T2 ON T1.Id = T2.UserId INNER JOIN tags AS T3 ON T3.ExcerptPostId = T2.PostId WHERE T1.DisplayName = 'Community'

Database: formula_1
Question: Please list the time of the races held on Sepang International Circuit.
SQL: SELECT DISTINCT T2.time FROM circuits AS T1 INNER JOIN races AS T2 ON T2.circuitID = T1.circuitId WHERE T1.name = 'Sepang International Circuit'

Database: european_football_2
Question: What is the average overall rating of the football player Aaron Doran?
Evidence: average overall rating = AVG(overall_rating);
SQL: SELECT CAST(SUM(t2.overall_rating) AS REAL) / COUNT(t2.id) FROM Player AS t1 INNER JOIN Player_Attributes AS t2 ON t1.player_api_id = t2.player_api_id WHERE t1.player_name = 'Aaron Doran'

Database: toxicology
Question: What are the atoms of the triple bond with the molecule "TR041"?
Evidence: TR041 is the molecule id; triple bond refers to bond_type = '#';
SQL: SELECT T2.atom_id, T2.atom_id2 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_type = '#' AND T3.molecule_id = 'TR041'

Database: card_games
Question: Lists by ID all Creature-type cards with legal status.
Evidence: legal status refer to status = 'legal'; Goblin-type cards refer to types = 'Creature';
SQL: SELECT T1.id FROM cards AS T1 INNER JOIN rulings AS T2 ON T1.uuid = T2.uuid INNER JOIN legalities AS T3 ON T1.uuid = T3.uuid WHERE T3.status = 'Legal' AND T1.types = 'Creature'