Database: european_football_2
Question: What is the average number of goals made by Parma as the away team while playing in Italy?
Evidence: Parma refers to team_long_name = 'Parma'; average number of goals refers to AVG(away_team_goal)
SQL: SELECT CAST(SUM(T1.away_team_goal) AS REAL) / COUNT(T1.id) FROM "Match" AS T1 INNER JOIN TEAM AS T2 ON T1.away_team_api_id = T2.team_api_id INNER JOIN Country AS T3 ON T1.country_id = T3.id WHERE T2.team_long_name = 'Parma' AND T3.name = 'Italy'

Database: financial
Question: Among the account opened, how many female customers who were born before 1950 and stayed in Sokolov?
Evidence: Customers refer to clients; Female refers to gender = 'F'; Names of districts appear in column A2
SQL: SELECT COUNT(T2.client_id) FROM district AS T1 INNER JOIN client AS T2 ON T1.district_id = T2.district_id WHERE T2.gender = 'F' AND STRFTIME('%Y', T2.birth_date) < '1950' AND T1.A2 = 'Sokolov'

Database: european_football_2
Question: Which country is the league Italy Serie A from?
Evidence: Italy Serie A from refers to League.name = 'Italy Serie A';
SQL: SELECT t1.name FROM Country AS t1 INNER JOIN League AS t2 ON t1.id = t2.country_id WHERE t2.name = 'Italy Serie A'

Database: financial
Question: What is the number of committed crimes in 1995 in the district of the account with the id 532?
Evidence: A15 contains information about number of committed crimes in 1995
SQL: SELECT T1.A15 FROM district AS T1 INNER JOIN `account` AS T2 ON T1.district_id = T2.district_id WHERE T2.account_id = 532

Database: formula_1
Question: How many Formula_1 races took place on the circuits in Italy?
SQL: SELECT COUNT(T2.circuitId) FROM circuits AS T1 INNER JOIN races AS T2 ON T2.circuitID = T1.circuitId WHERE T1.country = 'Italy'

Database: codebase_community
Question: Identify the percentage of teenage users.
Evidence: DIVIDE(COUNT(Id where Age BETWEEN 13 and 18), COUNT(Id)) as percentage;
SQL: SELECT CAST(SUM(IIF(Age BETWEEN 13 AND 18, 1, 0)) AS REAL) * 100 / COUNT(Id) FROM users

Database: card_games
Question: Please provide the names of the artists who illustrated the card art in Phyrexian.
Evidence: Phyrexian' is the language; name of artists refers to artist;
SQL: SELECT T1.artist FROM cards AS T1 INNER JOIN foreign_data AS T2 ON T1.uuid = T2.uuid WHERE T2.language = 'Phyrexian'

Database: financial
Question: Please list the accounts whose district is Tabor that are eligible for loans.
Evidence: District refers to column A2; when the account type = 'OWNER', it's eligible for loans
SQL: SELECT T2.account_id FROM district AS T1 INNER JOIN account AS T2 ON T1.district_id = T2.district_id INNER JOIN disp AS T3 ON T2.account_id = T3.account_id WHERE T3.type = 'OWNER' AND T1.A2 = 'Tabor'

Database: california_schools
Question: What is the phone number and extension number for the school that had the 333rd highest average writing score?
SQL: SELECT T2.Phone, T2.Ext FROM satscores AS T1 INNER JOIN schools AS T2 ON T1.cds = T2.CDSCode ORDER BY T1.AvgScrWrite DESC LIMIT 332, 1

Database: student_club
Question: State the category of events were held at MU 215.
Evidence: 'MU 215' is the location of event; 
SQL: SELECT DISTINCT T2.category FROM event AS T1 INNER JOIN budget AS T2 ON T1.event_id = T2.link_to_event WHERE T1.location = 'MU 215'

Database: card_games
Question: How many cards are oversized, reprinted, and printed for promotions?
Evidence: are oversized refers to isOversized = 1; reprinted refers to isReprint = 1; printed for promotions refers to isPromo = 1
SQL: SELECT COUNT(id) FROM cards WHERE isOversized = 1 AND isReprint = 1 AND isPromo = 1

Database: california_schools
Question: Between 1/1/2000 to 12/31/2005, how many directly funded schools opened in the county of Stanislaus?
Evidence: Directly funded schools refers to FundingType = 'Directly Funded'
SQL: SELECT COUNT(School) FROM schools WHERE strftime('%Y', OpenDate) BETWEEN '2000' AND '2005' AND County = 'Stanislaus' AND FundingType = 'Directly funded'

