Database: superhero
Question: Count the fastest superheroes.
Evidence: fastest refers to attribute_value = 100 WHERE attribute_name = 'Speed';
SQL: SELECT COUNT(T3.superhero_name) FROM hero_attribute AS T1 INNER JOIN attribute AS T2 ON T1.attribute_id = T2.id INNER JOIN superhero AS T3 ON T1.hero_id = T3.id WHERE T2.attribute_name = 'Speed' AND T1.attribute_value = 100

Database: codebase_community
Question: What are the name of badges that users who have the lowest reputation obtained?
Evidence: lowest reputation refers to Min(Reputation); user refers to UserId
SQL: SELECT T2.Name FROM users AS T1 INNER JOIN badges AS T2 ON T1.Id = T2.UserId WHERE T1.Reputation = (SELECT MIN(Reputation) FROM users)

Database: thrombosis_prediction
Question: For in-patient age 50 and above, what is their average anti-cardiolipin antibody (IgG) concentration?
Evidence: in-patient refers to Admission = '+'; age 50 and above refers to SUBTRACT(year(current_timestamp), year(Birthday)) >= '50'; average anti-cardiolipin antibody (IgG) concentration refers to AVG(aCL IgG)
SQL: SELECT AVG(T2.`aCL IgG`) FROM Patient AS T1 INNER JOIN Examination AS T2 ON T1.ID = T2.ID WHERE STRFTIME('%Y', CURRENT_TIMESTAMP) - STRFTIME('%Y', T1.Birthday) >= 50 AND T1.Admission = '+'

Database: toxicology
Question: Among all chemical compounds that contain molecule TR047, identify the percent that form a double-bond.
Evidence: TR047 is the molecule id; double bond refers to bond_type = ' = '; percentage = DIVIDE(SUM(bond_type = ' = '), COUNT(all bond_id)) as percent where molecule_id = 'TR047'
SQL: SELECT CAST(COUNT(CASE WHEN T.bond_type = '=' THEN T.bond_id ELSE NULL END) AS REAL) * 100 / COUNT(T.bond_id) FROM bond AS T WHERE T.molecule_id = 'TR047'

Database: card_games
Question: How many cards available in paper have a positive starting maximum hand size?
Evidence: available in paper refers to availability like '%paper%'; have a positive starting maximum hand size refers to hand = '3'
SQL: SELECT SUM(CASE WHEN availability = 'paper' AND hAND = '3' THEN 1 ELSE 0 END) FROM cards

Database: formula_1
Question: What is the lap record for the Austrian Grand Prix Circuit?
Evidence: lap record means the fastest time recorded which refers to time
SQL: WITH fastest_lap_times AS ( SELECT T1.raceId, T1.fastestLapTime FROM results AS T1 WHERE T1.FastestLapTime IS NOT NULL) SELECT MIN(fastest_lap_times.fastestLapTime) as lap_record FROM fastest_lap_times INNER JOIN races AS T2 on fastest_lap_times.raceId = T2.raceId INNER JOIN circuits AS T3 on T2.circuitId = T3.circuitId WHERE T2.name = 'Austrian Grand Prix'

Database: card_games
Question: List the names of all the cards in the set Hour of Devastation and find the formats in which these cards are legal.
Evidence: the set Hour of Devastation refers to set.name = 'Hour of Devastation'; names of all the cards in the set refers to cards.name; legal cards refers to status = 'Legal'; the formats refers to format
SQL: SELECT DISTINCT T2.name , CASE WHEN T1.status = 'Legal' THEN T1.format ELSE NULL END FROM legalities AS T1 INNER JOIN cards AS T2 ON T2.uuid = T1.uuid WHERE T2.setCode IN ( SELECT code FROM sets WHERE name = 'Hour of Devastation' )

Database: toxicology
Question: What atoms comprise TR186?
Evidence: TR186 is a molecule id
SQL: SELECT T.atom_id FROM atom AS T WHERE T.molecule_id = 'TR186'

Database: superhero
Question: Give the name of the alien superheroes.
Evidence: alien superheroes refers to race = 'Alien'; name of superhero refers to superhero_name;
SQL: SELECT T1.superhero_name FROM superhero AS T1 INNER JOIN race AS T2 ON T1.race_id = T2.id WHERE T2.race = 'Alien'

Database: codebase_community
Question: State the name of badge that the user whose display name is "Sharpie" obtained.
Evidence: "Sharpie" is the DisplayName of user; user refers to UserId
SQL: SELECT T2.Name FROM users AS T1 INNER JOIN badges AS T2 ON T1.Id = T2.UserId WHERE T1.DisplayName = 'Sharpie'

