Database: codebase_community
Question: Please list the names of the badges obtained by csgillespie.
Evidence: "csgillespie" is the DisplayName of user
SQL: SELECT T1.`Name` FROM badges AS T1 INNER JOIN users AS T2 ON T1.UserId = T2.Id WHERE T2.DisplayName = 'csgillespie'

Database: formula_1
Question: What is the average lap time for Lewis Hamilton in the 2009 Malaysian Grand Prix?
Evidence: average lap time = AVG(milliseconds); 'Lewis Hamilton' refers to the full name of the driver; Full name of the driver refers to drivers.forename and drivers.surname; 'Malaysian Grand Prix' refers to races.name = 'Malaysian Grand Prix'
SQL: SELECT AVG(T2.milliseconds) FROM races AS T1 INNER JOIN lapTimes AS T2 ON T2.raceId = T1.raceId INNER JOIN drivers AS T3 ON T3.driverId = T2.driverId WHERE T3.forename = 'Lewis' AND T3.surname = 'Hamilton' AND T1.year = 2009 AND T1.name = 'Malaysian Grand Prix'

Database: financial
Question: How much, in total, did client number 617 pay for all of the transactions in 1998?
SQL: SELECT SUM(T3.amount) FROM client AS T1 INNER JOIN disp AS T4 ON T1.client_id = T4.client_id INNER JOIN account AS T2 ON T4.account_id = T2.account_id INNER JOIN trans AS T3 ON T2.account_id = T3.account_id WHERE STRFTIME('%Y', T3.date)= '1998' AND T1.client_id = 617

Database: codebase_community
Question: Which user made a post titled 'Understanding what Dassault iSight is doing?' and how much is the reputation of the user?
Evidence: "Understanding what Dassault iSight is doing?" is the Title of post; user refers to DisplayName;
SQL: SELECT T1.DisplayName, T1.Reputation FROM users AS T1 INNER JOIN posts AS T2 ON T1.Id = T2.OwnerUserId WHERE T2.Title = 'Understanding what Dassault iSight is doing?'

Database: toxicology
Question: What is the most common bond type?
Evidence: most common bond type refers MAX(COUNT(bond_type))
SQL: SELECT T.bond_type FROM ( SELECT bond_type, COUNT(bond_id) FROM bond GROUP BY bond_type ORDER BY COUNT(bond_id) DESC LIMIT 1 ) AS T

Database: formula_1
Question: How many circuits are there in Adelaide, Australia?
Evidence: Australia is the country; Melbourne is the location of circuit;
SQL: SELECT COUNT(circuitId) FROM circuits WHERE location = 'Adelaide' AND country = 'Australia'

Database: formula_1
Question: Please list the constructor names with 0 points at race 291.
Evidence: race at 291 refers to raceID = 291;
SQL: SELECT T2.name FROM constructorStandings AS T1 INNER JOIN constructors AS T2 on T1.constructorId = T2.constructorId WHERE T1.points = 0 AND T1.raceId = 291

Database: toxicology
Question: How many of the molecules are not carcinogenic?
Evidence: label = '-' means molecules are non-carcinogenic
SQL: SELECT COUNT(T.molecule_id) FROM molecule AS T WHERE T.label = '-'

Database: codebase_community
Question: What are the display names and ages of user who got the highest in views?
Evidence: the highest in views refers to MAX(Views);
SQL: SELECT DisplayName, Age FROM users WHERE Views = ( SELECT MAX(Views) FROM users )

Database: card_games
Question: How many cards did Volkan BaÇµa illustrated whose foreign language is in French?
Evidence: Volkan BaÇµa refers to artist = 'Volkan Baǵa'; foreign language is in French refers to language = 'French'
SQL: SELECT COUNT(T3.id) FROM ( SELECT T1.id FROM cards AS T1 INNER JOIN foreign_data AS T2 ON T2.uuid = T1.uuid WHERE T1.artist = 'Volkan Baǵa' AND T2.language = 'French' GROUP BY T1.id ) AS T3

Database: card_games
Question: List all the frame styles and cards Allen Williams worked on and find any banned cards if there are any.
Evidence: frame styles refers to frameVersion; cards Allen Williams worked on refers to artist = 'Allen Williams'; banned cards refers to status = 'Banned'
SQL: SELECT DISTINCT T1.frameVersion, T1.name , IIF(T2.status = 'Banned', T1.name, 'NO') FROM cards AS T1 INNER JOIN legalities AS T2 ON T1.uuid = T2.uuid WHERE T1.artist = 'Allen Williams'

