Database: card_games
Question: What is the  unconverted mana do all the cards created by Rob Alexander cost in total?
Evidence: unconverted mana refer to manaCost; Rob Alexander refer to artist
SQL: SELECT manaCost FROM cards WHERE artist = 'Rob Alexander'

Database: student_club
Question: What is the total budgeted amount for all category in "October Speaker" event?
Evidence: total budgeted amount refers to SUM(amount) where event_name = 'October Speaker'
SQL: SELECT SUM(T2.amount) FROM event AS T1 INNER JOIN budget AS T2 ON T1.event_id = T2.link_to_event WHERE T1.event_name = 'October Speaker'

Database: financial
Question: How many clients who were born in 1920 stay in east Bohemia?
Evidence: East Bohemia appears in the column A3, which refers to the region.
SQL: SELECT COUNT(T1.client_id) FROM client AS T1 INNER JOIN district AS T2 ON T1.district_id = T2.district_id WHERE STRFTIME('%Y', T1.birth_date) = '1920' AND T2.A3 = 'east Bohemia'

Database: superhero
Question: What are the superpowers of heroes with ID 1?
Evidence: superpowers refers to power_name; heroes with ID 1 refers to hero_id = 1;
SQL: SELECT DISTINCT T2.power_name FROM hero_power AS T1 INNER JOIN superpower AS T2 ON T1.power_id = T2.id WHERE T1.hero_id = 1

Database: codebase_community
Question: What is the title for the post which got the highest score comment?
Evidence: highest score comment refers to Max(comments.Score)
SQL: SELECT Title FROM posts WHERE Id = ( SELECT PostId FROM comments ORDER BY Score DESC LIMIT 1 )

Database: codebase_community
Question: What is the badge name that user 'SilentGhost' obtained?
Evidence: "SilentGhost" is the DisplayName of user;
SQL: SELECT T2.Name FROM users AS T1 INNER JOIN badges AS T2 ON T1.Id = T2.UserId WHERE T1.DisplayName = 'SilentGhost'

Database: card_games
Question: Which card costs more converted mana, "Serra Angel" or "Shrine Keeper"?
Evidence: "Serra Angel" refers to name = 'Serra Angel'; "Shrine Keeper" refers to name = 'Shrine Keeper'; card costs more converted mana when the value of convertedManaCost is greater
SQL: SELECT name FROM cards WHERE name IN ('Serra Angel', 'Shrine Keeper') ORDER BY convertedManaCost DESC LIMIT 1

Database: formula_1
Question: What is the average lap time in milliseconds of all the lap records set on the various circuits in Italy?
Evidence: average = AVG(milliseconds)
SQL: SELECT CAST(SUM(T1.milliseconds) AS REAL) / COUNT(T1.lap) FROM lapTimes AS T1 INNER JOIN races AS T2 on T1.raceId = T2.raceId INNER JOIN circuits AS T3 on T2.circuitId = T3.circuitId WHERE T3.country = 'Italy'

Database: financial
Question: What is the region of the client with the id 3541 from?
Evidence: A3 refers to region
SQL: SELECT T1.A3 FROM district AS T1 INNER JOIN client AS T2 ON T1.district_id = T2.district_id WHERE T2.client_id = 3541

Database: thrombosis_prediction
Question: What is the average age of patients as of year 1999 examined in the laboratory for the October of the year 1991?
Evidence: average age of patients as of year 1999 refers to AVG(SUBTRACT('1999', year(Birthday))); October of 1991 refers to Date BETWEEN '1991-10-01' AND '1991-10-30'
SQL: SELECT AVG('1999'  - STRFTIME('%Y', T2.Birthday)) FROM Laboratory AS T1 INNER JOIN Patient AS T2 ON T1.ID = T2.ID WHERE T1.Date BETWEEN '1991-10-01' AND '1991-10-30'

Database: codebase_community
Question: State all the tags used by Mark Meckes in his posts that doesn't have comments.
Evidence: used by Mark Meckes refers to DisplayName = 'Mark Meckes'; Doen't have comments refers to CommentCount = 0;
SQL: SELECT T3.Tags FROM users AS T1 INNER JOIN postHistory AS T2 ON T1.Id = T2.UserId INNER JOIN posts AS T3 ON T3.Id = T2.PostId WHERE T1.DisplayName = 'Mark Meckes' AND T3.CommentCount = 0

