Database: formula_1
Question: List down top 3 German drivers who has the shortest average pit stop duration and were born between 1980-1985.
Evidence: Full name of the driver refers to drivers.forename and drivers.surname; born between 1980-1985 refers to 1980< year(dob)>1985; Average pitstop duration refers to Divide(SUM(duration),COUNT(duration)); shortest average refers to Min(avg(duration));
SQL: SELECT T2.forename, T2.surname FROM pitStops AS T1 INNER JOIN drivers AS T2 on T1.driverId = T2.driverId WHERE T2.nationality = 'German' AND STRFTIME('%Y', T2.dob) BETWEEN '1980' AND '1985' GROUP BY T2.forename, T2.surname ORDER BY AVG(T1.duration) LIMIT 3

Database: california_schools
Question: Which schools served a grade span of Kindergarten to 9th grade in the county of Los Angeles and what is its Percent (%) Eligible FRPM (Ages 5-17)?
Evidence: Percent (%) Eligible FRPM (Ages 5-17) can be acquired by `FRPM Count (Ages 5-17)` / `Enrollment (Ages 5-17)` * 100
SQL: SELECT T2.School, T1.`FRPM Count (Ages 5-17)` * 100 / T1.`Enrollment (Ages 5-17)` FROM frpm AS T1 INNER JOIN schools AS T2 ON T1.CDSCode = T2.CDSCode WHERE T2.County = 'Los Angeles' AND T2.GSserved = 'K-9'

Database: superhero
Question: Among the male superheroes, list the super hero names of superheroes with weight greater than the 79% average weight of all superheroes.
Evidence: super hero names refers to superhero_name;male superheros refers to gender = 'Male';Calculation = weight_kg > MULTIPLY(AVG(weight_kg), 0.79)
SQL: SELECT T1.superhero_name FROM superhero AS T1 INNER JOIN gender AS T2 ON T1.gender_id = T2.id WHERE T2.gender = 'Male' AND T1.weight_kg * 100 > ( SELECT AVG(weight_kg) FROM superhero ) * 79

Database: student_club
Question: What is the most expensive item that was spent in support of club events?
Evidence: item in support of club events refers to expense_description; most expensive refers to MAX(cost)
SQL: SELECT expense_description FROM expense ORDER BY cost DESC LIMIT 1

Database: formula_1
Question: Please give more information about the Formula_1 races that used the Silverstone Circuit.
Evidence: more information refers to url
SQL: SELECT DISTINCT T1.url FROM circuits AS T1 INNER JOIN races AS T2 ON T2.circuitID = T1.circuitId WHERE T1.name = 'Silverstone Circuit'

Database: thrombosis_prediction
Question: Please list the disease names of the patients that have a proteinuria level higher than normal.
Evidence: disease names refers to Diagnosis; proteinuria level higher than normal refers to `U-PRO` > = 30;
SQL: SELECT T1.Diagnosis FROM Patient AS T1 INNER JOIN Laboratory AS T2 ON T1.ID = T2.ID WHERE T2.`U-PRO` >= 30

Database: card_games
Question: How many card border with black color ? List out the card id.
Evidence: border with black color refers to borderColor = 'black'
SQL: SELECT id FROM cards WHERE borderColor = 'black' GROUP BY id

Database: toxicology
Question: What are the atom IDs of the bond TR000_2_5?
Evidence: TR000_2_5 is the bond id
SQL: SELECT T.atom_id FROM connected AS T WHERE T.bond_id = 'TR000_2_5'

Database: formula_1
Question: Which country is the constructor which got 1 point in the race No. 24 from?
Evidence: race number refers to raceId;
SQL: SELECT T2.nationality FROM constructorResults AS T1 INNER JOIN constructors AS T2 ON T2.constructorId = T1.constructorId WHERE T1.raceId = 24 AND T1.points = 1

Database: superhero
Question: What is the name of the superhero that has the most powers?
Evidence: name of the superhero refers to superhero_name; superhero that has the most powers refers to MAX(COUNT(superhero_name))
SQL: SELECT T1.superhero_name FROM superhero AS T1 INNER JOIN hero_power AS T2 ON T1.id = T2.hero_id GROUP BY T1.superhero_name ORDER BY COUNT(T2.hero_id) DESC LIMIT 1

