Database: european_football_2
Question: Tell the defensive work rate for Kevin Berigaud on 2013/2/22.
Evidence: Kevin Berigaud refers to player_name = 'Kevin Berigaud'; on 2013/2/22 refers to date = '2013-02-22 00:00:00'
SQL: SELECT t2.defensive_work_rate FROM Player AS t1 INNER JOIN Player_Attributes AS t2 ON t1.player_fifa_api_id = t2.player_fifa_api_id WHERE SUBSTR(t2.`date`, 1, 10) = '2013-02-22' AND t1.player_name = 'Kevin Berigaud'

Database: superhero
Question: Find the race of the superhero who weighs 108kg and is 188cm tall.
Evidence: weighs 108kg refers to weight_kg = 108; 188cm tall refers to height_cm = 188;
SQL: SELECT DISTINCT T2.race FROM superhero AS T1 INNER JOIN race AS T2 ON T1.race_id = T2.id WHERE T1.weight_kg = 108 AND T1.height_cm = 188

Database: toxicology
Question: Calculate the total atoms with triple-bond molecules containing the element phosphorus or bromine.
Evidence: triple bond refers to bond_type = '#'; phosphorus refers to element = 'p'; bromine refers to element = 'br'
SQL: SELECT COUNT(T1.atom_id) FROM atom AS T1 INNER JOIN molecule AS T2 ON T1.molecule_id = T2.molecule_id INNER JOIN bond AS T3 ON T2.molecule_id = T3.molecule_id WHERE T3.bond_type = '#' AND T1.element IN ('p', 'br')

Database: student_club
Question: What county did Sherri Ramsey grew up?
SQL: SELECT T2.county FROM member AS T1 INNER JOIN zip_code AS T2 ON T1.zip = T2.zip_code WHERE T1.first_name = 'Sherri' AND T1.last_name = 'Ramsey'

Database: student_club
Question: Calculate the amount budgeted for 'April Speaker' event. List all the budgeted categories for said event in an ascending order based on their amount budgeted.
Evidence: 'April Speaker' is an event name; amount budgeted refers to SUM(amount); budget categories refers to category
SQL: SELECT T2.category, SUM(T2.amount) FROM event AS T1 JOIN budget AS T2 ON T1.event_id = T2.link_to_event WHERE T1.event_name = 'April Speaker' GROUP BY T2.category ORDER BY SUM(T2.amount) ASC

Database: california_schools
Question: Among the schools with the average score in Math over 560 in the SAT test, how many schools are directly charter-funded?
SQL: SELECT COUNT(T2.`School Code`) FROM satscores AS T1 INNER JOIN frpm AS T2 ON T1.cds = T2.CDSCode WHERE T1.AvgScrMath > 560 AND T2.`Charter Funding Type` = 'Directly funded'

Database: card_games
Question: List all the mythic rarity print cards banned in gladiator format.
Evidence: mythic rarity printing refers to rarity = 'mythic'; card banned refers to status = 'Banned'; in gladiator format refers to format = 'gladiator';
SQL: SELECT DISTINCT T1.id FROM cards AS T1 INNER JOIN legalities AS T2 ON T1.uuid = T2.uuid WHERE T2.format = 'gladiator' AND T2.status = 'Banned' AND T1.rarity = 'mythic'

Database: card_games
Question: Find all cards illustrated by Stephen Daniel and describe the text of the ruling of these cards. State if these cards have missing or degraded properties and values.
Evidence: cards have missing or degraded properties and value refers to hasContentWarning = 1; 'Stephen Daniele' is artist; Find all cards refers to return card id
SQL: SELECT T1.id, T2.text, T1.hasContentWarning FROM cards AS T1 INNER JOIN rulings AS T2 ON T1.uuid = T2.uuid WHERE T1.artist = 'Stephen Daniele'

Database: debit_card_specializing
Question: Which year recorded the most consumption of gas paid in CZK?
Evidence: The first 4 strings of the Date values in the yearmonth table can represent year.
SQL: SELECT SUBSTR(T2.Date, 1, 4) FROM customers AS T1 INNER JOIN yearmonth AS T2 ON T1.CustomerID = T2.CustomerID WHERE T1.Currency = 'CZK' GROUP BY SUBSTR(T2.Date, 1, 4) ORDER BY SUM(T2.Consumption) DESC LIMIT 1

Database: superhero
Question: List down at least five full name of Demi-God superheroes.
Evidence: Demi-God superheroes refers to race = 'Demi-God'
SQL: SELECT T1.full_name FROM superhero AS T1 INNER JOIN race AS T2 ON T1.race_id = T2.id WHERE T2.race = 'Demi-God'

