Database: shakespeare
Question: What is the description of chapter 18704, where there is a character called Orsino?
Evidence: chapter 18704 refers to chapters.id = 18704; character called Orsino refers to CharName = 'Orsino'
SQL: SELECT DISTINCT T3.Description FROM characters AS T1 INNER JOIN paragraphs AS T2 ON T1.id = T2.character_id INNER JOIN chapters AS T3 ON T2.chapter_id = T3.id WHERE T1.CharName = 'Orsino' AND T3.ID = 18704

Database: retails
Question: What is the supply cost of large plated tin?
Evidence: supply cost refers to ps_supplycost; large plated tin refers to p_type = 'large plated tin'
SQL: SELECT T2.ps_supplycost FROM part AS T1 INNER JOIN partsupp AS T2 ON T1.p_partkey = T2.ps_partkey WHERE T1.p_type = 'large plated tin'

Database: food_inspection_2
Question: For the grocery store located at "3635 W DIVERSEY AVE", how many inspections did it have?
Evidence: grocery store refers to facility_type = 'Grocery Store'; "3635 W DIVERSEY AVE" refers to address = '3635 W DIVERSEY AVE'
SQL: SELECT COUNT(T2.inspection_id) FROM establishment AS T1 INNER JOIN inspection AS T2 ON T1.license_no = T2.license_no WHERE T1.address = '3635 W DIVERSEY AVE ' AND T1.facility_type = 'Grocery Store'

Database: public_review_platform
Question: Find the location of businesses that have business hours from 8 am to 9 pm every Friday.
Evidence: location of businesses refers to city and state; business hours from 8 am to 9 pm refers to opening_time = '8AM', closing_time = '9PM'; every Friday refers to day_of_week = 'Friday'
SQL: SELECT T1.city FROM Business AS T1 INNER JOIN Business_Hours AS T2 ON T1.business_id = T2.business_id INNER JOIN Days AS T3 ON T2.day_id = T3.day_id WHERE T2.closing_time LIKE '9PM' AND T2.opening_time LIKE '8AM' AND T3.day_of_week LIKE 'Friday' GROUP BY T1.city

Database: video_games
Question: How many strategy games are there?
Evidence: strategy games refers game_name WHERE genre_name = 'Strategy';
SQL: SELECT COUNT(CASE WHEN T1.genre_name = 'Strategy' THEN T2.id ELSE NULL END) FROM genre AS T1 INNER JOIN game AS T2 ON T1.id = T2.genre_id

Database: codebase_comments
Question: What is the github address of the solution path "joeyrobert_bloomfilter\DataTypes.BloomFilter.sln"?
Evidence: github address refers to Url; solution path refers to Path; Path = 'joeyrobert_bloomfilter\DataTypes.BloomFilter.sln';
SQL: SELECT T1.Url FROM Repo AS T1 INNER JOIN Solution AS T2 ON T1.Id = T2.RepoId WHERE T2.Path = 'joeyrobert_bloomfilterDataTypes.BloomFilter.sln'

Database: olympics
Question: How many Olympic Games has London hosted?
Evidence: London refers to city_name = 'London';
SQL: SELECT COUNT(T3.id) FROM games_city AS T1 INNER JOIN city AS T2 ON T1.city_id = T2.id INNER JOIN games AS T3 ON T1.games_id = T3.id WHERE T2.city_name = 'London'

Database: soccer_2016
Question: List the over IDs, ball IDs, and innings numbers of the match ID "336004" while the batsman got the maximum scores.
Evidence: over ID refers to Over_Id; ball ID refers to Ball_Id; innings number refers to Innings_No; match ID "336004" refers to Match_Id = 336004; batsman got the maximum scores refers to max(Runs_Scored)
SQL: SELECT Over_Id, Ball_Id, Innings_No FROM Batsman_Scored WHERE Match_Id = 336004 ORDER BY Runs_Scored DESC LIMIT 1

Database: disney
Question: Provide the titles, main characters, and associated songs of the movies directed by Wolfgang Reitherman in 1977.
Evidence: Wolfgang Reitherman refers to director = 'Wolfgang Reitherman'; 1997 refers to substr(release_date, length(release_date) - 3, length(release_date)) = '1977'; the titles refer to movie_title; main characters refer to hero;
SQL: SELECT T1.movie_title, T2.hero, T2.song FROM movies_total_gross AS T1 INNER JOIN characters AS T2 ON T1.movie_title = T2.movie_title INNER JOIN director AS T3 ON T1.movie_title = T3.name WHERE T3.director = 'Wolfgang Reitherman' AND SUBSTR(T1.release_date, LENGTH(T1.release_date) - 3, LENGTH(T1.release_date)) = '1977'

