Database: public_review_platform
Question: What is the category of the business with short review length and highest review stars within business ID from 5 t0 10?
Evidence: short review length refers to review_length = 'Short'; highest review stars refers to Max(review_stars); business ID from 5 to 10 refers to business_id BETWEEN 5 AND 10; category of business refers to category_name
SQL: SELECT T4.category_name FROM Reviews AS T1 INNER JOIN Business AS T2 ON T1.business_id = T2.business_id INNER JOIN Business_Categories AS T3 ON T2.business_id = T3.business_id INNER JOIN Categories AS T4 ON T3.category_id = T4.category_id WHERE T1.review_length LIKE 'Short' AND T2.business_id BETWEEN 5 AND 10 ORDER BY T1.review_stars DESC LIMIT 1

Database: soccer_2016
Question: What is the id of the team with the highest number of matches won?
Evidence: id of the team refers to Team_Id; highest number of matches won refers to max(count(Match_Winner))
SQL: SELECT Match_Id FROM `Match` ORDER BY Match_Winner DESC LIMIT 1

Database: professional_basketball
Question: Please list down the last name of players from "BLB" team.
Evidence: "BLB" is the tmID
SQL: SELECT T1.lastName FROM players AS T1 INNER JOIN players_teams AS T2 ON T1.playerID = T2.playerID WHERE T2.tmID = 'BLB'

Database: superstore
Question: What is the total sales of 'Avery Hi-Liter EverBold Pen Style Fluorescent Highlighters, 4/Pack' in the Central region?
Evidence: 'Avery Hi-Liter EverBold Pen Style Fluorescent Highlighters, 4/Pack' is the "Product Name";
SQL: SELECT SUM(T1.Sales) FROM central_superstore AS T1 INNER JOIN product AS T2 ON T1.`Product ID` = T2.`Product ID` WHERE T2.`Product Name` = 'Avery Hi-Liter EverBold Pen Style Fluorescent Highlighters, 4/Pack' AND T2.Region = 'Central'

Database: movies_4
Question: Provide the release date and language of the most popular movie.
Evidence: language refers to langauge_name; most popular movie refers to max(popularity)
SQL: SELECT T1.release_date, T3.language_name FROM movie AS T1 INNER JOIN movie_languages AS T2 ON T1.movie_id = T2.movie_id INNER JOIN language AS T3 ON T2.language_id = T3.language_id ORDER BY T1.popularity DESC LIMIT 1

Database: disney
Question: Find the estimated inflation rate that was used to adjust the 1995 box office revenue for Disney's films.
Evidence: DIVIDE(inflation_adjusted_gross, total_gross) as percentage where substr(release_date, length(release_date) - 3, length(release_date)) = '1995';
SQL: SELECT SUM(CAST(REPLACE(trim(inflation_adjusted_gross, '$'), ',', '') AS REAL)) / SUM(CAST(REPLACE(trim(total_gross, '$'), ',', '') AS REAL)) FROM movies_total_gross WHERE SUBSTR(release_date, LENGTH(release_date) - 3, LENGTH(release_date)) = '1995' GROUP BY SUBSTR(release_date, LENGTH(release_date) - 3, LENGTH(release_date)) = '1995'

Database: synthea
Question: How many white patients whose birth year is 1935 have a stroke?
Evidence: white refers to race = 'white'; birth year is 1935 refers to substr(birthdate, 1, 4) = '1935'; stroke refers to conditions.DESCRIPTION = 'Stroke';
SQL: SELECT COUNT(DISTINCT T1.patient) FROM patients AS T1 INNER JOIN conditions AS T2 ON T1.patient = T2.patient WHERE strftime('%Y', T1.birthdate) = '1935' AND T1.race = 'white' AND T2.DESCRIPTION = 'Stroke'

Database: student_loan
Question: State the number of disabled students who have payment due.
Evidence: have payment due refers to bool = 'pos';
SQL: SELECT COUNT(T1.name) FROM no_payment_due AS T1 INNER JOIN disabled AS T2 ON T1.name = T2.name WHERE T1.bool = 'neg'

Database: disney
Question: Among Frank Welker's voice-acted movies, list the movie titles and the total gross when the estimated inflation rate was less than 2.
Evidence: Frank Welker refers to voice-actor = 'Frank Welker'; estimated inflation rate was less than 2 can be computed as follows DIVIDE(inflation_adjusted_gross, total_gross) as percentage < 2;
SQL: SELECT T1.movie_title, T1.total_gross FROM movies_total_gross AS T1 INNER JOIN `voice-actors` AS T2 ON T1.movie_title = T2.movie WHERE T2.`voice-actor` = 'Frank Welker' AND CAST(REPLACE(trim(T1.inflation_adjusted_gross, '$'), ',', '') AS REAL) * 1.0 / CAST(REPLACE(trim(T1.total_gross, '$'), ',', '') AS REAL) * 1.0 < 2

