Database: debit_card_specializing
Question: What was the gas consumption peak month for SME customers in 2013?
Evidence: Year 2013 can be presented as Between 201301 And 201312; The first 4 strings of the Date values in the yearmonth table can represent year; The 5th and 6th string of the date can refer to month.
SQL: SELECT SUBSTR(T2.Date, 5, 2) FROM customers AS T1 INNER JOIN yearmonth AS T2 ON T1.CustomerID = T2.CustomerID WHERE SUBSTR(T2.Date, 1, 4) = '2013' AND T1.Segment = 'SME' GROUP BY SUBSTR(T2.Date, 5, 2) ORDER BY SUM(T2.Consumption) DESC LIMIT 1

Database: student_club
Question: List out the full name and total cost that member id "rec4BLdZHS2Blfp4v" incurred?
Evidence: full name refers to first_name, last name
SQL: SELECT T1.first_name, T1.last_name, SUM(T2.cost) FROM member AS T1 INNER JOIN expense AS T2 ON T1.member_id = T2.link_to_member WHERE T1.member_id = 'rec4BLdZHS2Blfp4v'

Database: debit_card_specializing
Question: What was the product id of the transaction happened at 2012/8/23 21:20:00?
Evidence: '2012/8/23 21:20:00' can refer to date = '2012-08-23' AND T1.time = '21:20:00' in the database
SQL: SELECT T1.ProductID FROM transactions_1k AS T1 INNER JOIN gasstations AS T2 ON T1.GasStationID = T2.GasStationID WHERE T1.Date = '2012-08-23' AND T1.Time = '21:20:00'

Database: toxicology
Question: How many atoms belong to the molecule labeled with carcinogenic compounds?
Evidence: label = '+' mean molecules are carcinogenic;
SQL: SELECT COUNT(T1.atom_id) FROM atom AS T1 INNER JOIN molecule AS T2 ON T1.molecule_id = T2.molecule_id WHERE T2.label = '+'

Database: codebase_community
Question: Write down the related posts titles and link type IDs of the post "What are principal component scores?".
Evidence: Title = 'What are principal component scores?';
SQL: SELECT T3.Title, T2.LinkTypeId FROM posts AS T1 INNER JOIN postLinks AS T2 ON T1.Id = T2.PostId INNER JOIN posts AS T3 ON T2.RelatedPostId = T3.Id WHERE T1.Title = 'What are principal component scores?'

Database: card_games
Question: What is the unique id of the set that has the highest number of cards?
Evidence: the highest number of cards refers to MAX(baseSetSize); unique id refers to id
SQL: SELECT id FROM sets ORDER BY baseSetSize DESC LIMIT 1

Database: european_football_2
Question: Among the players with finishing rate of 1, pick the eldest player and state the player's name.
Evidence: eldest player refers to MAX(SUBTRACT(datetime(CURRENT_TIMESTAMP,'localtime'),datetime(birthday))); finishing rate of 1 refers to finishing = 1
SQL: SELECT DISTINCT t1.player_name FROM Player AS t1 INNER JOIN Player_Attributes AS t2 ON t1.player_api_id = t2.player_api_id WHERE t2.finishing = 1 ORDER BY t1.birthday ASC LIMIT 1

Database: card_games
Question: Which are the cards that have incredibly powerful foils.
Evidence: incredibly poweful foils refers to cardKingdomFoilId is not null AND cardKingdomId is not null
SQL: SELECT id FROM cards WHERE cardKingdomFoilId IS NOT NULL AND cardKingdomId IS NOT NULL

Database: card_games
Question: What type of promotion is of card 'Duress'?
Evidence: card Duress refers to name = 'Duress'; type of promotion refers to promoTypes;
SQL: SELECT promoTypes FROM cards WHERE name = 'Duress' AND promoTypes IS NOT NULL

Database: superhero
Question: Provide the eye colours of the heroes whose skin colours are gold.
Evidence: skin colours are gold refers to colour.colour = 'Gold' WHERE skin_colour_id = colour.id;
SQL: SELECT T2.colour FROM superhero AS T1 INNER JOIN colour AS T2 ON T1.eye_colour_id = T2.id INNER JOIN colour AS T3 ON T1.skin_colour_id = T3.id WHERE T3.colour = 'Gold'

