Database: codebase_community
Question: Provide the badge names received in 2011 for the user whose location is in the North Pole.
Evidence: received in 2011 refers to year(Date) = 2011;
SQL: SELECT T2.Name FROM users AS T1 INNER JOIN badges AS T2 ON T1.Id = T2.UserId WHERE STRFTIME('%Y', T2.Date) = '2011' AND T1.Location = 'North Pole'

Database: superhero
Question: Which superheroes have a durability attribute value of less than 50?
Evidence: durability of less than 50 refers to attribute_name = 'Durability' AND attribute_value < 50
SQL: SELECT superhero_name FROM superhero AS T1 WHERE EXISTS (SELECT 1 FROM hero_attribute AS T2 INNER JOIN attribute AS T3 ON T2.attribute_id = T3.id WHERE T3.attribute_name = 'Durability' AND T2.attribute_value < 50 AND T1.id = T2.hero_id)

Database: financial
Question: How many accounts were opened in Litomerice in 1996?
Evidence: A2 refers to district name; Litomerice is one of district names.
SQL: SELECT COUNT(T2.account_id) FROM district AS T1 INNER JOIN account AS T2 ON T1.district_id = T2.district_id WHERE STRFTIME('%Y', T2.date) = '1996' AND T1.A2 = 'Litomerice'

Database: codebase_community
Question: Among the badges obtained by csgillespie, how many of them were obtained in the year 2011?
Evidence: "csgillespie" is the DisplayName of user; obtained in 2011 refers to YEAR (Date) = 2011
SQL: SELECT COUNT(T1.Id) FROM badges AS T1 INNER JOIN users AS T2 ON T1.UserId = T2.Id WHERE STRFTIME('%Y', T1.Date) = '2011' AND T2.DisplayName = 'csgillespie'

Database: thrombosis_prediction
Question: Please list the ID of the patient whose RF is normal and who is older than 60.
Evidence: RF is normal refers to RF < 20; older than 60 = SUBTRACT((YEAR(CURDATE()), YEAR(Birthday))) > 60;
SQL: SELECT T1.ID FROM Patient AS T1 INNER JOIN Laboratory AS T2 ON T1.ID = T2.ID WHERE T2.RF < 20 AND STRFTIME('%Y', DATE('now')) - STRFTIME('%Y', T1.Birthday) > 60

Database: california_schools
Question: Under whose administration is the school with the highest number of students scoring 1500 or more on the SAT? Indicate their full names.
Evidence: full name means first name, last name; There are at most 3 administrators for each school; SAT Scores are greater or equal to 1500 refers to NumGE1500
SQL: SELECT T2.AdmFName1, T2.AdmLName1, T2.AdmFName2, T2.AdmLName2, T2.AdmFName3, T2.AdmLName3 FROM satscores AS T1 INNER JOIN schools AS T2 ON T1.cds = T2.CDSCode ORDER BY T1.NumGE1500 DESC LIMIT 1

Database: california_schools
Question: Among the schools with an SAT excellence rate of over 0.3, what is the highest eligible free rate for students aged 5-17?
Evidence: Excellence rate = NumGE1500 / NumTstTakr; Eligible free rates for students aged 5-17 = `Free Meal Count (Ages 5-17)` / `Enrollment (Ages 5-17)`
SQL: SELECT MAX(CAST(T1.`Free Meal Count (Ages 5-17)` AS REAL) / T1.`Enrollment (Ages 5-17)`) FROM frpm AS T1 INNER JOIN satscores AS T2 ON T1.CDSCode = T2.cds WHERE CAST(T2.NumGE1500 AS REAL) / T2.NumTstTakr > 0.3

Database: european_football_2
Question: How many home team goal have been scored by Aaron Lennon?
Evidence: Aaron Lennon refers to player_name = 'Aaron Lennon'
SQL: SELECT SUM(t2.home_team_goal) FROM Player AS t1 INNER JOIN match AS t2 ON t1.player_api_id = t2.away_player_9 WHERE t1.player_name = 'Aaron Lennon'

Database: financial
Question: How many of the account holders in South Bohemia still do not own credit cards?
Evidence: A3 contains the region names; South Bohemia is one of region names.
SQL: SELECT COUNT(T3.account_id) FROM district AS T1 INNER JOIN client AS T2 ON T1.district_id = T2.district_id INNER JOIN disp AS T3 ON T2.client_id = T3.client_id WHERE T1.A3 = 'south Bohemia' AND T3.type != 'OWNER'

Database: formula_1
Question: Please state the reference name of the oldest German driver.
Evidence: oldest refers to MIN(year(dob)); reference names appear in drverRef.
SQL: SELECT driverRef FROM drivers WHERE nationality = 'German' ORDER BY JULIANDAY(dob) ASC LIMIT 1

