Database: movies_4
Question: What is the title of the highest-budget film to date? Please include the revenue and name the country.
Evidence: highest-budget film refers to max(budget); name the country refers to country_name
SQL: SELECT T1.title, T1.revenue, T3.COUNTry_name FROM movie AS T1 INNER JOIN production_COUNTry AS T2 ON T1.movie_id = T2.movie_id INNER JOIN COUNTry AS T3 ON T2.COUNTry_id = T3.COUNTry_id ORDER BY T1.budget DESC LIMIT 1

Database: olympics
Question: What are the names of the cities where Carl Lewis Borack competed?
Evidence: name of the cities refers to city_name
SQL: SELECT T4.city_name FROM person AS T1 INNER JOIN games_competitor AS T2 ON T1.id = T2.person_id INNER JOIN games_city AS T3 ON T2.games_id = T3.games_id INNER JOIN city AS T4 ON T3.city_id = T4.id WHERE T1.full_name = 'Carl Lewis Borack'

Database: sales
Question: What is the name of the most expensive product?
Evidence: most expensive product refers to MAX(Price);
SQL: SELECT Name FROM Products WHERE Price = ( SELECT MAX(Price) FROM Products )

Database: college_completion
Question: In year 2010 at schools located in Hawaii, what is the percentage of schools offers an associate's degree?
Evidence: Hawaii refers to state = 'Hawaii'; associate's degree refers to level = '2-year'; percentage = MULTIPLY(DIVIDE(SUM(level = '2-year' ), count(level)), 1.0);
SQL: SELECT CAST(SUM(CASE WHEN T2.level = '2-year' THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(T2.level) FROM state_sector_details AS T1 INNER JOIN state_sector_grads AS T2 ON T2.stateid = T1.stateid WHERE T2.state = 'Hawaii' AND T2.year = 2010

Database: sales
Question: In sales ID between 30 and 40, who is the customer that bought a total quantity of 403?
Evidence: who refers to FirstName, LastName;
SQL: SELECT T2.FirstName, T2.LastName FROM Sales AS T1 INNER JOIN Customers AS T2 ON T1.CustomerID = T2.CustomerID WHERE T1.Quantity = 403 AND T1.SalesID BETWEEN 30 AND 40

Database: movie_platform
Question: What are the top 10 oldest movies and what are the average rating score for each movie? Indicate the name of the director and when the movies were released.
Evidence: the average rating score refers to AVG(T2.rating_score); oldest movies refers to MIN(rating_timestamp_utc)
SQL: SELECT T2.movie_id, AVG(T1.rating_score), T2.director_name, T2.movie_release_year FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_timestamp_utc ASC LIMIT 10

Database: synthea
Question: What is the average body mass index for patients with higher total cholesterol?
Evidence: average body mass index = DIVIDE(SUM(observations.VALUE), COUNT(PATIENT) WHERE observations.DESCRIPTION = 'Body Mass Index'); body mass index refers to observations.DESCRIPTION = 'Body Mass Index'; higher total cholesterol refers to observations.DESCRIPTION = 'Total Cholesterol' and observations.VALUE > = 200;
SQL: SELECT SUM(T1.VALUE) / COUNT(T1.PATIENT) FROM observations AS T1 INNER JOIN ( SELECT DISTINCT PATIENT FROM observations WHERE DESCRIPTION = 'Total Cholesterol' AND VALUE > 200 ) AS T2 ON T1.PATIENT = T2.PATIENT WHERE T1.DESCRIPTION = 'Body Mass Index'

Database: music_platform_2
Question: List all of the two-star reviews and their categories.
Evidence: two-stars review refers to rating = 2
SQL: SELECT T1.category FROM categories AS T1 INNER JOIN reviews AS T2 ON T2.podcast_id = T1.podcast_id WHERE T2.rating = 2

Database: retails
Question: Among the suppliers in the European region, what percentage have a below-average account balance?
Evidence: DIVIDE(COUNT(s_acctbal < AVG(s_acctbal)), COUNT(s_suppkey)) as percentage where r_name = 'EUROPE';
SQL: SELECT CAST(SUM(IIF(T3.s_acctbal < ( SELECT AVG(supplier.s_acctbal) FROM supplier ), 1, 0)) AS REAL) * 100 / COUNT(T1.n_nationkey) FROM nation AS T1 INNER JOIN region AS T2 ON T1.n_regionkey = T2.r_regionkey INNER JOIN supplier AS T3 ON T1.n_nationkey = T3.s_nationkey WHERE T2.r_name = 'EUROPE'

Database: movies_4
Question: Among Warner Bros. Pictures' movies, which title made the highest revenue?
Evidence: Warner Bros. Pictures' movies refers to company_name = 'Warner Bros. Pictures'; highest revenue refers to max(revenue)
SQL: SELECT T3.title FROM production_company AS T1 INNER JOIN movie_company AS T2 ON T1.company_id = T2.company_id INNER JOIN movie AS T3 ON T2.movie_id = T3.movie_id WHERE T1.company_name = 'Warner Bros. Pictures' ORDER BY T3.revenue DESC LIMIT 1

Database: movie_3
Question: Please list the full names of all the actors that have starred in the film with the highest replacement cost.
Evidence: highest replacement cost refers to Max (replacement_cost); full name refers to first_name, last_name
SQL: SELECT first_name, 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 ORDER BY T3.replacement_cost DESC LIMIT 1

Database: donor
Question: How many donations of more than $100 were made for an honoree?
Evidence: an honoree refers to for_honoree = 't'; more than $100 refers to dollar_amount = '100_and_up'
SQL: SELECT COUNT(donationid) FROM donations WHERE dollar_amount = '100_and_up' AND for_honoree = 't'

Database: university
Question: Provide the criteria name of the ranking criteria ID 13.
SQL: SELECT criteria_name FROM ranking_criteria WHERE id = 13

Database: retail_complains
Question: How many priority urgent complaints were received in march of 2017? List the complaint ID of these complaints.
Evidence: urgent complaints refers to priority = 2; march of 2017 refers to "Date received" BETWEEN '2017-01-01' AND '2017-01-31';
SQL: SELECT COUNT(`Complaint ID`) FROM callcenterlogs WHERE `Date received` LIKE '2017-01%' AND priority = ( SELECT MAX(priority) FROM callcenterlogs )

Database: regional_sales
Question: What is the detailed position of the store which has order SO - 000115?
Evidence: Latitude and Longitude coordinates can be used to identify the detailed position of stores; store refers to StoreID WHERE OrderNumber = 'SO - 000115';
SQL: SELECT T2.Latitude, T2.Longitude FROM `Sales Orders` AS T1 INNER JOIN `Store Locations` AS T2 ON T2.StoreID = T1._StoreID WHERE T1.OrderNumber = 'SO - 000115'

Database: music_platform_2
Question: What is the rating and category of the podcast entitled Sitcomadon?
Evidence: entitled refers to title; 'Sitcomadon' is the title of podcast
SQL: SELECT DISTINCT T3.rating, T1.category FROM categories AS T1 INNER JOIN podcasts AS T2 ON T2.podcast_id = T1.podcast_id INNER JOIN reviews AS T3 ON T3.podcast_id = T2.podcast_id WHERE T2.title = 'Sitcomadon'

Database: professional_basketball
Question: Which player selected by Portland in 2nd draftRound won Rookie of the Year in 1971?
Evidence: 2nd draftRound refers to draftRound = 2; won Rookie of the Year refers to award = 'Rookie of the Year'; in 1971 refers to draftYear = 1971
SQL: SELECT T1.playerID FROM draft AS T1 INNER JOIN awards_players AS T2 ON T1.playerID = T2.playerID WHERE T2.award = 'Rookie of the Year' AND T1.draftYear = 1971 AND T1.draftRound = 2

Database: movie_3
Question: Calculate the average rate of renting the film that Lucille Tracy got starred.
Evidence: average rate = divide(sum(rental_rate), count(film_id))
SQL: SELECT AVG(T3.rental_rate) 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 T1.first_name = 'LUCILLE' AND T1.last_name = 'TRACY'

Database: bike_share_1
Question: Among all the trips, which day had the most bikes borrowed? What was the average coldest temperature on that day?
Evidence: which day had the most bikes borrowed refers to MAX(start_date); the average coldest temperature can be computed as DIVIDE(SUM(min_temperature_f), COUNT(min_temperature_f));
SQL: SELECT T2.date, AVG(T2.min_temperature_f) FROM trip AS T1 INNER JOIN weather AS T2 ON T2.zip_code = T1.zip_code GROUP BY T2.date ORDER BY COUNT(T1.start_date) DESC LIMIT 1