Database: superstore
Question: List the customer's name from the South region with a standard class ship mode and sales greater than the 88% of the average sales of all orders.
Evidence: sales greater than the 88% of the average sales of all orders refers to Sales > avg(Sales) * 0.88; South region refers to south_superstore
SQL: SELECT DISTINCT T2.`Customer Name` FROM south_superstore AS T1 INNER JOIN people AS T2 ON T1.`Customer ID` = T2.`Customer ID` WHERE T2.Region = 'South' AND T1.`Ship Mode` = 'Standard Class' AND 100 * T1.Sales / ( SELECT AVG(Sales) FROM south_superstore ) > 88

Database: movie_3
Question: How many customers rented for an above-average period?
Evidence: rented period refers to SUBTRACT(return_date, rental_date); calculation = rented period > (AVG(rented period))
SQL: SELECT COUNT(customer_id) FROM rental WHERE return_date - rental_date > ( SELECT AVG(return_date - rental_date) FROM rental )

Database: movielens
Question: List all of the user ids and ages who rated movies with the id 1695219?
SQL: SELECT T2.userid, T2.age FROM u2base AS T1 INNER JOIN users AS T2 ON T1.userid = T2.userid WHERE T1.movieid = 1695219

Database: movie_3
Question: Who are the top 5 actors with the highest number of films? List their full names and calculate the average number of films for each of the actors.
Evidence: actors with highest number of films refers to actor_id with Max(Count(film_id)); full name refers to first_name, last_name; average number of film = Divide (Count(film_id), 5)
SQL: SELECT T.first_name, T.last_name, num FROM ( SELECT T1.first_name, T1.last_name, COUNT(T2.film_id) AS num 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 GROUP BY T1.first_name, T1.last_name ) AS T ORDER BY T.num DESC LIMIT 5

Database: professional_basketball
Question: Who are the coaches for team with winning rate of 80% and above?
Evidence: winning rate of 80% and above refers to Divide (won, Sum(won, lost)) > 0.8; coaches refers to coachID
SQL: SELECT coachID FROM coaches GROUP BY tmID, coachID, won, lost HAVING CAST(won AS REAL) * 100 / (won + lost) > 80

Database: shipping
Question: Determine the number of shipments delivered by Andrea Simons to Huntsville in 2016.
Evidence: "Huntsville" is the city_name; in 2016 refers to Cast(ship_date AS DATE) = 2016; number of shipment refers to Count(ship_id)
SQL: SELECT COUNT(*) FROM shipment AS T1 INNER JOIN city AS T2 ON T1.city_id = T2.city_id INNER JOIN driver AS T3 ON T3.driver_id = T1.driver_id WHERE T3.first_name = 'Andrea' AND T3.last_name = 'Simons' AND T2.city_name = 'Huntsville' AND STRFTIME('%Y', T1.ship_date) = '2016'

Database: human_resources
Question: In which state does Emily Wood work?
Evidence: Emily Wood is the full name of an employee; full name = firstname, lastname;
SQL: SELECT T2.state FROM employee AS T1  INNER JOIN location AS T2  ON T1.locationID = T2.locationID WHERE T1.firstname = 'Emily' AND T1.lastname = 'Wood'

Database: books
Question: Provide the title of the books published in British-English.
Evidence: "British English" is the language_name of the book
SQL: SELECT DISTINCT T1.title FROM book AS T1 INNER JOIN book_language AS T2 ON T1.language_id = T2.language_id WHERE T2.language_name = 'British English'

Database: books
Question: Who is the author of the book The Mystery in the Rocky Mountains?
Evidence: author refers to author_name; 'The Mystery in the Rocky Mountains' is the title of the book
SQL: SELECT T3.author_name 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 T1.title = 'The Mystery in the Rocky Mountains'

Database: address
Question: What is the total number of households in Arecibo county?
Evidence: "ARECIBO" is the county; total number of households refer to sum(households)
SQL: SELECT SUM(T1.households) FROM zip_data AS T1 INNER JOIN country AS T2 ON T1.zip_code = T2.zip_code WHERE T2.county = 'ARECIBO'

