Database: menu
Question: Please list the IDs of all the menus that are DIYs of the restaurant.
Evidence: menus that are DIYs of the restaurant refers to sponsor is null;
SQL: SELECT id FROM Menu WHERE sponsor IS NULL

Database: public_review_platform
Question: Which year has the most elite users?
Evidence: year has the most elite users refers to year_id with MAX(user_id);
SQL: SELECT year_id FROM Elite GROUP BY year_id ORDER BY COUNT(user_id) DESC LIMIT 1

Database: world
Question: What city in Russia has the least population?
Evidence: Russia is a name of country; least population refers to MIN(Population);
SQL: SELECT T2.Name FROM Country AS T1 INNER JOIN City AS T2 ON T1.Code = T2.CountryCode WHERE T1.Name = 'Russian Federation' ORDER BY T2.Population ASC LIMIT 1

Database: movie_3
Question: Tell me the title of the film in which Sandra Kilmer is one of the actors.
SQL: SELECT T3.title FROM film_actor AS T1 INNER JOIN actor AS T2 ON T1.actor_id = T2.actor_id INNER JOIN film AS T3 ON T1.film_id = T3.film_id WHERE T2.first_name = 'SANDRA' AND T2.last_name = 'KILMER'

Database: law_episode
Question: Among the episodes that were aired in 1998, how many won an International Monitor Awards?
Evidence: aired in 1998 refers to air_date like '1998%'; won refers to result = 'Winner'; International Monitor Awards refers to organization = 'International Monitor Awards'
SQL: SELECT COUNT(T1.episode_id) FROM Episode AS T1 INNER JOIN Award AS T2 ON T1.episode_id = T2.episode_id WHERE strftime('%Y', T1.air_date) = '1998' AND T2.organization = 'International Monitor Awards' AND T2.result = 'Winner'

Database: retail_world
Question: What is the average sales for each categories?
Evidence: average sales = AVG(ProductSales)
SQL: SELECT AVG(ProductSales) FROM `Sales by Category` GROUP BY CategoryName

Database: video_games
Question: Name of the publisher of the game id 10031.
Evidence: name of publisher refers to publisher_name; the game id 10031 refers to game_id = '10031'
SQL: SELECT T2.publisher_name FROM game_publisher AS T1 INNER JOIN publisher AS T2 ON T1.publisher_id = T2.id WHERE T1.game_id = 10031

Database: bike_share_1
Question: What is the name of the station that is less used by customers who borrow bikes from? Indicate when was the station installed.
Evidence: less used station where bikes are borrowed from refers to start_station_name which has the least number of customers; subscription_type = 'Customer'; when installed refers to installation_date;
SQL: SELECT T1.start_station_name, T2.installation_date FROM trip AS T1 INNER JOIN station AS T2 ON T2.name = T1.start_station_name WHERE T1.subscription_type = 'Customer' GROUP BY T1.start_station_name ORDER BY COUNT(T1.subscription_type) LIMIT 1

Database: car_retails
Question: For the planes which has the hightest total price, how much it exceeds the average?
Evidence: plane is a product line; total price = MULTIPLY(quantityOrdered, priceEach); how much the total price exceeds the average = SUBTRACT(MAX(MULTIPLY(quantityOrdered, priceEach))), AVG(priceEach));
SQL: SELECT MAX(quantityOrdered * priceEach) - AVG(priceEach) FROM orderdetails WHERE productCode IN ( SELECT productCode FROM products WHERE productLine = 'Planes' )

Database: cs_semester
Question: How many students have the highest intelligence among those taking a bachelor's degree?
Evidence: bachelor's degree is an undergraduate degree in which type = 'UG'; the highest intelligence refers to MAX(intelligence);
SQL: SELECT COUNT(student_id) FROM student WHERE type = 'UG' AND intelligence = ( SELECT MAX(intelligence) FROM student )

