Database: debit_card_specializing
Question: What was the difference in gas consumption between CZK-paying customers and EUR-paying customers in 2012?
Evidence: Year 2012 can be presented as Between 201201 And 201212; The first 4 strings of the Date values in the yearmonth table can represent year; Difference in Consumption = CZK customers consumption in 2012 - EUR customers consumption in 2012
SQL: SELECT SUM(IIF(T1.Currency = 'CZK', T2.Consumption, 0)) - SUM(IIF(T1.Currency = 'EUR', T2.Consumption, 0)) FROM customers AS T1 INNER JOIN yearmonth AS T2 ON T1.CustomerID = T2.CustomerID WHERE SUBSTR(T2.Date, 1, 4) = '2012'

Database: thrombosis_prediction
Question: List all outpatient within normal range of creatinine phosphokinase. Give me the distinct ids.
Evidence: outpatient refers to Admission = '-'; normal range of creatinine phosphokinase refers to CPK < 250;
SQL: SELECT DISTINCT T1.ID FROM Patient AS T1 INNER JOIN Laboratory AS T2 ON T1.ID = T2.ID WHERE T2.CPK < 250 AND T1.Admission = '-'

Database: card_games
Question: In duels, what are the top 10 cards with the highest uncoverted mana cost?
Evidence: duels refer to format = 'duel'; the highest uncoverted mana cost refers to MAX(manaCost)
SQL: SELECT DISTINCT name FROM cards WHERE uuid IN ( SELECT uuid FROM legalities WHERE format = 'duel' ) ORDER BY manaCost DESC LIMIT 0, 10

Database: european_football_2
Question: What is the short name of the football team Queens Park Rangers?
Evidence: short name of the football team refers to team_short_name; Queens Park Rangers refers to team_long_name = 'Queens Park Rangers';
SQL: SELECT team_short_name FROM Team WHERE team_long_name = 'Queens Park Rangers'

Database: european_football_2
Question: Please state the finishing rate and curve score of the player who has the heaviest weight.
Evidence: finishing rate refer to finishing; curve score refer to curve; heaviest weight refers to MAX(weight)
SQL: SELECT id, finishing, curve FROM Player_Attributes WHERE player_api_id = ( SELECT player_api_id FROM Player ORDER BY weight DESC LIMIT 1 ) LIMIT 1

Database: financial
Question: Who is the owner of the account with the largest loan amount?
SQL: SELECT T1.client_id FROM disp AS T1 INNER JOIN account AS T3 ON T1.account_id = T3.account_id INNER JOIN loan AS T2 ON T3.account_id = T2.account_id WHERE T1.type = 'OWNER' ORDER BY T2.amount DESC LIMIT 1

Database: european_football_2
Question: What was the overall rating for Aaron Mooy on 2016/2/4?
Evidence: Aaron Mooy refers to player_name = 'Aaron Mooy'; on 2016/2/4 refers to date LIKE '2016-02-04%';
SQL: SELECT t2.overall_rating FROM Player AS t1 INNER JOIN Player_Attributes AS t2 ON t1.player_api_id = t2.player_api_id WHERE SUBSTR(t2.`date`, 1, 10) = '2016-02-04' AND t1.player_name = 'Aaron Mooy'

Database: superhero
Question: Identify the race of the superhero who weighed 169 kg.
Evidence: weighed 169 kg refers to weight_kg = 169
SQL: SELECT T2.race FROM superhero AS T1 INNER JOIN race AS T2 ON T1.race_id = T2.id WHERE T1.weight_kg = 169

Database: student_club
Question: How many majors are there in "College of Humanities and Social Sciences"?
SQL: SELECT COUNT(major_name) FROM major WHERE college = 'College of Humanities and Social Sciences'

Database: thrombosis_prediction
Question: How many male patients are are with creatinine index out of the normal range?
Evidence: creatinine (CRE) out of the normal range refers to CRE > = 1.5; Male refers to Sex = 'M'
SQL: SELECT COUNT(T1.ID) FROM Patient AS T1 INNER JOIN Laboratory AS T2 ON T1.ID = T2.ID WHERE T2.CRE >= 1.5 AND T1.SEX = 'M'

Database: european_football_2
Question: What is the attacking work rate of the football playerr Franco Zennaro?
SQL: SELECT DISTINCT t2.attacking_work_rate FROM Player AS t1 INNER JOIN Player_Attributes AS t2 ON t1.player_api_id = t2.player_api_id WHERE t1.player_name = 'Franco Zennaro'