Database: social_media
Question: Please list the texts of all the tweets that are not in English.
Evidence: not in English refers to Lang <> en'
SQL: SELECT text FROM twitter WHERE Lang != 'en'

Database: food_inspection_2
Question: What is the name of the establishment that Joshua Rosa inspected?
Evidence: name of the establishment refers to dba_name
SQL: SELECT DISTINCT T3.dba_name FROM employee AS T1 INNER JOIN inspection AS T2 ON T1.employee_id = T2.employee_id INNER JOIN establishment AS T3 ON T2.license_no = T3.license_no WHERE T1.first_name = 'Joshua' AND T1.last_name = 'Rosa'

Database: talkingdata
Question: Among the devices with event no.2 happening, how many of them are vivo devices?
Evidence: event no. refers to event_id; event_id = 2; vivo devices refers to phone_brand = 'vivo';
SQL: SELECT COUNT(T1.device_id) FROM phone_brand_device_model2 AS T1 INNER JOIN events AS T2 ON T2.device_id = T1.device_id WHERE T1.phone_brand = 'vivo' AND T2.event_id = 2

Database: law_episode
Question: What role does the tallest person play?
Evidence: the tallest refers to max(height_meters)
SQL: SELECT T2.role FROM Person AS T1 INNER JOIN Credit AS T2 ON T1.person_id = T2.person_id INNER JOIN Award AS T3 ON T2.episode_id = T3.episode_id ORDER BY T1.height_meters DESC LIMIT 1

Database: movie_3
Question: What is the language for film titled "CHILL LUCK"?
SQL: SELECT T2.`name` FROM film AS T1 INNER JOIN `language` AS T2 ON T1.language_id = T2.language_id WHERE T1.title = 'CHILL LUCK'

Database: image_and_language
Question: On image no. 99 identify the percentage of objects that are described as white.
Evidence: image no. 99 refers to IMG_ID = 99; described as white refers to ATT_CLASS = 'white'; percentage = divide(count(OBJ_SAMPLE_ID) where ATT_CLASS = 'white', count(OBJ_SAMPLE_ID)) as percentage
SQL: SELECT CAST(SUM(CASE WHEN T2.ATT_CLASS = 'white' THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(OBJ_SAMPLE_ID) FROM IMG_OBJ_ATT AS T1 INNER JOIN ATT_CLASSES AS T2 ON T1.ATT_CLASS_ID = T2.ATT_CLASS_ID WHERE T1.IMG_ID = 99

Database: authors
Question: Show the keywords of the paper that was presented at "International Radar Symposium" in 2012.
Evidence: 'International Radar Symposium' is the FullName of the conference; 2012 refers to Year = '2012'
SQL: SELECT T1.Keyword FROM Paper AS T1 INNER JOIN Conference AS T2 ON T1.ConferenceId = T2.Id WHERE T2.FullName = 'International Radar Symposium' AND T1.Year = 2012

Database: beer_factory
Question: Among the customers not subscribed to the mailing list, what percentage has given three or more stars in a review?
Evidence: not subscribed to the mailing list refers to SubscribedToEmailList = 'FALSE'; percentage = MULTIPLY(DIVIDE(SUM(CustomerID WHERE StarRating > 3), COUNT(CustomerID) WHERE SubscribedToEmailList = 'FALSE'), 1.0);
SQL: SELECT CAST(COUNT(CASE WHEN T2.StarRating > 3 THEN 1 ELSE NULL END) AS REAL) * 100 / COUNT(T2.CustomerID) FROM customers AS T1 INNER JOIN rootbeerreview AS T2 ON T1.CustomerID = T2.CustomerID WHERE T1.SubscribedToEmailList = 'FALSE'

Database: shipping
Question: List out the state of driver who transported the shipment id 1055.
Evidence: shipment id 1055 refers to ship_id = 1055
SQL: SELECT T2.state FROM shipment AS T1 INNER JOIN driver AS T2 ON T1.driver_id = T2.driver_id WHERE T1.ship_id = '1055'

Database: retail_world
Question: Give the phone number of the customer who placed the order id 10264.
SQL: SELECT T1.Phone FROM Customers AS T1 INNER JOIN Orders AS T2 ON T1.CustomerID = T2.CustomerID WHERE T2.OrderID = 10264