Database: college_completion
Question: Among the Ivy League Schools, which school have the highest number of Hispanic graduates of all time?
Evidence: Ivy League Schools refers to chronname = 'Brown University' or chronname = 'Columbia University' or chronname = 'Cornell University' or chronname = 'Dartmouth College' or chronname = 'Harvard University' or chronname = 'Princeton University' or chronname = 'University of Pennsylvania' or chronname = 'Yale University'; highest number of hispanic graduates refers to MAX(grad_cohort WHERE race = 'H');
SQL: SELECT T1.chronname FROM institution_details AS T1 INNER JOIN institution_grads AS T2 ON T2.unitid = T1.unitid WHERE T1.chronname IN ( 'Brown University', 'Columbia University', 'Cornell University', 'Dartmouth College', 'Harvard University', 'Princeton University', 'University of Pennsylvania', 'Yale University' ) AND T2.race = 'H' GROUP BY T1.chronname ORDER BY SUM(T2.grad_cohort) DESC LIMIT 1

Database: sales_in_weather
Question: Tell the temperature range of the home weather station of store no.7 on 2014/4/28.
Evidence: store no.7 refers to tore_nbr = 7; on 2014/4/28 refers to date = '2014-04-28'; temperature range refers to Subtract (tmax, tmin)
SQL: SELECT T1.tmax - T1.tmin AS temprange FROM weather AS T1 INNER JOIN relation AS T2 ON T1.station_nbr = T2.station_nbr WHERE T2.store_nbr = 7 AND T1.`date` = '2014-04-28'

Database: world_development_indicators
Question: How many countries in Europe & Central Asia uses Danish krone as its currency? List the full names of those coutnries.
Evidence: countries in Europe & Central Asia refer to region = 'Europe & Central Asia'; uses Danish krone refers to currencyunit = 'Danish krone'; full name refers to longname
SQL: SELECT COUNT(longname) FROM country WHERE region = 'Europe & Central Asia' AND currencyunit = 'Danish krone' UNION SELECT longname FROM country WHERE currencyunit = 'Danish krone' AND region = 'Europe & Central Asia'

Database: retail_world
Question: State the shipping company of order id 10260.
Evidence: shipping company refers to CompanyName
SQL: SELECT T2.CompanyName FROM Orders AS T1 INNER JOIN Shippers AS T2 ON T1.ShipVia = T2.ShipperID WHERE T1.OrderID = 10260

Database: legislator
Question: Which current legislator is older, Sherrod Brown or Maria Cantwell?
Evidence: older refers to MAX(birthday_bio); 'Sherrod Brown' and 'Maria Cantwell' are official_full_name
SQL: SELECT official_full_name FROM current WHERE official_full_name = 'Sherrod Brown' OR official_full_name = 'Maria Cantwell' ORDER BY birthday_bio LIMIT 1

Database: language_corpus
Question: Calculate the average of repetitions in the pages that have a total of 100 different words.
Evidence: Repetition refers to occurrences; 100 different words refers to words = 100; DIVIDE(SUM(occurrences where words = 100), COUNT(page where words = 100)) as percentage;
SQL: SELECT CAST(SUM(T2.occurrences) AS REAL) / COUNT(T1.page) FROM pages AS T1 INNER JOIN pages_words AS T2 ON T1.pid = T2.pid WHERE T1.words = 100

Database: chicago_crime
Question: How many crimes had happened in Central Chicago?
Evidence: Central Chicago refers to district_name = 'Central'
SQL: SELECT COUNT(*) FROM Crime AS T1 INNER JOIN District AS T2 ON T1.district_no = T2.district_no WHERE T2.district_name = 'Central'

Database: chicago_crime
Question: Give the name of the person who was responsible for case No.JB524952.
Evidence: name of the person refers to commander; case No.JB524952 refers to case_number = 'JB524952'
SQL: SELECT T1.commander FROM District AS T1 INNER JOIN Crime AS T2 ON T1.district_no = T2.district_no WHERE T2.case_number = 'JB524952'

Database: movie_3
Question: Please list three types of film along with their IDs and the latest update.
Evidence: types of film refers to the name of a category; IDs refers to category_id; latest update refers to last_update.
SQL: SELECT DISTINCT name, category_id, last_update FROM category LIMIT 3

