Database: simpson_episodes
Question: Out of the rating of 6.8 scored by title "No Loan Again, Naturally", how many percent of it consists of scores 5 to 10?
Evidence: scores 5 to 10 refers to TOTAL(percent) where 1 < = stars < 5
SQL: SELECT SUM(T2.percent) FROM Episode AS T1 INNER JOIN Vote AS T2 ON T2.episode_id = T1.episode_id WHERE T1.title = 'No Loan Again, Naturally' AND T1.rating = 6.8 AND T2.stars BETWEEN 5 AND 10;

Database: olympics
Question: What are the names of the events under Art Competitions?
Evidence: Art Competitions refer to sport_name = 'Art Competitions'; names of events refers to event_name;
SQL: SELECT T2.event_name FROM sport AS T1 INNER JOIN event AS T2 ON T1.id = T2.sport_id WHERE T1.sport_name = 'Art Competitions'

Database: menu
Question: How many percent of Bluefish dishes are located at the center of the menu page?
Evidence: percent = MULTIPLY(DIVIDE(SUM(xpos BETWEEN 0.25 AND 0.75 and ypos BETWEEN 0.25 AND 0.75), COUNT(id)), 1.0); Bluefish is a sub name of dish; located at the center of the menu page refers to xpos BETWEEN 0.25 AND 0.75 and ypos BETWEEN 0.25 AND 0.75;
SQL: SELECT CAST(SUM(CASE WHEN T2.xpos BETWEEN 0.25 AND 0.75 AND T2.ypos BETWEEN 0.25 AND 0.75 THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(T2.id) FROM Dish AS T1 INNER JOIN MenuItem AS T2 ON T1.id = T2.dish_id WHERE T1.name LIKE '%BLuefish%'

Database: disney
Question: Who is the hero character of the movie whose total gross was $222,527,828?
Evidence: FALSE;
SQL: SELECT T1.hero FROM characters AS T1 INNER JOIN movies_total_gross AS T2 ON T2.movie_title = T1.movie_title WHERE T2.total_gross = '$222,527,828'

Database: world_development_indicators
Question: Please list the indicator names of Arab World whose values are higher than 50 in 1960.
Evidence: Arab World refers to CountryName; Year = '1960'; values are higher than 50 refers to Value>50;
SQL: SELECT IndicatorName FROM Indicators WHERE CountryName = 'Arab World' AND Year = 1960 AND Value > 50

Database: retail_world
Question: How many employees have territories in the Eastern region?
Evidence: "Eastern" is the RegionDescription
SQL: SELECT COUNT(DISTINCT T1.FirstName) FROM Employees AS T1 INNER JOIN EmployeeTerritories AS T2 ON T1.EmployeeID = T2.EmployeeID INNER JOIN Territories AS T3 ON T2.TerritoryID = T3.TerritoryID INNER JOIN Region AS T4 ON T3.RegionID = T4.RegionID WHERE T4.RegionDescription = 'Eastern'

Database: retail_world
Question: How old was the oldest employee at the time he or she was hired?
Evidence: oldest employee at the time he or she was hired refers to MAX(SUBTRACT(HireDate, Birthdate))
SQL: SELECT MAX(TIMESTAMPDIFF(YEAR, BirthDate, HireDate)) FROM Employees

Database: olympics
Question: What age of the competitors is the most numerous?
Evidence: age is the most numerous refers to age where MAX(COUNT(person_id));
SQL: SELECT age FROM games_competitor GROUP BY age ORDER BY COUNT(person_id) DESC LIMIT 1

Database: olympics
Question: What is Vijay Singh Chauhan's region name?
SQL: SELECT T1.region_name FROM noc_region AS T1 INNER JOIN person_region AS T2 ON T1.id = T2.region_id INNER JOIN person AS T3 ON T2.person_id = T3.id WHERE T3.full_name = 'Vijay Singh Chauhan'

Database: genes
Question: Please list the motif of the genes that are located in the cytoplasm and have 7 chromosomes.
SQL: SELECT T2.GeneID1, T2.GeneID2 FROM Genes AS T1 INNER JOIN Interactions AS T2 ON T1.GeneID = T2.GeneID1 WHERE T1.Localization = 'cytoplasm' AND T1.Chromosome = 7

Database: retails
Question: How many of the line items that have a quantity greater than 40 have been shipped by air?
Evidence: quantity greater than 40 refers to l_quantity > 40; shipped by air refers to l_shipmode = 'AIR'
SQL: SELECT COUNT(l_linenumber) FROM lineitem WHERE l_quantity > 40 AND l_shipmode = 'AIR'

Database: address
Question: What are the bad aliases of the postal points from East Setauket?
Evidence: East Setauket is the city;
SQL: SELECT T1.bad_alias FROM avoid AS T1 INNER JOIN zip_data AS T2 ON T1.zip_code = T2.zip_code WHERE T2.city = 'East Setauket'

Database: donor
Question: Calculate the sum of all the total amount donated to the essay project titled 'Lets Share Ideas' which were paid through paypal and indicate the city and poverty level.
Evidence: paypal refer to payment method; Lets Share Ideas refer to title; city refer to school_city; total amount donated refer to SUM(donation_total of paypal where payment_method = ’paypal’)
SQL: SELECT SUM(T3.donation_total), school_city, poverty_level FROM essays AS T1 INNER JOIN projects AS T2 ON T1.projectid = T2.projectid INNER JOIN donations AS T3 ON T2.projectid = T3.projectid WHERE T1.title = 'Lets Share Ideas' AND T3.payment_method = 'paypal'

Database: movie_3
Question: What is the average rental rate for PG-13 rated movies?
Evidence: PG-13 rated movie refers to rating = 'PG-13'; average rental rate = avg(rental_rate)
SQL: SELECT AVG(rental_rate) FROM film WHERE rating = 'PG-13'

Database: legislator
Question: How many female representatives served in the state of California for at least 10 years?
Evidence: female refers to gender_bio = 'F'; representatives refers to type = 'rep'; served for at least 10 years refers to SUBTRACT(SUM(CAST(strftime('%Y', end)), CAST(strftime('%Y', start)))) > 10;
SQL: SELECT SUM(T3.result) FROM ( SELECT CASE WHEN SUM(CAST(strftime('%Y', T2.`end`) AS int) - CAST(strftime('%Y', T2.start) AS int)) > 10 THEN 1 ELSE 0 END AS result FROM current AS T1 INNER JOIN "current-terms" AS T2 ON T1.bioguide_id = T2.bioguide WHERE T1.gender_bio = 'F' AND T2.state = 'CA' AND T2.type = 'rep' ) AS T3

Database: retail_world
Question: Please list the full names and titles of all employees.
Evidence: full name refers to LastName, FirstName
SQL: SELECT FirstName, LastName, Title FROM Employees

Database: authors
Question: What is the conference homepage URL of the paper titled "Quality evaluation of long duration audiovisual content"?
Evidence: homepage URL refers to HomePage; 'Quality evaluation of long duration audiovisual content' is the Title
SQL: SELECT T2.HomePage FROM Paper AS T1 INNER JOIN Conference AS T2 ON T1.ConferenceId = T2.Id WHERE T1.Title = 'Quality evaluation of long duration audiovisual content'

Database: cs_semester
Question: List the full name of the professors who advised students with intelligence 1.
Evidence: full name of the professors = first_name, last_name;
SQL: SELECT T1.first_name, T1.last_name FROM prof AS T1 INNER JOIN RA AS T2 ON T1.prof_id = T2.prof_id INNER JOIN student AS T3 ON T2.student_id = T3.student_id WHERE T3.intelligence = 1

Database: beer_factory
Question: What is the email address of the customer who made a purchase in transaction 100016?
Evidence: email address refers to Email; transaction 100016 refers to TransactionID = 100016;
SQL: SELECT T1.Email FROM customers AS T1 INNER JOIN `transaction` AS T2 ON T1.CustomerID = T2.CustomerID WHERE T2.TransactionID = '100016'

Database: simpson_episodes
Question: What is the total number of awards won by The simpson 20s: Season 20?
Evidence: total number of awards refers to COUNT(award); awards won refers to result = 'Winner';
SQL: SELECT COUNT(award_id) FROM Award WHERE result = 'Winner';

Database: music_platform_2
Question: What is the percentage of reviews added each year of the total reviews added?
Evidence: review added each year refers to runs_at like '2021%' and runs_at like '2022%'; percentage for 2021 = Divide (Sum(reviews_added(runs_at like '2021%)), Sum(reviews_added)) * 100; percentage of 2022 = Divide (Sum(reviews_added(runs_at like '2022%')), Sum(reviews_added)) * 100
SQL: SELECT CAST((SUM(CASE WHEN run_at LIKE '2022-%' THEN reviews_added ELSE 0 END) - SUM(CASE WHEN run_at LIKE '2021-%' THEN reviews_added ELSE 0 END)) AS REAL) * 100 / SUM(reviews_added) OR '%' "percentage" FROM runs