Database: codebase_community
Question: Calculate the ratio of votes in 2010 and 2011.
Evidence: DIVIDE(COUNT(Id where YEAR(CreationDate) = 2010), COUNT(Id where YEAR(CreationDate) = 2011)) FROM votes;
SQL: SELECT CAST(SUM(IIF(STRFTIME('%Y', CreationDate) = '2010', 1, 0)) AS REAL) / SUM(IIF(STRFTIME('%Y', CreationDate) = '2011', 1, 0)) FROM votes

Database: european_football_2
Question: What's the long name for the team GEN?
Evidence: long name for the team refers to team_long_name; team_short_name = 'GEN';
SQL: SELECT team_long_name FROM Team WHERE team_short_name = 'GEN'

Database: superhero
Question: How many vampire superheroes are there?
Evidence: vampire superheroes refers to race = 'Vampire'
SQL: SELECT COUNT(T1.superhero_name) FROM superhero AS T1 INNER JOIN race AS T2 ON T1.race_id = T2.id WHERE T2.race = 'Vampire'

Database: superhero
Question: List the skin colour of the superheroes with 100 attribute value.
Evidence: skin colour refers to colour.colour where skin_colour_id = colour.id; 100 attribute value refers to attribute_value = 100;
SQL: SELECT DISTINCT T2.colour FROM superhero AS T1 INNER JOIN colour AS T2 ON T1.skin_colour_id = T2.id INNER JOIN hero_attribute AS T3 ON T1.id = T3.hero_id WHERE T3.attribute_value = 100

Database: card_games
Question: Find and list the names of sets which doesn't have Japanese translation but have Korean translation.
Evidence: names of sets refers to name; doesn't have Japanese translation refers to language not like '%Japanese%'; have Korean translation refers to language = 'Korean'
SQL: SELECT name FROM sets WHERE code IN ( SELECT setCode FROM set_translations WHERE language = 'Korean' AND language NOT LIKE '%Japanese%' )

Database: thrombosis_prediction
Question: What was the gender of the first AORTITIS diagnosed patient?
Evidence: gender means SEX; 'AORTITIS' refers to Diagnosis;
SQL: SELECT SEX FROM Patient WHERE Diagnosis = 'AORTITIS' AND `First Date` IS NOT NULL ORDER BY `First Date` ASC LIMIT 1

Database: formula_1
Question: Please list the location coordinates of the US circuits.
Evidence: location coordinates refers to (lat, lng); the US refers to country = 'USA';
SQL: SELECT lat, lng FROM circuits WHERE country = 'USA'

Database: thrombosis_prediction
Question: When is the laboratory examination of patient '48473' where his/her AST glutamic oxaloacetic transaminase (GOT) index is above the normal range.
Evidence: AST glutamic oxaloacetic transaminase (GOT) index is above the normal range refers to GOT > = 60; when refers to DATE
SQL: SELECT Date FROM Laboratory WHERE ID = 48473 AND GOT >= 60

Database: formula_1
Question: Which driver created the fastest lap speed in a Formula_1 race? Please give both his forename and surname.
SQL: SELECT T1.forename, T1.surname FROM drivers AS T1 INNER JOIN results AS T2 ON T2.driverId = T1.driverId WHERE T2.fastestLapTime IS NOT NULL ORDER BY T2.fastestLapSpeed DESC LIMIT 1

Database: formula_1
Question: For the driver who had the Q2 time as 0:01:40 in the qualifying race No. 355, what is his nationality?
Evidence: race number refers to raceId;
SQL: SELECT DISTINCT T2.nationality FROM qualifying AS T1 INNER JOIN drivers AS T2 ON T2.driverId = T1.driverId WHERE T1.raceId = 355 AND T1.q2 LIKE '1:40%'

Database: superhero
Question: Please list the superhero names of all the superheroes that have blue eyes and blond hair.
Evidence: blue eyes refers to colour = 'Blue' and eye_colour_id = colour.id; blond hair refers to colour = 'Blond' and hair_colour_id = colour.id; super power of "Agility" refers to power_name = 'Agility'
SQL: SELECT T1.superhero_name FROM superhero AS T1 INNER JOIN colour AS T2 ON T1.eye_colour_id = T2.id INNER JOIN colour AS T3 ON T1.hair_colour_id = T3.id WHERE T2.colour = 'Blue' AND T3.colour = 'Blond'

Database: california_schools
Question: Which active district has the highest average score in Reading?
SQL: SELECT T1.District FROM schools AS T1 INNER JOIN satscores AS T2 ON T1.CDSCode = T2.cds WHERE T1.StatusType = 'Active' ORDER BY T2.AvgScrRead DESC LIMIT 1