Database: toxicology
Question: Please list top three elements of the toxicology of the molecule TR000 in alphabetical order.
Evidence: TR000 is the molecule id;
SQL: SELECT DISTINCT T.element FROM atom AS T WHERE T.molecule_id = 'TR000' ORDER BY T.element LIMIT 3

Database: card_games
Question: List down the name of artists for cards in Chinese Simplified.
Evidence: Chinese Simplified' is the language;
SQL: SELECT T1.artist FROM cards AS T1 INNER JOIN foreign_data AS T2 ON T1.uuid = T2.uuid WHERE T2.language = 'Chinese Simplified'

Database: financial
Question: What percentage of clients who opened their accounts in the district with an average salary of over 10000 are women?
Evidence: Female refers to gender = 'F'; Woman and female are closed; Average salary can be found in A11
SQL: SELECT CAST(SUM(T2.gender = 'F') AS REAL) * 100 / COUNT(T2.client_id) FROM district AS T1 INNER JOIN client AS T2 ON T1.district_id = T2.district_id WHERE T1.A11 > 10000

Database: formula_1
Question: How many French constructors have a lap number of over 50?
Evidence: lap numbers of over 50 refers to laps > 50;
SQL: SELECT COUNT(DISTINCT T2.constructorId) FROM results AS T1 INNER JOIN constructors AS T2 on T1.constructorId = T2.constructorId WHERE T1.laps > 50 AND T2.nationality = 'French'

Database: thrombosis_prediction
Question: How many female patients born in 1964 were admitted to the hospital? List them by ID.
Evidence: female refers to SEX = 'F'; born in 1964 refers to YEAR(Birthday) = 1964; admitted to the hospital refers to Admission = '+'
SQL: SELECT ID FROM Patient WHERE STRFTIME('%Y', Birthday) = '1964' AND SEX = 'F' AND Admission = '+'

Database: thrombosis_prediction
Question: For patients with abnormal platelet level, state the number of patients with lower than normal range. How is it compare to the number of patients with higher than normal range?
Evidence: abnormal platelet level refers to PLT <= 100 or PLT >= 400; platelet level lower than normal range refers to PLT < 100; calculation = SUBTRACT(SUM(PLT < 100), SUM(PLT > 400)); platelet level higher than normal range refers to PLT > 400;
SQL: SELECT SUM(CASE WHEN T2.PLT <= 100 THEN 1 ELSE 0 END) - SUM(CASE WHEN T2.PLT >= 400 THEN 1 ELSE 0 END) FROM Patient AS T1 INNER JOIN Laboratory AS T2 ON T1.ID = T2.ID

Database: financial
Question: After making a credit card withdrawal, how many account/s with monthly issuance has a negative balance?
Evidence: Negative balance means balance < 0; Operation = 'VYBER KARTOU' stands for credit card withdraw. Frequency = 'POPLATEK MESICNE' stands for monthly issurance
SQL: SELECT COUNT(T1.account_id) FROM trans AS T1 INNER JOIN account AS T2 ON T1.account_id = T2.account_id WHERE T1.balance < 0 AND T1.operation = 'VYBER KARTOU' AND T2.frequency = 'POPLATEK MESICNE'

Database: formula_1
Question: State the name and date of the last round of race in year 1999.
Evidence: the last round refers to max(round);
SQL: SELECT name, date FROM races WHERE year = 1999 ORDER BY round DESC LIMIT 1

Database: codebase_community
Question: Among the tags with tag ID below 15, how many of them have 20 count of posts and below?
Evidence: ID below 15 refers to Id < 15; have 20 count of posts and below refers to Count < = 20;
SQL: SELECT COUNT(id) FROM tags WHERE Count <= 20 AND Id < 15

Database: codebase_community
Question: What is the average number of badges obtained by a user with over 200 views?
Evidence: user with over 200 views refers to Views > 200; average number of badges = Divide (Count(Id), Count(DisplayName))
SQL: SELECT CAST(COUNT(T1.Id) AS REAL) / COUNT(DISTINCT T2.DisplayName) FROM badges AS T1 INNER JOIN users AS T2 ON T1.UserId = T2.Id WHERE T2.Views > 200