Database: coinmarketcap
Question: What is the name of the coin with the highest price?
Evidence: the highest price refers to max(price)
SQL: SELECT T1.name FROM coins AS T1 INNER JOIN historical AS T2 ON T1.id = T2.coin_id WHERE T2.price = ( SELECT MAX(price) FROM historical )

Database: video_games
Question: Calculate the total sales made by the games released in 2000.
Evidence: total sales = SUM(num_sales); released in 2000 refers to release_year = 2000;
SQL: SELECT SUM(T1.num_sales) FROM region_sales AS T1 INNER JOIN game_platform AS T2 ON T1.game_platform_id = T2.id WHERE T2.release_year = 2000

Database: legislator
Question: How many females were members of the past legislators?
Evidence: female refers to gender_bio = 'F'
SQL: SELECT COUNT(*) FROM historical WHERE gender_bio = 'F'

Database: food_inspection_2
Question: Which employee was responsible for inspection no.48224? Give the full name.
Evidence: inspection no.48224 refers to inspection_id = '48224'; full name refers to first_name, last_name;
SQL: SELECT T2.first_name, T2.last_name FROM inspection AS T1 INNER JOIN employee AS T2 ON T1.employee_id = T2.employee_id WHERE T1.inspection_id = 48224

Database: regional_sales
Question: Please give the order number and product name of the order which has the lowest unit price.
Evidence: the lowest unit price refers to MIN(Unit Price);
SQL: SELECT T1.OrderNumber, T2.`Product Name` FROM `Sales Orders` AS T1 INNER JOIN Products AS T2 ON T2.ProductID = T1._ProductID WHERE REPLACE(T1.`Unit Price`, ',', '') = ( SELECT REPLACE(T1.`Unit Price`, ',', '') FROM `Sales Orders` AS T1 INNER JOIN Products AS T2 ON T2.ProductID = T1._ProductID ORDER BY REPLACE(T1.`Unit Price`, ',', '') LIMIT 1 )

Database: retail_complains
Question: For all the complaint callers on 2017/3/27, what percentage of the clients are females?
Evidence: on 2017/3/27 refers to "Date received" = '2017-03-27'; percentage = MULTIPLY(DIVIDE(SUM(sex = 'Female' ), COUNT(client_id)), 1.0); females refers to sex = 'Female';
SQL: SELECT CAST(SUM(CASE WHEN T1.sex = 'Female' THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(T1.sex) FROM client AS T1 INNER JOIN events AS T2 ON T1.client_id = T2.Client_ID WHERE T2.`Date received` = '2017-03-27'

Database: sales_in_weather
Question: What is the ID of the item that sold the best on the day with the highest max temperature in store no.3 in 2012?
Evidence: highest max temperature refers to Max(tmax); store no.3 refers to store_nbr = 3; in 2012 refers to substring (date, 1, 4) = '2012'; sold the best refers to Max(units); ID of the item refers to item_nbr
SQL: SELECT T1.item_nbr FROM sales_in_weather AS T1 INNER JOIN relation AS T2 ON T1.store_nbr = T2.store_nbr INNER JOIN weather AS T3 ON T2.station_nbr = T3.station_nbr WHERE T1.store_nbr = 3 AND T1.`date` LIKE '%2012%' AND tmax = ( SELECT MAX(tmax) FROM sales_in_weather AS T1 INNER JOIN relation AS T2 ON T1.store_nbr = T2.store_nbr INNER JOIN weather AS T3 ON T2.station_nbr = T3.station_nbr WHERE T1.store_nbr = 3 AND T1.`date` LIKE '%2012%' ) GROUP BY T1.item_nbr ORDER BY SUM(units) DESC LIMIT 1

Database: airline
Question: How many flights departed on time on 8/1/2018?
Evidence: departed on time refers to DEP_DELAY < = 0; on 8/1/2018 refers to FL_DATE = '2018/8/1';
SQL: SELECT COUNT(*) FROM Airlines WHERE FL_DATE = '2018/8/1' AND DEP_DELAY <= 0

Database: menu
Question: Please list the names of all the dishes on page 1 of menu ID12882.
Evidence: page 1 refers to page_number = 1;
SQL: SELECT T3.name 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 T1.menu_id = 12882 AND T1.page_number = 1

Database: book_publishing_company
Question: What is the publisher that has published the most expensive book?
Evidence: most expensive book refers to MAX(price)
SQL: SELECT T2.pub_name FROM titles AS T1 INNER JOIN publishers AS T2 ON T1.pub_id = T2.pub_id ORDER BY T1.price DESC LIMIT 1