Database: toxicology
Question: What is the percentage of carcinogenic molecules in triple type bonds?
Evidence: label = '+' mean molecules are carcinogenic; triple bond refers to bond_type = '#'; percentage = DIVIDE(SUM(bond_type = '#') * 100, COUNT(bond_id)) as percent where label = '+'
SQL: SELECT CAST(COUNT(DISTINCT CASE WHEN T2.label = '+' THEN T2.molecule_id ELSE NULL END) AS REAL) * 100 / COUNT(DISTINCT T2.molecule_id) FROM atom AS T1 INNER JOIN molecule AS T2 ON T1.molecule_id = T2.molecule_id INNER JOIN bond AS T3 ON T2.molecule_id = T3.molecule_id WHERE T3.bond_type = '#'

Database: toxicology
Question: Calculate the average number of oxygen atoms in single-bonded molecules.
Evidence: single-bonded molecules refers to bond_type = '-' ; average number of oxygen atom = AVG(element = 'o')
SQL: SELECT AVG(oxygen_count) FROM (SELECT T1.molecule_id, COUNT(T1.element) AS oxygen_count FROM atom AS T1 INNER JOIN bond AS T2 ON T1.molecule_id = T2.molecule_id  WHERE T2.bond_type = '-' AND T1.element = 'o'  GROUP BY T1.molecule_id) AS oxygen_counts

Database: card_games
Question: What languages are available in the set known as Archenemy on the magic card market and having the code ARC?
Evidence: known as Archenemy refers to mcmName = 'Archenemy'; having the code ARC refers to setCode = 'ARC'
SQL: SELECT T2.language FROM sets AS T1 INNER JOIN set_translations AS T2 ON T1.code = T2.setCode WHERE T1.mcmName = 'Archenemy' AND T2.setCode = 'ARC'

Database: student_club
Question: Which members who were approved from 1/10/2019 to 11/19/2019? Please identify the member who attended the event and the link to their event.
Evidence: approved from 1/10/2019 to 11/19/2019 refers to approved = 'true' and expense_date BETWEEN '2019-01-10' and '2019-11-19'
SQL: SELECT DISTINCT T1.link_to_member, T3.link_to_event FROM expense AS T1 INNER JOIN member AS T2 ON T1.link_to_member = T2.member_id INNER JOIN attendance AS T3 ON T2.member_id = T3.link_to_member WHERE date(SUBSTR(T1.expense_date, 1, 10)) BETWEEN '2019-01-10' AND '2019-11-19' AND T1.approved = 'true'

Database: card_games
Question: What is the percentage of cards whose language is French among the Story Spotlight cards?
Evidence: Story Spotlight card refers to isStorySpotlight = 1; French is the language; Percentage = Divide(Count(id) where language = 'French' and isStorySpotlight = 1, Count(id) where isStorySpotlight = 1)*100
SQL: SELECT CAST(SUM(CASE WHEN T2.language = 'French' THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(T1.id) FROM cards AS T1 INNER JOIN foreign_data AS T2 ON T1.uuid = T2.uuid WHERE T1.isStorySpotlight = 1

Database: formula_1
Question: Which drivers born after 1975 have been ranked 2? Please give their forenames and surnames.
Evidence: born after 1975 refers to year(dob) >1975;
SQL: SELECT T2.forename, T2.surname FROM results AS T1 INNER JOIN drivers AS T2 on T1.driverId = T2.driverId WHERE STRFTIME('%Y', T2.dob) > '1975' AND T1.rank = 2

Database: card_games
Question: What is the type of card "Benalish Knight"?
Evidence: Benalish Knight' is the name of card;
SQL: SELECT DISTINCT T1.type FROM cards AS T1 INNER JOIN foreign_data AS T2 ON T1.uuid = T2.uuid WHERE T1.name = 'Benalish Knight'

Database: toxicology
Question: What type of bond is there between the atoms TR004_8 and TR004_20?
Evidence: type of bond refers to bond_type; between the atoms TR004_8 and TR004_20 refers to atom_id = 'TR004_8' AND atom_id2 = 'TR004_20' OR another way around
SQL: SELECT T1.bond_type FROM bond AS T1 INNER JOIN connected AS T2 ON T1.bond_id = T2.bond_id WHERE T2.atom_id = 'TR004_8' AND T2.atom_id2 = 'TR004_20' OR T2.atom_id2 = 'TR004_8' AND T2.atom_id = 'TR004_20'