Database: codebase_community
Question: What is the location of the owner of the post "Eliciting priors from experts"?
Evidence: Owner refers to OwnerUserId; 'Eliciting priors from experts' is the Title of post
SQL: SELECT T2.Location FROM posts AS T1 INNER JOIN users AS T2 ON T1.OwnerUserId = T2.Id WHERE T1.Title = 'Eliciting priors from experts'

Database: student_club
Question: What is the average amount paid by students in a position other than a member?
Evidence: position other than a member refers to position ! = 'Member'; average amount paid = DIVIDE( SUM(cost), COUNT(event_id))
SQL: SELECT AVG(T1.cost) FROM expense AS T1 INNER JOIN member as T2 ON T1.link_to_member = T2.member_id WHERE T2.position != 'Member'

Database: formula_1
Question: How many seasons has Silverstone Circuit hosted the United Kindom grand prix?
Evidence: British Grand Prix is the name of race; British refers to the United Kindom
SQL: SELECT COUNT(T2.circuitid) FROM circuits AS T1 INNER JOIN races AS T2 ON T2.circuitID = T1.circuitId WHERE T1.name = 'Silverstone Circuit' AND T2.name = 'British Grand Prix'

Database: european_football_2
Question: Among all the players whose weight is under 130, how many of them preferred foot in attacking is left?
Evidence: weight < 130; preferred foot in attacking refers to preferred_foot; preferred_foot = 'left';
SQL: SELECT COUNT(DISTINCT t1.id) FROM Player AS t1 INNER JOIN Player_Attributes AS t2 ON t1.player_api_id = t2.player_api_id WHERE t1.weight < 130 AND t2.preferred_foot = 'left'

Database: superhero
Question: Among the superheroes with the super power of "Super Strength", how many of them have a height of over 200cm?
Evidence: super power of "Super Strength" refers to power_name = 'Super Strength'; a height of over 200cm refers to height_cm > 200
SQL: SELECT COUNT(T1.id) FROM superhero AS T1 INNER JOIN hero_power AS T2 ON T1.id = T2.hero_id INNER JOIN superpower AS T3 ON T2.power_id = T3.id WHERE T3.power_name = 'Super Strength' AND T1.height_cm > 200

Database: european_football_2
Question: Please list player names which are higher than 180.
Evidence: height>180;
SQL: SELECT player_name FROM Player WHERE height > 180

Database: student_club
Question: Calculate the difference in the percentage of members in New Jersey and Vermont.
Evidence: SUBTRACT( DIVIDE( SUM(state = 'New Jersey'), COUNT(position = 'Member')), DIVIDE( SUM(state = 'Vermont'), COUNT(position = 'Member')) )
SQL: SELECT CAST((SUM(CASE WHEN T2.state = 'New Jersey' THEN 1 ELSE 0 END) - SUM(CASE WHEN T2.state = 'Vermont' THEN 1 ELSE 0 END)) AS REAL) * 100 / COUNT(T1.member_id) AS diff FROM member AS T1 INNER JOIN zip_code AS T2 ON T2.zip_code = T1.zip

Database: card_games
Question: Which of these artists have designed a card in the set Coldsnap, Jeremy Jarvis, Aaron Miller or Chippy?
Evidence: card set Coldsnap refers to name = 'Coldsnap'; Jeremy Jarvis, Aaron Miller or Chippy are the name of artists which refers to artist IN ('Jeremy Jarvis', 'Aaron Miller','Chippy');
SQL: SELECT T1.artist FROM cards AS T1 INNER JOIN sets AS T2 ON T2.code = T1.setCode WHERE (T2.name = 'Coldsnap' AND T1.artist = 'Chippy') OR (T2.name = 'Coldsnap' AND T1.artist = 'Aaron Miller') OR (T2.name = 'Coldsnap' AND T1.artist = 'Jeremy Jarvis') GROUP BY T1.artist

Database: toxicology
Question: What is the type of bond that molecule TR000 has when involved in any bonds?
Evidence: type of bond refers to bond_type; TR000 is the molecule id
SQL: SELECT DISTINCT T.bond_type FROM bond AS T WHERE T.molecule_id = 'TR000'

Database: superhero
Question: What is the publisher's name of Blue Beetle II?
Evidence: Blue Beetle II refers to superhero_name = 'Blue Beetle II'
SQL: SELECT T2.publisher_name FROM superhero AS T1 INNER JOIN publisher AS T2 ON T1.publisher_id = T2.id WHERE T1.superhero_name = 'Blue Beetle II'