Database: sales_in_weather
Question: Provide the code summarization for the weather recorded by the weather station which contained the no.2 store on 2013/2/12.
Evidence: no.2 store refers to store_nbr = 2; on 2013/2/12 refers to date = '2013-02-12'; code summarization refers to codesum
SQL: SELECT T1.codesum FROM weather AS T1 INNER JOIN relation AS T2 ON T1.station_nbr = T2.station_nbr WHERE T1.`date` = '2013-02-12' AND T2.store_nbr = 2

Database: superstore
Question: What is the highest profit order in the East superstore of customers from Houston, Texas?
Evidence: highest profit refers to max(Profit); Houston, Texas refers to City = 'Houston' and State = 'Texas'
SQL: SELECT T1.`Order ID` FROM east_superstore AS T1 INNER JOIN people AS T2 ON T1.`Customer ID` = T2.`Customer ID` WHERE T2.City = 'Houston' AND T2.State = 'Texas' ORDER BY T1.Profit DESC LIMIT 1

Database: talkingdata
Question: List all females aged 24 to 26 devices' locations.
Evidence: females refers to gender = 'F'; aged 24 to 26 refers to `group` = 'F24-26';
SQL: SELECT T2.longitude, T2.latitude FROM gender_age AS T1 INNER JOIN events_relevant AS T2 ON T1.device_id = T2.device_id WHERE T1.`group` = 'F24-26' AND T1.gender = 'F'

Database: movielens
Question: List the top 5 movies from other countries which to language is not in English.
Evidence: not in English can be represented by isEnglish = 'F'
SQL: SELECT DISTINCT T1.movieid FROM u2base AS T1 INNER JOIN movies AS T2 ON T1.movieid = T2.movieid WHERE T2.country = 'other' AND T2.isEnglish = 'F' LIMIT 5

Database: car_retails
Question: How many sales representitives are based in the offices in the USA?
Evidence: Sales representative refers to jobTitle = 'Sales Rep'; country = 'USA';
SQL: SELECT COUNT(t1.employeeNumber) FROM employees AS t1 INNER JOIN offices AS t2 ON t1.officeCode = t2.officeCode WHERE t2.country = 'USA' AND t1.jobTitle = 'Sales Rep'

Database: movie_3
Question: In films with a length duration of 113 minutes, how many of the films are starred by Kirk Jovovich?
Evidence: length duration of 113 minutes refers to length = 113; 'Kirk Jovovich' is a full name of an actor; full name refers to first_name, last_name
SQL: SELECT COUNT(T1.actor_id) 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.length = 113 AND T1.first_name = 'Kirk' AND T1.last_name = 'Jovovich'

Database: retails
Question: Please name any three parts that have an available quantity of more than 9998.
Evidence: part name refers to p_name; an available quantity of more than 9998 refers to ps_availqty > 9998
SQL: SELECT T1.p_name FROM part AS T1 INNER JOIN partsupp AS T2 ON T1.p_partkey = T2.ps_partkey WHERE T2.ps_availqty > 9998 LIMIT 3

Database: retail_world
Question: Tell the country name of the supplier for "Scottish Longbreads".
Evidence: "Scottish Longbreads" refers to ProductName = 'Scottish Longbreads'
SQL: SELECT T2.Country FROM Products AS T1 INNER JOIN Suppliers AS T2 ON T1.SupplierID = T2.SupplierID WHERE T1.ProductName = 'Scottish Longbreads'

Database: public_review_platform
Question: Write down the any five of ID and name of category that starts with alphabet "P".
Evidence: category that starts with alphabet "P" refers to category_name like 'P%';
SQL: SELECT category_id, category_name FROM Categories WHERE category_name LIKE 'P%' LIMIT 5

Database: simpson_episodes
Question: What's the title of the episode that got the most 7-star votes in star score?
Evidence: 7-stars vote refers to stars = 7;  most refers to Max(votes)
SQL: SELECT T1.title FROM Episode AS T1 INNER JOIN Vote AS T2 ON T2.episode_id = T1.episode_id WHERE T2.stars = 7 ORDER BY T2.votes DESC LIMIT 1;