Database: debit_card_specializing
Question: Which segment had the least consumption?
SQL: SELECT T1.Segment FROM customers AS T1 INNER JOIN yearmonth AS T2 ON T1.CustomerID = T2.CustomerID GROUP BY T1.Segment ORDER BY SUM(T2.Consumption) ASC LIMIT 1

Database: formula_1
Question: From race no. 50 to 100, how many finishers have been disqualified?
Evidence: disqualified refers to statusID = 2, finisher refers to time! = null; race no. refers to raceId; raceId > 50 and raceId < 100;
SQL: SELECT SUM(IIF(time IS NOT NULL, 1, 0)) FROM results WHERE statusId = 2 AND raceID < 100 AND raceId > 50

Database: european_football_2
Question: In Scotland Premier League, which away team won the most during the 2010 season?
Evidence: Final result should return the Team.team_long_name; Scotland Premier League refers to League.name = 'Scotland Premier League'; away team refers to away_team_api_id; away team that won the most refers to MAX(SUBTRACT(away_team_goal, home_team_goal) > 0); 2010 season refers to season = '2009/2010'; won the most refers to MAX(COUNT(*));
SQL: SELECT teamInfo.team_long_name FROM League AS leagueData INNER JOIN Match AS matchData ON leagueData.id = matchData.league_id INNER JOIN Team AS teamInfo ON matchData.away_team_api_id = teamInfo.team_api_id WHERE leagueData.name = 'Scotland Premier League' AND matchData.season = '2009/2010' AND matchData.away_team_goal - matchData.home_team_goal > 0 GROUP BY matchData.away_team_api_id ORDER BY COUNT(*) DESC LIMIT 1

Database: european_football_2
Question: List down the name of players who are 35 years old and above.
Evidence: 35 years old and above refers to datetime(CURRENT_TIMESTAMP,'localtime') - datetime(birthday) > 34
SQL: SELECT player_name FROM Player WHERE CAST((JULIANDAY('now') - JULIANDAY(birthday)) AS REAL) / 365 >= 35

Database: codebase_community
Question: Give the number of "Revival" badges.
Evidence: number refers to Id; 'Revival' is the Name of badge
SQL: SELECT COUNT(Id) FROM badges WHERE Name = 'Revival'

Database: card_games
Question: How many translations of the name of the set "Tenth Edition"?
Evidence: translations of the name refers to translation; translation is not NULL; set "Salvat 2011" refers to name = 'Tenth Edition'
SQL: SELECT COUNT(DISTINCT T2.translation) FROM sets AS T1 INNER JOIN set_translations AS T2 ON T2.setCode = T1.code WHERE T1.name = 'Tenth Edition' AND T2.translation IS NOT NULL

Database: toxicology
Question: Is molecule TR000 is carcinogenic or not?
Evidence: label = '+' mean molecules are carcinogenic; label = '-' means molecules are non-carcinogenic
SQL: SELECT label FROM molecule AS T WHERE T.molecule_id = 'TR000'

Database: financial
Question: How many male customers who are living in North Bohemia have average salary greater than 8000?
Evidence: Male means that gender = 'M'; A3 refers to region; A11 pertains to average salary.
SQL: SELECT COUNT(T1.client_id) FROM client AS T1 INNER JOIN district AS T2 ON T1.district_id = T2.district_id WHERE T1.gender = 'M' AND T2.A3 = 'north Bohemia' AND T2.A11 > 8000

Database: formula_1
Question: For the Bahrain Grand Prix in 2007, how many drivers not finished the game?
Evidence: Bahrain Grand Prix refers to races.name = 'Bahrain Grand Prix'; drivers who finished the race refers to time is not empty (i.e. time IS NOT NULL);
SQL: SELECT COUNT(T3.driverId) FROM races AS T1 INNER JOIN results AS T2 ON T2.raceId = T1.raceId INNER JOIN drivers AS T3 ON T3.driverId = T2.driverId WHERE T1.year = 2007 AND T1.name = 'Bahrain Grand Prix' AND T2.time IS NULL

Database: european_football_2
Question: What is the preferred foot when attacking of the player with the lowest potential?
Evidence: preferred foot when attacking refers to preferred_foot; lowest potential refers to MIN(potential);
SQL: SELECT preferred_foot FROM Player_Attributes WHERE potential IS NOT NULL ORDER BY potential ASC LIMIT 1