Database: movie_platform
Question: What is the percentage of the ratings were rated by user who was a subcriber?
Evidence: user is a subscriber refers to user_subscriber = 1; percentage of ratings = DIVIDE(SUM(user_subscriber = 1), SUM(rating_score)) as percent;
SQL: SELECT CAST(SUM(CASE WHEN user_subscriber = 1 THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(*) FROM ratings

Database: language_corpus
Question: Which word has the most repetitions in the Catalan language?
Evidence: the most repetitions refer to MAX(occurrences); Catalan language refers to lid = 1;
SQL: SELECT T2.word FROM langs_words AS T1 INNER JOIN words AS T2 ON T1.wid = T2.wid WHERE T1.occurrences = ( SELECT MAX(occurrences) FROM langs_words )

Database: chicago_crime
Question: What is the name of the district with the highest number of domestic violence cases?
Evidence: domestic violence refers to domestic = 'TRUE'; highest number of case refers to Max(Count(district_no)); name of district refers to distric_name
SQL: SELECT T2.district_name FROM Crime AS T1 INNER JOIN District AS T2 ON T1.district_no = T2.district_no WHERE T1.domestic = 'TRUE' GROUP BY T2.district_name ORDER BY COUNT(T1.district_no) DESC LIMIT 1

Database: car_retails
Question: How many orders which expected profits greater than 100?
Evidence: expected profits greater than 100 = (SUBTRACT(msrp, buyPrice))>100;
SQL: SELECT COUNT(T1.productCode) FROM orderdetails AS T1 INNER JOIN products AS T2 ON T1.productCode = T2.productCode WHERE T2.MSRP - T2.buyPrice > 100

Database: food_inspection_2
Question: Provide the names and inspection results of the facilities located in Burnham.
Evidence: names refers to dba_name; inspection result refers to results; in Burnham refers to city = 'BURNHAM'
SQL: SELECT DISTINCT T1.dba_name, T2.results FROM establishment AS T1 INNER JOIN inspection AS T2 ON T1.license_no = T2.license_no WHERE T1.city = 'BURNHAM'

Database: public_review_platform
Question: Which user has done the most review on a business attributed to delivery?
Evidence: the most reviews refer to MAX(business_id) where attribute_name = 'Delivery';
SQL: SELECT T3.user_id FROM Attributes AS T1 INNER JOIN Business_Attributes AS T2 ON T1.attribute_id = T2.attribute_id INNER JOIN Reviews AS T3 ON T2.business_id = T3.business_id WHERE T1.attribute_name = 'Delivery' GROUP BY T3.user_id ORDER BY COUNT(T2.business_id) DESC LIMIT 1

Database: image_and_language
Question: How many object elements can be detected on image no. 31?
Evidence: How many object elements refers to OBJ_CLASS_ID; image no. 31 refers to IMG_ID = 31
SQL: SELECT COUNT(OBJ_CLASS_ID) FROM IMG_OBJ WHERE IMG_ID = 31

Database: image_and_language
Question: What is the average difference in the y coordinate of 2 object samples with the relation "parked on" in image no.1?
Evidence: relation "parked on" refers to PRED_CLASS = 'parked on'; image no.1 refers to IMG_ID = 1; average difference in the y coordinate = divide(sum(Y), count(PRED_CLASS)) where OBJ1_SAMPLE_ID ! = OBJ2_SAMPLE_ID
SQL: SELECT CAST(SUM(T3.Y) AS REAL) / COUNT(CASE WHEN T1.PRED_CLASS = 'parked on' THEN 1 ELSE NULL END) FROM PRED_CLASSES AS T1 INNER JOIN IMG_REL AS T2 ON T1.PRED_CLASS_ID = T2.PRED_CLASS_ID INNER JOIN IMG_OBJ AS T3 ON T2.OBJ1_SAMPLE_ID = T3.OBJ_CLASS_ID WHERE T2.IMG_ID = 1 AND T2.OBJ1_SAMPLE_ID != T2.OBJ2_SAMPLE_ID

Database: student_loan
Question: What is the school and organization enrolled by student211?
Evidence: organization refers to organ; student211 is a name of student;
SQL: SELECT T2.school, T1.organ FROM enlist AS T1 INNER JOIN enrolled AS T2 ON T2.name = T1.name WHERE T1.name = 'student211'

Database: movie_3
Question: How many of the actors are named "Dan"?
Evidence: 'Dan' is a first_name of an actor
SQL: SELECT COUNT(actor_id) FROM actor WHERE first_name = 'Dan'

Database: shakespeare
Question: How many chapters have the name Gratiano as a character for "friend to Antonio and Bassiano"?
Evidence: name Gratiano as a character refers to CharName = 'Gratiano'; "friend to Antonio and Bassiano" refers to characters.Description = 'friend to Antonio and Bassiano'
SQL: SELECT COUNT(DISTINCT T2.chapter_id) FROM characters AS T1 INNER JOIN paragraphs AS T2 ON T1.id = T2.character_id WHERE T1.CharName = 'Gratiano' AND T1.Description = 'friend to Antonio and Bassiano'