Database: california_schools
Question: What is the unabbreviated mailing street address of the school with the highest FRPM count for K-12 students?
SQL: SELECT T2.MailStreet FROM frpm AS T1 INNER JOIN schools AS T2 ON T1.CDSCode = T2.CDSCode ORDER BY T1.`FRPM Count (K-12)` DESC LIMIT 1

Database: thrombosis_prediction
Question: How many patients with a normal anti-SSA came to the hospital before 2000?
Evidence: normal anti-SSA refers to SSA IN('-','+-'); came to the hospital before 2000 refers to YEAR(`First Date`) < 2000; Should compute the number of distinct ones
SQL: SELECT COUNT(DISTINCT T1.ID) FROM Patient AS T1 INNER JOIN Laboratory AS T2 ON T1.ID = T2.ID WHERE T2.SSA IN ('negative', '0') AND STRFTIME('%Y', T2.Date) < '2000'

Database: thrombosis_prediction
Question: Please list the diagnosis of the patients whose total protein is lower than normal.
Evidence: total protein is lower than normal refers to TP < 6.0;
SQL: SELECT T1.Diagnosis FROM Patient AS T1 INNER JOIN Laboratory AS T2 ON T1.ID = T2.ID WHERE T2.TP < 6.0

Database: formula_1
Question: What was the fastest lap speed among all drivers in the 2009 Spanish Grand Prix?
Evidence: the fastest lap speed among all refers to max(fastestLapSpeed); Spanish Grand Prix refers to races.name = 'Spanish Grand Prix';
SQL: SELECT T2.fastestLapSpeed FROM races AS T1 INNER JOIN results AS T2 ON T2.raceId = T1.raceId WHERE T1.name = 'Spanish Grand Prix' AND T1.year = 2009 AND T2.fastestLapSpeed IS NOT NULL ORDER BY T2.fastestLapSpeed DESC LIMIT 1

Database: thrombosis_prediction
Question: The oldest SJS patient's medical laboratory work was completed on what date, and what age was the patient when they initially arrived at the hospital?
Evidence: The larger the birthday value, the younger the person is, and vice versa; 'SJS' refers to diagnosis; (SUBTRACT(year(`First Date`)), year(Birthday)); age of the patients when they initially arrived at the hospital refers to year(Birthday)
SQL: SELECT T1.Date, STRFTIME('%Y', T2.`First Date`) - STRFTIME('%Y', T2.Birthday),T2.Birthday FROM Laboratory AS T1 INNER JOIN Patient AS T2 ON T1.ID = T2.ID WHERE T2.Diagnosis = 'SJS' AND T2.Birthday IS NOT NULL ORDER BY T2.Birthday ASC LIMIT 1

Database: superhero
Question: What are the names of the superheroes with the power of death touch?
Evidence: name of superheroes refers to refers to superhero_name; the power of death touch refers to power_name = 'Death Touch'
SQL: SELECT T1.superhero_name FROM superhero AS T1 INNER JOIN hero_power AS T2 ON T1.id = T2.hero_id INNER JOIN superpower AS T3 ON T2.power_id = T3.id WHERE T3.power_name = 'Death Touch'

Database: superhero
Question: Identify the gender of the superhero who has the ability of Phoenix Force.
Evidence: ability of Phoenix Force refers to power_name = 'Phoenix Force';
SQL: SELECT T4.gender FROM superhero AS T1 INNER JOIN hero_power AS T2 ON T1.id = T2.hero_id INNER JOIN superpower AS T3 ON T2.power_id = T3.id INNER JOIN gender AS T4 ON T1.gender_id = T4.id WHERE T3.power_name = 'Phoenix Force'

Database: card_games
Question: For artifact type of cards that do not have multiple faces on the same card, state its legalities status for vintage play format.
Evidence: Artifact type of cards refers to types = 'Artifact'; card does not have multiple faces on the same card refers to side is NULL'; vintage play format refers to format = 'vintage';
SQL: SELECT DISTINCT T2.status FROM cards AS T1 INNER JOIN legalities AS T2 ON T1.uuid = T2.uuid WHERE T1.type = 'Artifact' AND T2.format = 'vintage' AND T1.side IS NULL

Database: codebase_community
Question: How many negative comments were given by user ID 13?
Evidence: negative comments refer to Score < 60;
SQL: SELECT COUNT(Id) FROM comments WHERE UserId = 13 AND Score < 60