Database: student_club
Question: List all of the College of Humanities and Social Sciences' departments.
SQL: SELECT department FROM major WHERE college = 'College of Humanities and Social Sciences'

Database: superhero
Question: List the attribute value of the superhero named Aquababy.
SQL: SELECT T2.attribute_value FROM superhero AS T1 INNER JOIN hero_attribute AS T2 ON T1.id = T2.hero_id WHERE T1.superhero_name = 'Aquababy'

Database: superhero
Question: Indicate the attribute value of superhero Abomination.
Evidence: Abomination refers to superhero_name = 'Abomination';
SQL: SELECT T2.attribute_value FROM superhero AS T1 INNER JOIN hero_attribute AS T2 ON T1.id = T2.hero_id WHERE T1.superhero_name = 'Abomination'

Database: codebase_community
Question: Give the only one comment text of the post with parent id 107829.
Evidence: one comment refers to CommentCount = '1'
SQL: SELECT T2.Text FROM posts AS T1 INNER JOIN comments AS T2 ON T1.Id = T2.PostId WHERE T1.ParentId = 107829 AND T1.CommentCount = 1

Database: california_schools
Question: What is the eligible free or reduced price meal rate for the top 5 schools in grades 1-12 with the highest free or reduced price meal count of the schools with the ownership code 66?
Evidence: grades 1-12 means K-12; Eligible free or reduced price meal rate for K-12 = `FRPM Count (K-12)` / `Enrollment (K-12)`
SQL: SELECT CAST(T1.`FRPM Count (K-12)` AS REAL) / T1.`Enrollment (K-12)` FROM frpm AS T1 INNER JOIN schools AS T2 ON T1.CDSCode = T2.CDSCode WHERE T2.SOC = 66 ORDER BY T1.`FRPM Count (K-12)` DESC LIMIT 5

Database: card_games
Question: What is the status of card "Cloudchaser Eagle"?
Evidence: Cloudchaser Eagle is the name of card;
SQL: SELECT DISTINCT T2.status FROM cards AS T1 INNER JOIN legalities AS T2 ON T1.uuid = T2.uuid WHERE T1.name = 'Cloudchaser Eagle'

Database: codebase_community
Question: What is the title of the post with the oldest post link?
Evidence: the oldest post link refers to MIN(CreaionDate);
SQL: SELECT T1.Title FROM posts AS T1 INNER JOIN postLinks AS T2 ON T2.PostId = T1.Id ORDER BY T1.CreaionDate LIMIT 1

Database: card_games
Question: Which foreign language used by "A Pedra Fellwar"?
Evidence: "A Pedra Fellwar" refers to name = 'A Pedra Fellwar'
SQL: SELECT DISTINCT language FROM foreign_data WHERE name = 'A Pedra Fellwar'

Database: codebase_community
Question: Which post by slashnick has the most answers count? State the post ID.
Evidence: most answers count refers to MAX(AnswerCount); post by slashnick refers to DisplayName = 'slashnick';
SQL: SELECT T2.PostId FROM users AS T1 INNER JOIN postHistory AS T2 ON T1.Id = T2.UserId INNER JOIN posts AS T3 ON T2.PostId = T3.Id WHERE T1.DisplayName = 'slashnick' ORDER BY T3.AnswerCount DESC LIMIT 1

Database: thrombosis_prediction
Question: How many patients with an Ig G higher than normal?
Evidence: Ig G higher than normal refers to IGG >= 2000; Should consider DISTINCT in the final result;
SQL: SELECT COUNT(DISTINCT T1.ID) FROM Patient AS T1 INNER JOIN Laboratory AS T2 ON T1.ID = T2.ID INNER JOIN Examination AS T3 ON T3.ID = T2.ID WHERE T2.IGG >= 2000

Database: student_club
Question: Provide the full name and email address of the Student_Club's Secretary.
Evidence: full name refers to first_name, last_name; 'Secretary' is a position of Student Club
SQL: SELECT first_name, last_name, email FROM member WHERE position = 'Secretary'

Database: codebase_community
Question: How many posts were created on 21st July, 2010?
Evidence: created on 21st July, 2010 refers to CreationDate BETWEEN '2010-07-21 00:00:00' and '2012-07-21 23:59:59';
SQL: SELECT COUNT(id) FROM postHistory WHERE date(CreationDate) = '2010-07-21'