Database: sales_in_weather
Question: Give the average temperature of station no.20 on 2014/10/17.
Evidence: station no.20 refers to station_nbr = 20; on 2014/10/17 refers to date = '2014-10-17'; average temperature refers to tavg
SQL: SELECT tavg FROM weather WHERE `date` = '2014-10-17' AND station_nbr = 20

Database: movie
Question: How many movies has the highest networth actor acted in?
Evidence: highest networth refers to max(networth)
SQL: SELECT COUNT(*) FROM characters AS T1 INNER JOIN actor AS T2 ON T1.ActorID = T2.ActorID WHERE CAST(REPLACE(REPLACE(T2.NetWorth, ',', ''), '$', '') AS REAL) = ( SELECT MAX(CAST(REPLACE(REPLACE(NetWorth, ',', ''), '$', '') AS REAL)) FROM actor)

Database: public_review_platform
Question: How many businesses are actively running in Gilbert City?
Evidence: actively running refers to active = 'true';
SQL: SELECT COUNT(business_id) FROM Business WHERE city LIKE 'Gilbert' AND active LIKE 'True'

Database: disney
Question: Provide the movie titles and the estimated inflation rate of the highest total grossed movie.
Evidence: The highest grossed movie refers to MAX(total_gross); DIVIDE(inflation_adjusted_gross, total_gross) as percentage;
SQL: SELECT movie_title, CAST(REPLACE(trim(inflation_adjusted_gross, '$'), ',', '') AS REAL) / CAST(REPLACE(trim(total_gross, '$'), ',', '') AS REAL) FROM movies_total_gross ORDER BY CAST(REPLACE(trim(total_gross, '$'), ',', '') AS REAL) DESC LIMIT 1

Database: movie_platform
Question: What is the URL to the rating on Mubi of the Riff-Raff movie that was given the highest rating score by user 22030372?
Evidence: URL refer to rating_url; user 22030372 refer to user_id
SQL: SELECT T2.rating_url FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T2.user_id = 22030372 AND T2.rating_score = 5 AND T1.movie_title = 'Riff-Raff'

Database: image_and_language
Question: Define the onion's bounding box on image no. 285930.
Evidence: bounding box refers to (X, Y, W, H); onion refers to OBJ_CLASS = 'onion'; image no.285930 refers to IMG_ID = 285930
SQL: SELECT T1.X, T1.Y, T1.W, T1.H FROM IMG_OBJ AS T1 INNER JOIN OBJ_CLASSES AS T2 ON T1.OBJ_CLASS_ID = T2.OBJ_CLASS_ID WHERE T1.IMG_ID = 285930 AND T2.OBJ_CLASS = 'onion'

Database: car_retails
Question: List the product code of the top five motorcycles, by descending order, the number of quantity in stock.
Evidence: motorcycle is a product line;
SQL: SELECT productCode, quantityInStock FROM products WHERE productLine = 'Motorcycles' ORDER BY quantityInStock DESC LIMIT 5

Database: image_and_language
Question: What is the prediction class between object class 'chain' and 'label' in image 2360078?
Evidence: prediction class refers to PRED_CLASS; object class 'chain' refers to OBJ_CLASS = 'chain'; object class 'label' refers to OBJ_CLASS = 'label'; image 2360078 refers to IMG_ID = 2360078;
SQL: SELECT DISTINCT T2.PRED_CLASS FROM IMG_REL AS T1 INNER JOIN PRED_CLASSES AS T2 ON T2.PRED_CLASS_ID = T1.PRED_CLASS_ID INNER JOIN IMG_OBJ AS T3 ON T1.IMG_ID = T3.IMG_ID AND T1.OBJ1_SAMPLE_ID = T3.OBJ_SAMPLE_ID INNER JOIN OBJ_CLASSES AS T4 ON T3.OBJ_CLASS_ID = T4.OBJ_CLASS_ID WHERE T1.IMG_ID = 2360078 AND T1.OBJ1_SAMPLE_ID = 15 OR T1.OBJ2_SAMPLE_ID = 18

Database: simpson_episodes
Question: What is the title of the episode that received the lowest rating?
Evidence: lowest rating refers to Min(rating)
SQL: SELECT title FROM Episode ORDER BY rating LIMIT 1;

Database: cars
Question: Provide the price of the only Toyota Corona hardtop in the database.
Evidence: Toyota Corona hardtop refers to car_name = 'toyota corona hardtop'
SQL: SELECT T2.price FROM data AS T1 INNER JOIN price AS T2 ON T1.ID = T2.ID WHERE T1.car_name = 'toyota corona hardtop'