Database: superhero
Question: What are the race and alignment of Cameron Hicks?
Evidence: Cameron Hicks refers to superhero_name = 'Cameron Hicks';
SQL: SELECT T2.race, T3.alignment FROM superhero AS T1 INNER JOIN race AS T2 ON T1.race_id = T2.id INNER JOIN alignment AS T3 ON T1.alignment_id = T3.id WHERE T1.superhero_name = 'Cameron Hicks'

Database: financial
Question: Who are the account holder identification numbers whose who have transactions on the credit card with the amount is less than the average, in 1998?
Evidence: Operation = 'VYBER KARTOU' refers to credit card withdrawal
SQL: SELECT T1.account_id FROM trans AS T1 INNER JOIN account AS T2 ON T1.account_id = T2.account_id WHERE STRFTIME('%Y', T1.date) = '1998' AND T1.operation = 'VYBER KARTOU' AND T1.amount < (SELECT AVG(amount) FROM trans WHERE STRFTIME('%Y', date) = '1998')

Database: european_football_2
Question: Which player has the highest overall rating? Indicate the player's api id.
Evidence: highest overall rating refers to MAX(overall_rating);
SQL: SELECT player_api_id FROM Player_Attributes ORDER BY overall_rating DESC LIMIT 1

Database: european_football_2
Question: What was the chance creation crossing class for "Hull City" on 2010/2/22?
Evidence: "Hull City" refers to team_long_name = 'Hull City'; on 2010/2/22 refers to date = '2010-02-22 00:00:00'
SQL: SELECT t2.chanceCreationCrossingClass FROM Team AS t1 INNER JOIN Team_Attributes AS t2 ON t1.team_api_id = t2.team_api_id WHERE t1.team_long_name = 'Hull City' AND SUBSTR(t2.`date`, 1, 10) = '2010-02-22'

Database: thrombosis_prediction
Question: For the patient who has the highest Ig A within the normal range, what is his or her diagnosis?
Evidence: highest Ig A within the normal range refers to MAX(IGA BETWEEN 80 AND 500);
SQL: SELECT patientData.Diagnosis FROM Patient AS patientData INNER JOIN Laboratory AS labData ON patientData.ID = labData.ID WHERE labData.IGA BETWEEN 80 AND 500 ORDER BY labData.IGA DESC LIMIT 1

Database: card_games
Question: What's the code for the set which was released on 2017/7/14?
Evidence: released on 2017/7/14 refers to releaseDate = '2017-07-14'
SQL: SELECT code FROM sets WHERE releaseDate = '2017-07-14' GROUP BY releaseDate, code

Database: codebase_community
Question: For the post which got 1910 view counts, how many comments does it get?
SQL: SELECT COUNT(T1.Id) FROM posts AS T1 INNER JOIN comments AS T2 ON T1.Id = T2.PostId WHERE T1.ViewCount = 1910

Database: thrombosis_prediction
Question: How many male patients have their glutamic oxaloacetic transaminase in the normal range?
Evidence: male refers to Sex = 'M'; glutamic oxaloacetic transaminase in the normal range refers to GOT < 60;
SQL: SELECT COUNT(T1.ID) FROM Patient AS T1 INNER JOIN Laboratory AS T2 ON T1.ID = T2.ID WHERE T2.GOT < 60 AND T1.SEX = 'M'

Database: codebase_community
Question: Write all the comments left by users who edited the post titled 'Why square the difference instead of taking the absolute value in standard deviation?'
Evidence: "Why square the difference instead of taking the absolute value in standard deviation?" is the Title of post;
SQL: SELECT T2.Comment FROM posts AS T1 INNER JOIN postHistory AS T2 ON T1.Id = T2.PostId WHERE T1.Title = 'Why square the difference instead of taking the absolute value in standard deviation?'

Database: financial
Question: For the client who applied the biggest loan, what was his/her first amount of transaction after opened the account?
SQL: SELECT T3.amount FROM loan AS T1 INNER JOIN account AS T2 ON T1.account_id = T2.account_id INNER JOIN trans AS T3 ON T2.account_id = T3.account_id ORDER BY T1.amount DESC, T3.date ASC LIMIT 1

Database: card_games
Question: Indicates the name of all the languages into which the set whose number of cards is 309 is translated.
Evidence: set refer to setCode; number of cards refers to baseSetSize; baseSetsize = 309


SQL: SELECT T2.language FROM sets AS T1 INNER JOIN set_translations AS T2 ON T1.code = T2.setCode WHERE T1.baseSetSize = 309