Database: toxicology
Question: Name the elements that comprise the atoms of bond TR001_2_4.
Evidence: element = 'cl' means Chlorine; element = 'c' means Carbon; element = 'h' means Hydrogen; element = 'o' means Oxygen, element = 's' means Sulfur; element = 'n' means Nitrogen, element = 'p' means Phosphorus, element = 'na' means Sodium, element = 'br' means Bromine, element = 'f' means Fluorine; element = 'i' means Iodine; element = 'sn' means Tin; element = 'pb' means Lead; element = 'te' means Tellurium; element = 'ca' means Calcium
SQL: SELECT DISTINCT T1.element FROM atom AS T1 INNER JOIN connected AS T2 ON T1.atom_id = T2.atom_id WHERE T2.bond_id = 'TR001_2_4'

Database: student_club
Question: Please list the phone numbers of the members who majored in business at the College of Agriculture and Applied Sciences.
Evidence: 'College of Agriculture and Applied Sciences' is the college; majored in business refers to major_name = 'Business'; phone numbers refers to phone
SQL: SELECT T1.phone FROM member AS T1 INNER JOIN major AS T2 ON T2.major_id = T1.link_to_major WHERE T2.major_name = 'Business' AND T2.college = 'College of Agriculture and Applied Sciences'

Database: card_games
Question: Among the sets in the block "Ice Age", how many of them have an Italian translation?
Evidence: sets in the block "Ice Age" refers to block = 'Ice Age'; Italian translation refers to language = 'Italian' and translation is not null
SQL: SELECT COUNT(DISTINCT T1.id) FROM sets AS T1 INNER JOIN set_translations AS T2 ON T2.setCode = T1.code WHERE T1.block = 'Ice Age' AND T2.language = 'Italian' AND T2.translation IS NOT NULL

Database: codebase_community
Question: How many negative comments did Neil McGuigan get in his posts?
Evidence: Negative comment refers to score < 60; DisplayName = 'Neil McGuigan';
SQL: SELECT COUNT(T3.Id) FROM users AS T1 INNER JOIN posts AS T2 ON T1.Id = T2.OwnerUserId INNER JOIN comments AS T3 ON T2.Id = T3.PostId WHERE T1.DisplayName = 'Neil McGuigan' AND T3.Score < 60

Database: codebase_community
Question: Identify the number of posts that have been viewed over 35000 times but have received no comments from other users.
Evidence: have been viewed over 35000 times refers to ViewCount > 35000; received no comments refers to CommentCount = 0;
SQL: SELECT COUNT(Id) FROM posts WHERE ViewCount > 35000 AND CommentCount = 0

Database: thrombosis_prediction
Question: What was the age of the youngest patient when they initially arrived at the hospital?
Evidence: age refers to SUBTRACT(YEAR(`First Date`),YEAR(Birthday))
SQL: SELECT MIN(STRFTIME('%Y', `First Date`) - STRFTIME('%Y', Birthday)) FROM Patient

Database: formula_1
Question: Find the full name, Wiki Pedia page link, and date of birth of German drivers born between 1971 and 1985. List it in descending order of date of birth.
Evidence: FFull name refers to forname+surname; Nationality refers to German; Date of birth refers to dob; year(dob) BETWEEN '1971' AND '1985'
SQL: SELECT forename, surname, url, dob FROM drivers WHERE nationality = 'German' AND STRFTIME('%Y', dob) BETWEEN '1971' AND '1985' ORDER BY dob DESC

Database: financial
Question: How many owner and disponent dispositions are there from account number 1 to account number 10?
SQL: SELECT SUM(type = 'OWNER') , SUM(type = 'DISPONENT') FROM disp WHERE account_id BETWEEN 1 AND 10

Database: superhero
Question: What is the power ID of cryokinesis?
Evidence: power ID refers to superpower.id; cryokinesis refers to power_name = 'cryokinesis';
SQL: SELECT id FROM superpower WHERE power_name = 'Cryokinesis'

Database: card_games
Question: State the alternative languages available for card named Annul numbered 29.
Evidence: annul refers to name = 'annul'; numbered 29 refers to number = '29';
SQL: SELECT T2.language FROM cards AS T1 INNER JOIN foreign_data AS T2 ON T1.uuid = T2.uuid WHERE T1.name = 'Annul' AND T1.number = 29