Database: european_football_2
Question: What is the difference between players 6 and 23's jumping scores?
Evidence: difference between players 6 and 23's jumping scores refers to SUBTRACT(jumping AND id = 6,jumping AND id = 23)
SQL: SELECT SUM(CASE WHEN t1.id = 6 THEN t1.jumping ELSE 0 END) - SUM(CASE WHEN t1.id = 23 THEN t1.jumping ELSE 0 END) FROM Player_Attributes AS t1

Database: thrombosis_prediction
Question: Was the patient with the number 57266's uric acid within a normal range?
Evidence: uric acid within a normal range refers to UA > 8.0 and SEX = 'M'OR UA > 6.5 and SEX = 'F'
SQL: SELECT CASE WHEN (T1.SEX = 'F' AND T2.UA > 6.5) OR (T1.SEX = 'M' AND T2.UA > 8.0) THEN true ELSE false END FROM Patient AS T1 INNER JOIN Laboratory AS T2 ON T1.ID = T2.ID WHERE T1.ID = 57266

Database: european_football_2
Question: Among the players whose preferred foot was the left foot when attacking, how many of them would remain in his position when the team attacked?
Evidence: preferred foot when attacking was the left refers to preferred_foot = 'left'; players who would remain in his position when the team attacked refers to attacking_work_rate = 'low';
SQL: SELECT COUNT(player_api_id) FROM Player_Attributes WHERE preferred_foot = 'left' AND attacking_work_rate = 'low'

Database: thrombosis_prediction
Question: How many underage patients were examined during the course of the three-year period from 1990 to 1993?
Evidence: underage patients refers to year(Birthday) < 18; three-year period from 1990 to 1993 refers to year(`Examination Date`) between '1990' and '1993'
SQL: SELECT COUNT(T1.ID) FROM Patient AS T1 INNER JOIN Examination AS T2 ON T1.ID = T2.ID WHERE STRFTIME('%Y', T2.`Examination Date`) BETWEEN '1990' AND '1993' AND STRFTIME('%Y', T2.`Examination Date`) - STRFTIME('%Y', T1.Birthday) < 18

Database: thrombosis_prediction
Question: Excluding all P only ANA Pattern patients, how many of the remainder are women born between 1980 and 1989?
Evidence: Excluding all P only ANA Pattern refers to `ANA Pattern`! = 'P'; women refers to SEX = 'F'; born between 1980 and 1989 refers to BIRTHDAY
SQL: SELECT COUNT(DISTINCT T1.ID) FROM Patient AS T1 INNER JOIN Examination AS T2 ON T1.ID = T2.ID WHERE T2.`ANA Pattern` != 'P' AND STRFTIME('%Y', T1.Birthday) BETWEEN '1980' AND '1989' AND T1.SEX = 'F'

Database: formula_1
Question: List the reference name of the drivers who passed the second qualifying lap during race no. 23. Indicate their nationality and birthday.
Evidence: passed the second qualifying lap refers to q2 is not null; birthday refers to dob; reference name of drivers refers to driverRef; race no. refers to raceId;
SQL: SELECT T2.driverRef, T2.nationality, T2.dob FROM qualifying AS T1 INNER JOIN drivers AS T2 on T1.driverId = T2.driverId WHERE T1.raceId = 23 AND T1.q2 IS NOT NULL

Database: debit_card_specializing
Question: How many customers in KAM had a consumption of less than 30,000 for the year 2012?
Evidence: Year 2012 can be presented as Between 201201 And 201212, which means between January and December in 2012
SQL: SELECT COUNT(*) FROM ( SELECT T2.CustomerID FROM customers AS T1 INNER JOIN yearmonth AS T2 ON T1.CustomerID = T2.CustomerID WHERE T1.Segment = 'KAM' AND SUBSTRING(T2.Date, 1, 4) = '2012' GROUP BY T2.CustomerID HAVING SUM(T2.Consumption) < 30000 ) AS t1

Database: student_club
Question: How many members have education major in the College of Education & Human Services?
Evidence: 'education' is the major name; 'Member' is a position of club;
SQL: SELECT COUNT(T1.member_id) FROM member AS T1 INNER JOIN major AS T2 ON T2.major_id = T1.link_to_major WHERE T1.position = 'Member' AND T2.major_name LIKE '%Education%' AND T2.college = 'College of Education & Human Services'