Database: ice_hockey_draft
Question: Who had the most assists of team Plymouth Whalers in the 1999-2000 season?
Evidence: who refers to PlayerName; most assists refers to MAX(A); team Plymouth Whalers refers to TEAM = 'Plymouth Whalers'; 1999-2000 season refers to SEASON = '1999-2000';
SQL: SELECT T1.PlayerName FROM PlayerInfo AS T1 INNER JOIN SeasonStatus AS T2 ON T1.ELITEID = T2.ELITEID WHERE T2.TEAM = 'Plymouth Whalers' AND T2.SEASON = '1999-2000' ORDER BY T2.A DESC LIMIT 1

Database: public_review_platform
Question: Please list the cities of the Yelp_Businesses that have gotten a 5 in the Elitestar rating.
Evidence: 5 in the Elitestar rating refers to stars = 5;
SQL: SELECT city FROM Business WHERE stars = 5 GROUP BY city

Database: menu
Question: Please list the page numbers of all the menu pages on which the dish "Chicken gumbo" had appeared.
Evidence: Chicken gumbo is a name of dish;
SQL: SELECT T1.page_number FROM MenuPage AS T1 INNER JOIN MenuItem AS T2 ON T1.id = T2.menu_page_id INNER JOIN Dish AS T3 ON T2.dish_id = T3.id WHERE T3.name = 'Chicken gumbo'

Database: donor
Question: For each donation not from a teacher, state the donor account id and calculate the percentage of donation given for optional support.
Evidence: not from a teacher refers to is_teacher_acct = 'f'; donor account id refers to donor_acctid; percentage of donation = divide(donation_optional_support, donation_total)*100%
SQL: SELECT donor_acctid, donation_optional_support / donation_total FROM donations WHERE is_teacher_acct = 'f'

Database: olympics
Question: What is the average weight of the competitors who won a silver medal?
Evidence: AVG(weight) where medal_name = 'Silver';
SQL: SELECT AVG(T1.weight) FROM person AS T1 INNER JOIN games_competitor AS T2 ON T1.id = T2.person_id INNER JOIN competitor_event AS T3 ON T2.id = T3.competitor_id INNER JOIN medal AS T4 ON T3.medal_id = T4.id WHERE T4.medal_name = 'Silver'

Database: regional_sales
Question: How much is the discount applied to the order with the highest unit price?
Evidence: highest unit price refers to Max(Unit Price)
SQL: SELECT `Discount Applied` FROM `Sales Orders` WHERE REPLACE(`Unit Price`, ',', '') = ( SELECT REPLACE(`Unit Price`, ',', '') FROM `Sales Orders` ORDER BY REPLACE(`Unit Price`, ',', '') DESC LIMIT 1 ) ORDER BY REPLACE(`Unit Price`, ',', '') DESC LIMIT 1

Database: image_and_language
Question: Calculate the percentage of object samples that are related to street lights.
Evidence: DIVIDE(COUNT(OBJ_SAMPLE_ID where OBJ_CLASS = 'street lights'), COUNT(OBJ_SAMPLE_ID)) as percentage;
SQL: SELECT CAST(SUM(CASE WHEN T2.OBJ_CLASS = 'street lights' THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(T1.OBJ_SAMPLE_ID) FROM IMG_OBJ AS T1 INNER JOIN OBJ_CLASSES AS T2 ON T1.OBJ_CLASS_ID = T2.OBJ_CLASS_ID

Database: regional_sales
Question: List all orders where its products were shipped from Daly City.
Evidence: shipped from Daly City refers to Store Locations where City Name = 'Daly City'; orders refer to OrderNumber;
SQL: SELECT T FROM ( SELECT DISTINCT CASE  WHEN T2.`City Name` = 'Daly City' THEN T1.OrderNumber END AS T FROM `Sales Orders` T1 INNER JOIN `Store Locations` T2 ON T2.StoreID = T1._StoreID ) WHERE T IS NOT NULL

Database: regional_sales
Question: How many stores with less need for products, and purchased through a distributor, are located in Washtenaw County?
Evidence: less need for products refers to Order Quantity = 1; purchased through a distributor refers to Sales Channel = 'Distributor'; 'Harri County' is the County
SQL: SELECT SUM(CASE WHEN T1.`Order Quantity` = 1 AND T1.`Sales Channel` = 'Distributor' AND T2.County = 'Washtenaw County' THEN 1 ELSE 0 END) FROM `Sales Orders` AS T1 INNER JOIN `Store Locations` AS T2 ON T2.StoreID = T1._StoreID