Database: thrombosis_prediction
Question: Was the total cholesterol status for the patient id 2927464 on 1995-9-4 at the normal level?
Evidence: total cholesterol normal level refers to N < 250
SQL: SELECT CASE WHEN `T-CHO` < 250 THEN 'Normal' ELSE 'Abnormal' END FROM Laboratory WHERE ID = 2927464 AND Date = '1995-09-04'

Database: card_games
Question: What was the expansion type for the set which card "Samite Pilgrim" in it?
Evidence: expansion type refers to type; card "Samite Pilgrim" refers to name = 'Samite Pilgrim'
SQL: SELECT type FROM sets WHERE code IN ( SELECT setCode FROM cards WHERE name = 'Samite Pilgrim' )

Database: european_football_2
Question: Among the players with an overall rating between 60 to 65, how many players whose going to be in all of your attack moves instead of defensing?
Evidence: overall_rating > = 60 AND overall_rating < 65; players whose going to be in all of your attack moves instead of defensing refers to defensive_work_rate = 'low';
SQL: SELECT COUNT(id) FROM Player_Attributes WHERE overall_rating BETWEEN 60 AND 65 AND defensive_work_rate = 'low'

Database: toxicology
Question: Enumerate the bond ID of triple bond type molecules and tell me if they are carcinogenic or not.
Evidence: triple bond refers to bond_type = '#'; label = '+' mean molecules are carcinogenic; label = '-' means molecules are non-carcinogenic
SQL: SELECT DISTINCT T1.bond_id, T2.label FROM bond AS T1 INNER JOIN molecule AS T2 ON T1.molecule_id = T2.molecule_id WHERE T1.bond_type = '#'

Database: student_club
Question: What is the total cost of the pizzas for all the events?
Evidence: total cost of the pizzas refers to SUM(cost) where expense_description = 'Pizza'
SQL: SELECT SUM(cost) FROM expense WHERE expense_description = 'Pizza'

Database: european_football_2
Question: What is the passing class of CLB team?
Evidence: passing class refers to buildUpPlayPassingClass; CLB refers to team_short_name = 'CLB';
SQL: SELECT DISTINCT t2.buildUpPlayPassingClass FROM Team AS t1 INNER JOIN Team_Attributes AS t2 ON t1.team_api_id = t2.team_api_id WHERE t1.team_short_name = 'CLB'

Database: financial
Question: Among the accounts who have loan validity more than 12 months, list out the accounts that have the highest approved amount and have account opening date in 1993.
Evidence: Loan validity more than 12 months refers to duration > 12
SQL: SELECT T1.account_id FROM loan AS T1 INNER JOIN account AS T2 ON T1.account_id = T2.account_id WHERE STRFTIME('%Y', T2.date) = '1993' AND T1.duration > 12 ORDER BY T1.amount DESC LIMIT 1

Database: debit_card_specializing
Question: What segment did the customer have at 2012/8/23 21:20:00?
Evidence: '2012/8/23' can be represented by '2012-08-23'
SQL: SELECT T2.Segment FROM transactions_1k AS T1 INNER JOIN customers AS T2 ON T1.CustomerID = T2.CustomerID WHERE T1.date = '2012-08-23' AND T1.time = '21:20:00'

Database: thrombosis_prediction
Question: Provide list of patients and their diagnosis with triglyceride (TG) index greater than 100 of the normal range?
Evidence: triglyceride (TG) index greater than 100 of the normal range refers to TG > 300;
SQL: SELECT T1.ID, T1.Diagnosis FROM Patient AS T1 INNER JOIN Laboratory AS T2 ON T1.ID = T2.ID WHERE T2.TG > 300

Database: formula_1
Question: For the constructor which got the highest point in the race No. 9 , what is its introduction website?
Evidence: race number refers to raceId; constructor which got the highest point refers to MAX(constructorResults.points); introduction website of the constructor refers to url;
SQL: SELECT T2.url FROM constructorResults AS T1 INNER JOIN constructors AS T2 ON T2.constructorId = T1.constructorId WHERE T1.raceId = 9 ORDER BY T1.points DESC LIMIT 1

Database: formula_1
Question: Where can I find the information about the races held on Sepang International Circuit?
Evidence: information about races refers to url;
SQL: SELECT DISTINCT T1.url FROM circuits AS T1 INNER JOIN races AS T2 ON T2.circuitID = T1.circuitId WHERE T1.name = 'Sepang International Circuit'