Database: codebase_community
Question: From which post is the tag "bayesian" excerpted from? Please give the body of the post.
Evidence: "bayesian" is the TagName; excerpt from refers to ExcerptPostId
SQL: SELECT T2.Body FROM tags AS T1 INNER JOIN posts AS T2 ON T2.Id = T1.ExcerptPostId WHERE T1.TagName = 'bayesian'

Database: student_club
Question: How much did the Student_Club members spend on food in September Meeting?
Evidence: amount spent refers to spent; spend on food in September Meeting refers to category = 'Food' where event_name = 'September Meeting'
SQL: SELECT T2.spent FROM event AS T1 INNER JOIN budget AS T2 ON T1.event_id = T2.link_to_event WHERE T1.event_name = 'September Meeting' AND T2.category = 'Food' AND SUBSTR(T1.event_date, 6, 2) = '09'

Database: student_club
Question: In the events with more than forty incomes, list the city and country in which the event is happening.
Evidence: more than fifty incomes refers to income > 40
SQL: SELECT DISTINCT T3.city, T3.county FROM income AS T1 INNER JOIN member AS T2 ON T1.link_to_member = T2.member_id INNER JOIN zip_code AS T3 ON T3.zip_code = T2.zip WHERE T1.amount > 40

Database: thrombosis_prediction
Question: List and group all patients by sex for total bilirubin (T-BIL) level not within the normal range.
Evidence: List refers to GROUP_CONCAT(DISTINCT ID); total bilirubin (T-BIL) not within normal range refers to T-BIL > = 2.0
SQL: SELECT T1.ID,T1.SEX FROM Patient AS T1 INNER JOIN Laboratory AS T2 ON T1.ID = T2.ID WHERE T2.`T-BIL` >= 2.0 GROUP BY T1.SEX,T1.ID

Database: student_club
Question: Calculate the total amount spent on speaker gifts and list the name of the event they were spent on.
Evidence: total amount spent = SUM(spent) where category = 'Speaker Gifts'
SQL: SELECT SUM(T1.spent), T2.event_name FROM budget AS T1 INNER JOIN event AS T2 ON T1.link_to_event = T2.event_id WHERE T1.category = 'Speaker Gifts' GROUP BY T2.event_name

Database: codebase_community
Question: What is the average score of Stephen Turner's posts?
Evidence: DisplayName = 'Stephen Turner'; average score refers to AVG(Score);
SQL: SELECT AVG(T2.Score) FROM users AS T1 INNER JOIN posts AS T2 ON T1.Id = T2.OwnerUserId WHERE T1.DisplayName = 'Stephen Turner'

Database: card_games
Question: What are the cards belong to duel deck a? List the ID.
Evidence: duel deck a refers to duelDeck = a;
SQL: SELECT id FROM cards WHERE duelDeck = 'a'

Database: codebase_community
Question: What is the total score of the posts edited by Yevgeny and include the user's website URL.
Evidence: "Yevgeny" is the DisplayName; edited refers to LastEditorUserId
SQL: SELECT SUM(T1.Score), T2.WebsiteUrl FROM posts AS T1 INNER JOIN users AS T2 ON T1.LastEditorUserId = T2.Id WHERE T2.DisplayName = 'Yevgeny' GROUP BY T2.WebsiteUrl

Database: student_club
Question: List the full name of the top five members who spend the most money in the descending order of spending.
Evidence: full name refers to first_name, last_name; spend the most money refers to MAX(expense.cost)
SQL: SELECT T3.first_name, T3.last_name FROM expense AS T1 INNER JOIN budget AS T2 ON T1.link_to_budget = T2.budget_id INNER JOIN member AS T3 ON T1.link_to_member = T3.member_id ORDER BY T2.spent DESC LIMIT 5

Database: toxicology
Question: Determine the bond type that is formed in the chemical compound containing element Carbon.
Evidence: Carbon refers to element = 'c'; double bond refers to bond_type = ' = '; single bond refers to bond_type = '-'; triple bond refers to bond_type = '#';
SQL: SELECT DISTINCT T2.bond_type FROM atom AS T1 INNER JOIN bond AS T2 ON T1.molecule_id = T2.molecule_id WHERE T1.element = 'c'

Database: card_games
Question: How many color cards with no borders have been ranked higher than 12000 on EDHRec?
Evidence: color cards with no borders refers to borderColor = 'borderless'; ranked higher than 12000 on EDHRec refers to edhrecRank > 12000
SQL: SELECT COUNT(id) FROM cards WHERE edhrecRank > 12000 AND borderColor = 'borderless'