Database: codebase_community
Question: How many votes were made in 2010?
Evidence: YEAR(CreationDate) = 2010;
SQL: SELECT COUNT(id) FROM votes WHERE STRFTIME('%Y', CreationDate) = '2010'

Database: student_club
Question: Among the members, how many of them have an extra large t-shirt size?
Evidence: among the members refers to position = 'Member'; extra large t-shirt size refers to t_shirt_size = 'X-Large'
SQL: SELECT COUNT(member_id) FROM member WHERE position = 'Member' AND t_shirt_size = 'X-Large'

Database: student_club
Question: How many meeting events were held in 2020?
Evidence: meeting events refers to type = 'Meeting'; held in 2020 refers to YEAR(event_date) = 2020
SQL: SELECT COUNT(event_id) FROM event WHERE type = 'Meeting' AND SUBSTR(event_date, 1, 4) = '2020'

Database: european_football_2
Question: When was the first time did Kevin Constant have his highest crossing score? Give the date.
Evidence: Kevin Constant refers to player_name = 'Kevin Constant'; highest crossing score refers to MAX(crossing)
SQL: SELECT `date` FROM ( SELECT t2.crossing, t2.`date` FROM Player AS t1 INNER JOIN Player_Attributes AS t2 ON t1.player_fifa_api_id = t2.player_fifa_api_id WHERE t1.player_name = 'Kevin Constant' ORDER BY t2.crossing DESC) ORDER BY date DESC LIMIT 1

Database: superhero
Question: List the hero ID of superheroes have intellegence as their power.
Evidence: hero ID refers to superhero.id; have intelligence as their power refers to power_name = 'Intelligence';
SQL: SELECT T1.hero_id FROM hero_power AS T1 INNER JOIN superpower AS T2 ON T1.power_id = T2.id WHERE T2.power_name = 'Intelligence'

Database: debit_card_specializing
Question: For all the people who paid more than 29.00 per unit of product id No.5. Give their consumption status in the August of 2012.
Evidence: August of 2012 refers to the Date value = '201208' ; Price per unit of product = Price / Amount;
SQL: SELECT T2.Consumption FROM transactions_1k AS T1 INNER JOIN yearmonth AS T2 ON T1.CustomerID = T2.CustomerID WHERE T1.Price / T1.Amount > 29.00 AND T1.ProductID = 5 AND T2.Date = '201208'

Database: codebase_community
Question: Provide the users' display names and available website URLs of the post with favorite count of more than 150.
Evidence: favorite count of more than 150 refers to FavoriteCount > 150;
SQL: SELECT T1.DisplayName, T1.WebsiteUrl FROM users AS T1 INNER JOIN posts AS T2 ON T1.Id = T2.OwnerUserId WHERE T2.FavoriteCount > 150

Database: card_games
Question: Lists the set code of all cards translated into Spanish.
Evidence: Spanish refer to language; set code refers to setCode
SQL: SELECT setCode FROM set_translations WHERE language = 'Spanish'

Database: financial
Question: Who are the female account holders who own credit cards and also have loans?
Evidence: Female refers to gender = 'F'
SQL: SELECT T1.client_id FROM client AS T1 INNER JOIN disp AS T2 ON T1.client_id = T2.client_id INNER JOIN account AS T5 ON T2.account_id = T5.account_id INNER JOIN loan AS T3 ON T5.account_id = T3.account_id INNER JOIN card AS T4 ON T2.disp_id = T4.disp_id WHERE T1.gender = 'F'

Database: european_football_2
Question: What are the short name of team who played safe while creating chance of passing?
Evidence: played safe while creating chance of passing refers to chanceCreationPassingClass = 'Safe'; short name of team refers to team_short_name
SQL: SELECT DISTINCT t1.team_short_name FROM Team AS t1 INNER JOIN Team_Attributes AS t2 ON t1.team_api_id = t2.team_api_id WHERE t2.chanceCreationPassingClass = 'Safe'

Database: california_schools
Question: What is the monthly average number of schools that opened in Alameda County under the jurisdiction of the Elementary School District in 1980?
Evidence: Elementary School District refers to DOC = 52; Monthly average number of schools that opened in 1980 = count(schools that opened in 1980) / 12
SQL: SELECT CAST(COUNT(School) AS REAL) / 12 FROM schools WHERE DOC = 52 AND County = 'Alameda' AND strftime('%Y', OpenDate) = '1980'