Database: formula_1
Question: What is the average score of Lewis Hamilton among all the Turkish Grand Prix?
Evidence: Average score = AVG(points)
SQL: SELECT AVG(T2.points) FROM drivers AS T1 INNER JOIN driverStandings AS T2 ON T1.driverId = T2.driverId INNER JOIN races AS T3 ON T3.raceId = T2.raceId WHERE T1.forename = 'Lewis' AND T1.surname = 'Hamilton' AND T3.name = 'Turkish Grand Prix'

Database: thrombosis_prediction
Question: For all patients with normal uric acid (UA), what is the average UA index based on their latest laboratory examination result?
Evidence: uric acid (UA) with normal range refers to UA < 8.0 and SEX = 'M' or UA < 6.5 and SEX = 'F'; average UA index refers to AVG(UA)
SQL: SELECT AVG(T2.UA) FROM Patient AS T1 INNER JOIN Laboratory AS T2 ON T1.ID = T2.ID WHERE (T2.UA < 6.5 AND T1.SEX = 'F') OR (T2.UA < 8.0 AND T1.SEX = 'M') AND T2.Date = ( SELECT MAX(Date) FROM Laboratory )

Database: california_schools
Question: What is the free rate for students between the ages of 5 and 17 at the school run by Kacey Gibson?
Evidence: Eligible free rates for students aged 5-17 = `Free Meal Count (Ages 5-17)` / `Enrollment (Ages 5-17)`
SQL: SELECT CAST(T2.`Free Meal Count (Ages 5-17)` AS REAL) / T2.`Enrollment (Ages 5-17)` FROM schools AS T1 INNER JOIN frpm AS T2 ON T1.CDSCode = T2.CDSCode WHERE T1.AdmFName1 = 'Kacey' AND T1.AdmLName1 = 'Gibson'

Database: toxicology
Question: Among all chemical compounds identified in the database, what percent of compounds form a triple-bond.
Evidence: triple bond refers to bond_type = '#';
SQL: SELECT CAST(COUNT(CASE WHEN T.bond_type = '#' THEN T.bond_id ELSE NULL END) AS REAL) * 100 / COUNT(T.bond_id) FROM bond AS T

Database: toxicology
Question: How many single bonds are there in the list?
Evidence: single bond refers to bond_type = '-';
SQL: SELECT COUNT(T.bond_id) FROM bond AS T WHERE T.bond_type = '-'

Database: toxicology
Question: In the molecule TR008, how many carbons are present?
Evidence: carbon refers to element = 'c'
SQL: SELECT COUNT(T.atom_id) FROM atom AS T WHERE T.molecule_id = 'TR008' AND T.element = 'c'

Database: financial
Question: How many male customers who were born between 1974 and 1976 have made a payment on their home in excess of $4000?
Evidence: Man and male refers to gender = 'M'; 'SIPO' stands for household payment
SQL: SELECT COUNT(T1.account_id) FROM trans AS T1 INNER JOIN account AS T2 ON T1.account_id = T2.account_id INNER JOIN disp AS T4 ON T2.account_id = T4.account_id INNER JOIN client AS T3 ON T4.client_id = T3.client_id WHERE STRFTIME('%Y', T3.birth_date) BETWEEN '1974' AND '1976' AND T3.gender = 'M' AND T1.amount > 4000 AND T1.k_symbol = 'SIPO'

Database: california_schools
Question: Which different county has the most number of closed schools? Please provide the name of each school as well as the closure date.
Evidence: Closure date and closed date are synonyms; 'Closed' was mentioned in schools.StatusType.
SQL: SELECT DISTINCT County, School, ClosedDate FROM schools WHERE County = ( SELECT County FROM schools WHERE StatusType = 'Closed' GROUP BY County ORDER BY COUNT(School) DESC LIMIT 1 ) AND StatusType = 'Closed' AND school IS NOT NULL

Database: financial
Question: State different accounts who have account opening date before 1997 and own an amount of money greater than 3000USD
SQL: SELECT DISTINCT T2.account_id FROM trans AS T1 INNER JOIN account AS T2 ON T1.account_id = T2.account_id WHERE STRFTIME('%Y', T2.date) < '1997' AND T1.amount > 3000

Database: codebase_community
Question: How many comments were added to the post with the highest score?
Evidence: the highest score refers to MAX(Score);
SQL: SELECT COUNT(T2.Id) FROM posts AS T1 INNER JOIN comments AS T2 ON T1.Id = T2.PostId GROUP BY T1.Id ORDER BY SUM(T1.Score) DESC LIMIT 1