Database: video_games
Question: What are the years that "WiiU" got a new game?
Evidence: year refers to release_year; "WiiU" refers to platform_name = 'WiiU'
SQL: SELECT T2.release_year FROM platform AS T1 INNER JOIN game_platform AS T2 ON T1.id = T2.platform_id WHERE T1.platform_name = 'WiiU' ORDER BY T2.release_year DESC LIMIT 1

Database: chicago_crime
Question: How many neighborhoods can be found in the Forest Glen community area?
Evidence: "Forest Glen" is the community_area_name; neighborhoods refers to neighborhood_name
SQL: SELECT SUM(CASE WHEN T2.community_area_name = 'Forest Glen' THEN 1 ELSE 0 END) FROM Neighborhood AS T1 INNER JOIN Community_Area AS T2 ON T1.community_area_no = T2.community_area_no

Database: cs_semester
Question: Give the phone number of the only student who obtained "A" in the course "Intro to BlockChain".
Evidence: A refers to an excellent grade in which grade = 'A' for the course;
SQL: SELECT T1.phone_number FROM student AS T1 INNER JOIN registration AS T2 ON T1.student_id = T2.student_id INNER JOIN course AS T3 ON T2.course_id = T3.course_id WHERE T3.name = 'Intro to BlockChain' AND T2.grade = 'A'

Database: professional_basketball
Question: Please list the top five players with the most steals in the year 1997. Please give their full name.
Evidence: full name refers to firstName, middleName, lastName; in the year 1997 refers to year = 1997; the most steals refers to max(steals)
SQL: SELECT DISTINCT T1.firstName, T1.middleName, T1.lastName FROM players AS T1 INNER JOIN player_allstar AS T2 ON T1.playerID = T2.playerID WHERE T2.season_id = 1997 ORDER BY T2.steals DESC LIMIT 5

Database: college_completion
Question: Give the post name of "Idaho" state.
Evidence: post name refers to state_post;
SQL: SELECT T FROM ( SELECT DISTINCT CASE WHEN state = 'Idaho' THEN state_post ELSE NULL END AS T FROM state_sector_details ) WHERE T IS NOT NULL

Database: movie_platform
Question: Please provide the ID of the user with the most followers on the list.
Evidence: most followers refers to Max(list_followers);
SQL: SELECT user_id FROM lists ORDER BY list_followers DESC LIMIT 1

Database: language_corpus
Question: List down the words with word id from 1 to 10 and write down a paired word for each of them.
Evidence: word id from 1 to 10 refers to wid BETWEEN 1 AND 10
SQL: SELECT T1.word AS W1, T3.word AS W2 FROM words AS T1 LEFT JOIN biwords AS T2 ON T1.wid = T2.w1st LEFT JOIN words AS T3 ON T3.wid = T2.w2nd WHERE T1.wid <= 10 GROUP BY T1.wid

Database: retails
Question: What is the average price before discount of the top 10 orders with the highest total price?
Evidence: DIVIDE(SUM(l_extendedprice), 10) where MAX(o_totalprice);
SQL: SELECT SUM(T2.l_extendedprice) / 10 FROM orders AS T1 INNER JOIN lineitem AS T2 ON T1.o_orderkey = T2.l_orderkey ORDER BY T1.o_totalprice DESC LIMIT 10

Database: food_inspection_2
Question: After Azha Restaurant Inc. passed the inspection on 2010/1/21, when was the follow-up inspection done?
Evidence: Azha Restaurant Inc. refers to dba_name = 'Azha Restaurant Inc.'; on 2010/1/21 refers to inspection_date = '2010-01-21'; follow-up inspection date refers to followup_to
SQL: SELECT T1.followup_to FROM inspection AS T1 INNER JOIN establishment AS T2 ON T1.license_no = T2.license_no WHERE T2.dba_name = 'Azha Restaurant Inc.' AND T1.results = 'Pass' AND T1.inspection_date = '2010-01-21'

Database: public_review_platform
Question: What is the active and inactive ratio of the business with the review count of low.
Evidence: DIVIDE(COUNT(business_id where review_count = 'Low' and active = 'true'), COUNT(business_id where review_count = 'Low' and active = 'false'));
SQL: SELECT CAST(SUM(CASE WHEN active = 'true' THEN 1 ELSE 0 END) AS REAL) / SUM(CASE WHEN active = 'false' THEN 1 ELSE 0 END) AS radio FROM Business WHERE review_count = 'Low'

Database: soccer_2016
Question: What are the names of the venues in Abu Dhabi?
Evidence: names of the venues refers to Venue_Name; Abu Dhabi refers to City_Name = 'Abu Dhabi'
SQL: SELECT T1.Venue_Name FROM Venue AS T1 INNER JOIN City AS T2 ON T1.City_Id = T2.City_Id WHERE T2.City_Name = 'Abu Dhabi'