Database: music_platform_2
Question: What percentage of podcasts are "technology" podcasts? List all of them.
Evidence: "technology" podcast refers to category = 'technology'; percentage = Divide (Count (podcast_id (category = 'technology')), Count (podcast_id)) * 100
SQL: SELECT CAST(SUM(CASE WHEN T1.category = 'technology' THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(T2.title) OR '%' "percentage" FROM categories AS T1 INNER JOIN podcasts AS T2 ON T2.podcast_id = T1.podcast_id

Database: retails
Question: How many different clerks have served the customer with the address uFTe2u518et8Q8UC?
Evidence: clerk who have served the customer refers to o_clerk

SQL: SELECT COUNT(T1.o_clerk) FROM orders AS T1 INNER JOIN customer AS T2 ON T1.o_custkey = T2.c_custkey WHERE T2.c_address = 'uFTe2u518et8Q8UC'

Database: world_development_indicators
Question: List out the name and indicator code of high income: nonOECD countries
Evidence: high income: non-OECD' refer to IncomeGroup;
SQL: SELECT DISTINCT T1.CountryCode, T2.CountryName FROM Country AS T1 INNER JOIN Indicators AS T2 ON T1.CountryCode = T2.CountryCode WHERE T1.IncomeGroup = 'High income: nonOECD'

Database: retail_world
Question: What is the monthly average number of products shipped via Federal Shipping for the year 1996?
Evidence: monthly average number of products refers to DIVIDE(SUM(OrderID), 12); shipped via Federal Shipping refers to CompanyName = 'Federal Shipping'; for the year 1996 refers to year(ShippedDate) = 1996
SQL: SELECT CAST(SUM(T1.ShipVia) AS REAL) / 12 FROM Orders AS T1 INNER JOIN Shippers AS T2 ON T1.ShipVia = T2.ShipperID WHERE T2.CompanyName = 'Federal Shipping' AND T1.ShippedDate LIKE '1996%'

Database: video_games
Question: How many publishers in Japan released a game on X360 in 2011?
Evidence: in Japan refers to region_name = 'Japan'; on X360 refers to platform_name = 'X360'; in 2011 refers to release_year = 2011
SQL: SELECT COUNT(T3.game_publisher_id) FROM region AS T1 INNER JOIN region_sales AS T2 ON T1.id = T2.region_id INNER JOIN game_platform AS T3 ON T2.game_platform_id = T3.id INNER JOIN platform AS T4 ON T3.platform_id = T4.id WHERE T4.platform_name = 'X360' AND T3.release_year = 2011 AND T1.region_name = 'Japan'

Database: music_tracker
Question: What are the tags of the release "sugarhill gang"?
Evidence: release "sugarhill gang" refers to groupName = 'sugarhill gang';
SQL: SELECT T2.tag FROM torrents AS T1 INNER JOIN tags AS T2 ON T1.id = T2.id WHERE T1.groupName = 'sugarhill gang'

Database: olympics
Question: How many athletes participated in the 2014 Winter Olympics?
Evidence: athletes refer to person_id; 2014 Winter Olympics refer to games_name = '2014 Winter';
SQL: SELECT COUNT(T2.person_id) FROM games AS T1 INNER JOIN games_competitor AS T2 ON T1.id = T2.games_id WHERE T1.games_name = '2014 Winter'

Database: public_review_platform
Question: Calculate the percentage of businesses with the category name food that are open from 7AM to 8PM in the businesses with the same time.
Evidence: DIVIDE(COUNT(business_id where category_name = 'Food' and opening_time = '7AM' and closing_time = '8PM'), COUNT(business_id where opening_time = '7AM' and closing_time = '8PM')) as percentage;
SQL: SELECT CAST(SUM(CASE WHEN T3.category_name = 'Food' THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(T3.category_name) FROM Business_Categories AS T1 INNER JOIN Business AS T2 ON T1.business_id = T2.business_id INNER JOIN Categories AS T3 ON T1.category_id = T3.category_id

Database: authors
Question: How many papers were in the journal "Iet Software/iee Proceedings - Software"?
Evidence: journal "Iet Software/iee Proceedings - Software" refers to FullName = 'Iet Software/iee Proceedings - Software'; papers refers to COUNT(JournalId)
SQL: SELECT COUNT(T1.JournalId) FROM Paper AS T1 INNER JOIN Journal AS T2 ON T1.JournalId = T2.Id WHERE T2.FullName = 'Iet Software/iee Proceedings - Software'

Database: regional_sales
Question: How many orders were shipped by the sales team with the highest amount of shipped orders in 2020? Give the name of the said sales team.
Evidence: shipped refers to ShipDate; in 2020 refers to SUBSTR(ShipDate, -2) = '20'; highest amount of shipped orders refers to Max(Count(OrderNumber))
SQL: SELECT COUNT(T1.OrderNumber), T2.`Sales Team` FROM `Sales Orders` AS T1 INNER JOIN `Sales Team` AS T2 ON T2.SalesTeamID = T1._SalesTeamID WHERE T1.ShipDate LIKE '%/%/20' GROUP BY T2.`Sales Team` ORDER BY COUNT(T1.OrderNumber) DESC LIMIT 1

Database: books
Question: List all books authored by Tom Clancy.
Evidence: "Tom Clancy" is the author_name; books refers title
SQL: SELECT T1.title FROM book AS T1 INNER JOIN book_author AS T2 ON T1.book_id = T2.book_id INNER JOIN author AS T3 ON T3.author_id = T2.author_id WHERE T3.author_name = 'Tom Clancy'

Database: public_review_platform
Question: How many businesses in the city of Scottsdale open on Sunday at 12PM?
Evidence: businesses that opened on Sunday refers to day_of_week = 'Sunday'; businesses that opened at 12PM refers to opening_time = '12PM'
SQL: SELECT COUNT(DISTINCT T2.business_id) FROM Business AS T1 INNER JOIN Business_hours AS T2 ON T1.business_id = T2.business_id INNER JOIN Days AS T3 ON T2.day_id = T3.day_id WHERE T1.city = 'Scottsdale' AND T3.day_of_week = 'Sunday' AND T2.opening_time = '12PM'

Database: donor
Question: How many schools in the West New York School District have the highest poverty level?
Evidence: the highest poverty level refers to poverty_level = 'highest poverty'
SQL: SELECT COUNT(poverty_level) FROM projects WHERE school_district = 'West New York School District' AND poverty_level = 'highest poverty'

Database: disney
Question: Which of the movies directed by Ron Clements has the highest total gross?
Evidence: Ron Clements refer to director = 'Ron Clements'; the highest total gross refers to MAX(total_gross);
SQL: SELECT T2.movie_title FROM director AS T1 INNER JOIN movies_total_gross AS T2 ON T1.name = T2.movie_title WHERE T1.director = 'Ron Clements' ORDER BY CAST(REPLACE(trim(T2.total_gross, '$'), ',', '') AS REAL) DESC LIMIT 1

Database: retail_complains
Question: What is the most common issue for the highest priority complaints?
Evidence: most common refers to max(count(issue)); highest priority refers to priority = 2
SQL: SELECT T1.Issue FROM events AS T1 INNER JOIN callcenterlogs AS T2 ON T1.`Complaint ID` = T2.`Complaint ID` WHERE T2.priority = 2 GROUP BY T1.Issue ORDER BY COUNT(T1.Issue) DESC LIMIT 1

Database: sales
Question: Name the most expensive and the least expensive products available, excluding free gifts.
Evidence: most expensive product refers to MAX(Price); least expensive product refers to MIN(Price); excluding free gifts refers to not including Price = 0;
SQL: SELECT Name FROM Products WHERE Price IN (( SELECT MAX(Price) FROM Products ), ( SELECT MIN(Price) FROM Products ))

Database: movie_3
Question: Indicate the name of the actors of the films rated as 'Parents Strongly Precautioned' with the highest replacement cost.
Evidence: name refers to first_name, last_name; Parents Strongly Precautioned' refers to rating = 'PG-13'; 
highest replacement cost refers to MAX(replacement_cost)
SQL: SELECT T1.first_name, T1.last_name FROM actor AS T1 INNER JOIN film_actor AS T2 ON T1.actor_id = T2.actor_id INNER JOIN film AS T3 ON T2.film_id = T3.film_id WHERE T3.rating = 'PG-13' ORDER BY T3.replacement_cost DESC LIMIT 1

Database: synthea
Question: What is the prevalence percentage of condition no. 64859006?
Evidence: condition no. 64859006 refers to conditions where CODE = '64859006';
SQL: SELECT DISTINCT T1."PREVALENCE PERCENTAGE" FROM all_prevalences AS T1 INNER JOIN conditions AS T2 ON lower(T1.ITEM) = lower(T2.DESCRIPTION) WHERE T2.code = '64859006'