Database: student_club
Question: Among the budgets for Advertising, list out top three which have the most budgeted amount?
Evidence: MAX(amount) where category = 'Advertisement'
SQL: SELECT budget_id FROM budget WHERE category = 'Advertisement' ORDER BY amount DESC LIMIT 3

Database: formula_1
Question: For the drivers who took part in the race in 1983/7/16, what's their race completion rate?
Evidence: DIVIDE(COUNT(driverid when time has value ), (COUNT(driverid )) as percentage; in 1983/7/16 refers to when date = '1983-07-16'
SQL: SELECT CAST(COUNT(CASE WHEN T2.time IS NOT NULL THEN T2.driverId END) AS REAL) * 100 / COUNT(T2.driverId) FROM races AS T1 INNER JOIN results AS T2 ON T2.raceId = T1.raceId WHERE T1.date = '1983-07-16'

Database: debit_card_specializing
Question: For all the transactions happened during 8:00-9:00 in 2012/8/26, how many happened in CZE?
Evidence: Czech Republic can be represented as the Country value in the gasstations table is 'CZE'; '2012/8/26' can be represented by '2012-08-26'; during 8:00-9:00 can be represented as Time BETWEEN '08:00:00' AND '09:00:00'
SQL: SELECT COUNT(T1.TransactionID) FROM transactions_1k AS T1 INNER JOIN gasstations AS T2 ON T1.GasStationID = T2.GasStationID WHERE T1.Date = '2012-08-26' AND T1.Time BETWEEN '08:00:00' AND '09:00:00' AND T2.Country = 'CZE'

Database: european_football_2
Question: Tell the build Up play passing class for "FC Lorient" on 2010/2/22.
Evidence: "FC Lorient" refers to team_long_name = 'FC Lorient'; on 2010/2/22 refers to date LIKE '2010-02-22%';
SQL: SELECT t2.buildUpPlayPassingClass FROM Team AS t1 INNER JOIN Team_Attributes AS t2 ON t1.team_api_id = t2.team_api_id WHERE t1.team_long_name = 'FC Lorient' AND t2.`date` LIKE '2010-02-22%'

Database: debit_card_specializing
Question: What is the amount spent by customer "38508" at the gas stations? How much had the customer spent in January 2012?
Evidence: January 2012 refers to the Date value = '201201'
SQL: SELECT SUM(T1.Price) , SUM(IIF(T3.Date = '201201', T1.Price, 0)) FROM transactions_1k AS T1 INNER JOIN gasstations AS T2 ON T1.GasStationID = T2.GasStationID INNER JOIN yearmonth AS T3 ON T1.CustomerID = T3.CustomerID WHERE T1.CustomerID = '38508'

Database: thrombosis_prediction
Question: For laboratory examinations take in 1984, list all patients below 50 years old with normal platelet level.
Evidence: laboratory examinations take in 1984 refers to YEAR(Date) = '1984'; below 50 years old = SUBTRACT(year(current_timestamp), year(Birthday)) < 50; normal platelet level refers to PLT between 100 and 400; 
SQL: SELECT DISTINCT T1.ID FROM Patient AS T1 INNER JOIN Laboratory AS T2 ON T1.ID = T2.ID WHERE T2.PLT BETWEEN 100 AND 400 AND STRFTIME('%Y', T2.Date) - STRFTIME('%Y', T1.Birthday) < 50 AND STRFTIME('%Y', T2.Date) = '1984'

Database: student_club
Question: Find the full name of members whose t-shirt size is extra large.
Evidence: full name refers to first_name, last_name; t_shirt_size = 'X-Large'
SQL: SELECT first_name, last_name FROM member WHERE t_shirt_size = 'X-Large'

Database: formula_1
Question: How old is the youngest Japanese driver? What is his name?
Evidence: date of birth refers to drivers.dob; The larger the birthday value, the younger the person is, and vice versa; Japanese refers to nationality = 'Japanese'; age = YEAR(CURRENT_TIMESTAMP) - YEAR(dob);
SQL: SELECT STRFTIME('%Y', CURRENT_TIMESTAMP) - STRFTIME('%Y', dob), forename , surname FROM drivers WHERE nationality = 'Japanese' ORDER BY dob DESC LIMIT 1

Database: formula_1
Question: Who finished second in the San Marino Grand Prix in 2006?
Evidence: finished second refers to position = 2;
SQL: SELECT T3.forename, T3.surname 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 = 2006 AND T1.name = 'San Marino Grand Prix' AND T2.position = 2