Database: california_schools
Question: What is the school type of the school with the highest latitude? Indicate the name of the school as well as the latitude coordinates.
SQL: SELECT T1.`School Type`, T1.`School Name`, T2.Latitude FROM frpm AS T1 INNER JOIN schools AS T2 ON T1.CDSCode = T2.CDSCode ORDER BY T2.Latitude DESC LIMIT 1

Database: codebase_community
Question: How many posts were created by Daniel Vassallo?
Evidence: DisplayName = 'Daniel Vassallo';
SQL: SELECT COUNT(T1.Id) FROM users AS T1 INNER JOIN postHistory AS T2 ON T1.Id = T2.UserId WHERE T1.DisplayName = 'Daniel Vassallo'

Database: card_games
Question: What is the language and expansion type of set number 206?
Evidence: set number 206 refers to id = 206
SQL: SELECT T2.language, T1.type FROM sets AS T1 INNER JOIN set_translations AS T2 ON T1.code = T2.setCode WHERE T2.id = 206

Database: toxicology
Question: What type of label is not on molecules with atoms with tin?
Evidence: tin refers to element ! = 'sn'; label = '+' mean molecules are carcinogenic; label = '-' means molecules are non-carcinogenic
SQL: SELECT DISTINCT T2.label FROM atom AS T1 INNER JOIN molecule AS T2 ON T1.molecule_id = T2.molecule_id WHERE T1.element != 'sn'

Database: codebase_community
Question: What is the sum of score of the post on 2010-07-19?
Evidence: on 2010-07-19 refers to LasActivityDate LIKE '2010-07-19%';
SQL: SELECT SUM(Score) FROM posts WHERE LasActivityDate LIKE '2010-07-19%'

Database: california_schools
Question: Please list the lowest three eligible free rates for students aged 5-17 in continuation schools.
Evidence: Eligible free rates for students aged 5-17 = `Free Meal Count (Ages 5-17)` / `Enrollment (Ages 5-17)`
SQL: SELECT `Free Meal Count (Ages 5-17)` / `Enrollment (Ages 5-17)` FROM frpm WHERE `Educational Option Type` = 'Continuation School' AND `Free Meal Count (Ages 5-17)` / `Enrollment (Ages 5-17)` IS NOT NULL ORDER BY `Free Meal Count (Ages 5-17)` / `Enrollment (Ages 5-17)` ASC LIMIT 3

Database: codebase_community
Question: What is the reputation and view count of the user, who is known by his or her display name 'Jarrod Dixon'?
SQL: SELECT Reputation, Views FROM users WHERE DisplayName = 'Jarrod Dixon'

Database: toxicology
Question: How many of the single bond type molecules are non-carcinogenic?
Evidence: label = '-' means molecules are non-carcinogenic; single bond refers to bond_type = '-';
SQL: SELECT COUNT(DISTINCT T2.molecule_id) FROM bond AS T1 INNER JOIN molecule AS T2 ON T1.molecule_id = T2.molecule_id WHERE T2.label = '-' AND T1.bond_type = '-'

Database: superhero
Question: Which superheroes have blue eyes with brown hair?
Evidence: which superheroes refers to superhero_name; blue eyes refers to color = 'Blue' and color.id = eye_colour_id; brown hair refers to color = 'Brown' and color.id = hair_colour_id;
SQL: SELECT T1.superhero_name FROM superhero AS T1 INNER JOIN colour AS T2 ON T1.eye_colour_id = T2.id INNER JOIN colour AS T3 ON T1.hair_colour_id = T3.id WHERE T2.colour = 'Blue' AND T3.colour = 'Brown'

Database: student_club
Question: Which student has the hometown of Lincolnton, North Carolina with the zip code of 28092? List their full name and position.
Evidence: full name refers to first_name, last_name, hometown of Lincolnton, North Carolina refers to city = 'Lincolnton' AND state = 'North Carolina'
SQL: SELECT T1.first_name, T1.last_name, T1.position FROM member AS T1 INNER JOIN zip_code AS T2 ON T2.zip_code = T1.zip WHERE T2.city = 'Lincolnton' AND T2.state = 'North Carolina' AND T2.zip_code = 28092

Database: california_schools
Question: In which mailing street address can you find the school that has the lowest average score in reading? Also give the school's name.
SQL: SELECT T2.MailStreet, T2.School FROM satscores AS T1 INNER JOIN schools AS T2 ON T1.cds = T2.CDSCode WHERE T1.AvgScrRead IS NOT NULL ORDER BY T1.AvgScrRead ASC LIMIT 1

Database: california_schools
Question: What is the total amount of Community College District closure in 1989 in the city of San Francisco?
SQL: SELECT COUNT(School) FROM schools WHERE strftime('%Y', ClosedDate) = '1989' AND City = 'San Francisco' AND DOCType = 'Community College District'

Database: codebase_community
Question: Please list the display names of all the users who owns a post that is well-finished.
Evidence: the post that is well-finished refers to ClosedDate IS NOT Null
SQL: SELECT T2.DisplayName FROM posts AS T1 INNER JOIN users AS T2 ON T1.OwnerUserId = T2.Id WHERE T1.ClosedDate IS NOT NULL

Database: thrombosis_prediction
Question: What is the ratio of male to female patients among all those with abnormal uric acid counts?
Evidence: male refers to SEX = 'M'; female refers to SEX = 'F'; abnormal uric acid refers to UA < = '8.0' where SEX = 'M', UA < = '6.5' where SEX = 'F'; calculation = DIVIDE(SUM(UA <= '8.0' and SEX = 'M'), SUM(UA <= '6.5 and SEX = 'F'))
SQL: SELECT CAST(SUM(CASE WHEN T2.UA <= 8.0 AND T1.SEX = 'M' THEN 1 ELSE 0 END) AS REAL) / SUM(CASE WHEN T2.UA <= 6.5 AND T1.SEX = 'F' THEN 1 ELSE 0 END) FROM Patient AS T1 INNER JOIN Laboratory AS T2 ON T1.ID = T2.ID

Database: financial
Question: How many female customers have a junior credit card?
Evidence: Female refers to gender = 'F'
SQL: SELECT COUNT(T1.client_id) FROM client AS T1 INNER JOIN disp AS T2 ON T1.client_id = T2.client_id INNER JOIN card AS T3 ON T2.disp_id = T3.disp_id WHERE T1.gender = 'F' AND T3.type = 'junior'

Database: financial
Question: What was the difference in the number of crimes committed in East and North Bohemia in 1996?
Evidence: Difference in no. of committed crimes between 2 regions = Total no. of committed crimes in 1996 in north Bohemia - Total no. of committed crimes in 1996 in e ast Bohemia. A3 refers to region. Data about no. of committed crimes 1996 appears in A16
SQL: SELECT SUM(IIF(A3 = 'east Bohemia', A16, 0)) - SUM(IIF(A3 = 'north Bohemia', A16, 0)) FROM district

Database: card_games
Question: List the edhrecRank for cards with frame version 2015.
SQL: SELECT edhrecRank FROM cards WHERE frameVersion = 2015

Database: thrombosis_prediction
Question: How many female patients who came at the hospital in 1997 was immediately followed at the outpatient clinic?
Evidence: female refers to sex = 'F'; came at the hospital in 1997 refers to year(Description) = '1997'; immediately followed at the outpatient clinic refers to Admission = '-'
SQL: SELECT COUNT(*) FROM Patient WHERE STRFTIME('%Y', Description) = '1997' AND SEX = 'F' AND Admission = '-'

Database: formula_1
Question: In which location does the Hungaroring circuit located? Also, find the country and coordinates of this circuit?
Evidence: coordinates expressed in latitude and longitude refers to (lat, lng)
SQL: SELECT country, lat, lng FROM circuits WHERE name = 'Hungaroring'

Database: card_games
Question: Show the Simplified Chinese translation of the name of the set "Mirrodin"?
Evidence: Simplified Chinese translation refers to language = 'Chinese Simplified'; name of the set "Mirrodin" refers to name = 'Mirrodin'
SQL: SELECT translation FROM set_translations WHERE setCode IN ( SELECT code FROM sets WHERE name = 'Mirrodin' ) AND language = 'Chinese Simplified'

Database: card_games
Question: What is the expansion type of the set "Hauptset Zehnte Edition"?
Evidence: card set "Hauptset Zehnte Edition" refers to translation = ' Hauptset Zehnte Edition'; expansion type refers to type
SQL: SELECT T1.type FROM sets AS T1 INNER JOIN set_translations AS T2 ON T2.setCode = T1.code WHERE T2.translation = 'Hauptset Zehnte Edition'

Database: european_football_2
Question: State the name of players who came from Belgium.
Evidence: name of players refers to player_name; Belgium is name of country
SQL: SELECT t3.player_name FROM Country AS t1 INNER JOIN Match AS t2 ON t1.id = t2.country_id INNER JOIN Player AS t3 ON t2.home_player_1 = t3.player_api_id WHERE t1.name = 'Belgium'