Database: coinmarketcap
Question: When did Bitcoin reach its highest price on 2013/4/29?
Evidence: time that a coin reaches its highest price refers to time_high; on 2013/4/29 refers to date = '2013-04-29'
SQL: SELECT T2.time_high FROM coins AS T1 INNER JOIN historical AS T2 ON T1.id = T2.coin_id WHERE T2.date = '2013-04-29' AND T1.name = 'Bitcoin'

Database: simpson_episodes
Question: What is the voting numbers and percentage of the best rating scale of the episode which had keyword of "arab stereotype"?
Evidence: best rating scale refers to stars = 10
SQL: SELECT T2.votes, T2.percent FROM Keyword AS T1 INNER JOIN Vote AS T2 ON T1.episode_id = T2.episode_id WHERE T1.keyword = 'arab stereotype' AND T2.stars = 10;

Database: human_resources
Question: Which positions are suitable with 4 years degree education?
Evidence: 4 years degree education refers to educationrequired = '4 year degree'; positions refers to positiontitle
SQL: SELECT positiontitle FROM position WHERE educationrequired = '4 year degree'

Database: movie_3
Question: Which city does the address 1623 Kingstown Drive belong to?
SQL: SELECT T1.city FROM city AS T1 INNER JOIN address AS T2 ON T2.city_id = T1.city_id WHERE T2.address = '1623 Kingstown Drive'

Database: movie_3
Question: Who are the actors of film titled "BIRD INDEPENDENCE"?
Evidence: actor refers to first_name, last_name
SQL: SELECT T3.first_name, T3.last_name FROM film AS T1 INNER JOIN film_actor AS T2 ON T1.film_id = T2.film_id INNER JOIN actor AS T3 ON T2.actor_id = T3.actor_id WHERE T1.title = 'BIRD INDEPENDENCE'

Database: donor
Question: Which resource type is commonly bought by the Los Angeles Unified School District?
Evidence: resource type refer to project_resource_type; most commonly bought refer to COUNT(project_resource_type where school_district = ’Los Angeles Unif Sch Dist’); Los Angeles Unified School District refer to school_district = ’Los Angeles Unif Sch Dist’
SQL: SELECT T1.project_resource_type FROM resources AS T1 INNER JOIN projects AS T2 ON T1.projectid = T2.projectid WHERE T2.school_district = 'Los Angeles Unif Sch Dist' GROUP BY T2.school_district ORDER BY COUNT(T1.project_resource_type) DESC LIMIT 1

Database: retail_world
Question: Which territory does Ms. Laura Callahan's direct supervisor work in? Give the name of the territory.
Evidence: Ms. refers to TitleOfCourtesy = 'Ms'; ReportsTo’ represents a hierarchical relationship where the person being reported to is usually the direct supervisor of the reporter; name of the territory refers to TerritoryDescription;
SQL: SELECT T3.TerritoryDescription FROM Employees AS T1 INNER JOIN EmployeeTerritories AS T2 ON T1.EmployeeID = T2.EmployeeID INNER JOIN Territories AS T3 ON T2.TerritoryID = T3.TerritoryID WHERE T1.EmployeeID = ( SELECT ReportsTo FROM Employees WHERE TitleOfCourtesy = 'Ms.' AND FirstName = 'Laura' AND LastName = 'Callahan' )

Database: world_development_indicators
Question: What are the special notes for the country whose average adolescent fertility rate is the highest?
Evidence: the average adolescent fertility rate is DIVIDE(SUM(value), SUM(IndicatorName like 'adolescent fertility rate%')); MAX(average adolescent fertility rate)
SQL: SELECT DISTINCT T1.SpecialNotes FROM Country AS T1 INNER JOIN Indicators AS T2 ON T1.CountryCode = T2.CountryCode WHERE T2.Value = ( SELECT Value FROM Indicators WHERE IndicatorName LIKE 'Adolescent fertility rate%' ORDER BY Value DESC LIMIT 1 )

Database: retail_world
Question: What are the products that belong to the beverage category?
Evidence: products belong to beverage category refer to ProductName where CategoryName = 'beverage';
SQL: SELECT T2.ProductName FROM Categories AS T1 INNER JOIN Products AS T2 ON T1.CategoryID = T2.CategoryID WHERE T1.CategoryName = 'Beverages'

Database: public_review_platform
Question: Among the review votes of funny and cool hit uber with long review length, describe the business ID, active status, user ID and user year of joining Yelp.
Evidence: review votes of funny refers to review_votes_funny = 'Uber'; cool hit uber refers to review_votes_cool = 'Uber'; user year of joining Yelp refers to user_yelping_since_year
SQL: SELECT T1.business_id, T1.active, T3.user_id, T3.user_yelping_since_year FROM Business AS T1 INNER JOIN Reviews AS T2 ON T1.business_id = T2.business_id INNER JOIN Users AS T3 ON T2.user_id = T3.user_id WHERE T2.review_votes_cool = 'Uber' AND T2.review_votes_funny = 'Uber' AND T2.review_length = 'Long'

Database: professional_basketball
Question: What is the average weight of the players who have won the award of Rookie of the year?
Evidence: "Rookie of the Year" is the award; average weight = Divide (Sum(weight), Count(playerID))
SQL: SELECT AVG(T1.weight) FROM players AS T1 INNER JOIN awards_players AS T2 ON T1.playerID = T2.playerID WHERE T2.award = 'Rookie of the Year'

Database: superstore
Question: How many orders were made by Maxwell Schwartz in 2015?
Evidence: Maxwell Schwartz' is the "Customer Name"; in 2015 refers to strftime('%Y', "Order Date") = '2015';
SQL: SELECT COUNT(DISTINCT T1.`Order ID`) FROM east_superstore AS T1 INNER JOIN people AS T2 ON T1.`Customer ID` = T2.`Customer ID` WHERE T2.`Customer Name` = 'Maxwell Schwartz' AND STRFTIME('%Y', T1.`Order Date`) = '2015'

Database: retail_complains
Question: What is the name of the state that the client with the email "skylar.ramirez@gmail.com" lives in?
SQL: SELECT T3.state FROM state AS T1 INNER JOIN district AS T2 ON T1.StateCode = T2.state_abbrev INNER JOIN client AS T3 ON T2.district_id = T3.district_id WHERE T3.email = 'skylar.ramirez@gmail.com'

Database: retails
Question: How many line items were returned in 1998?
Evidence: line item refers to l_linenumber; returned refers to returnflag = 'R'; in 1998 refers to year(l_shipdate) = 1998
SQL: SELECT l_linenumber FROM lineitem WHERE STRFTIME('%Y', l_shipdate) < 1997 AND l_shipmode = 'TRUCK'

Database: retail_complains
Question: List all the complaints narratives made by the customer named Brenda and last name Mayer.
Evidence: complaints narratives refers to "Consumer complaint narrative";
SQL: SELECT T2.`Consumer complaint narrative` FROM client AS T1 INNER JOIN events AS T2 ON T1.client_id = T2.Client_ID WHERE T1.first = 'Brenda' AND T1.last = 'Mayer'

Database: regional_sales
Question: How many products sold by Adam Hernandez?
Evidence: products sold by Adam Hernandez refer to SUM(Order Quantity where Sales Team = 'Adam Hernandez');
SQL: SELECT SUM(CASE WHEN T2.`Sales Team` = 'Adam Hernandez' THEN 1 ELSE 0 END) FROM `Sales Orders` AS T1 INNER JOIN `Sales Team` AS T2 ON T2.SalesTeamID = T1._SalesTeamID

Database: olympics
Question: What is the percentage of champions at the age of over 30?
Evidence: DIVIDE(COUNT(competitor_id where age > 30), COUNT(competitor_id))as percentage where medal_id = 1;
SQL: SELECT CAST(COUNT(CASE WHEN T2.age > 30 THEN 1 END) AS REAL) * 100 / COUNT(T2.person_id) FROM competitor_event AS T1 INNER JOIN games_competitor AS T2 ON T1.competitor_id = T2.id WHERE T1.medal_id = 1

Database: authors
Question: What is the affiliation of the author writing in the journal 'A combined search for the standard model Higgs boson at s = 1.96 Â TeV'?
Evidence: journal 'A combined search for the standard model Higgs boson at s = 1.96 Â TeV' refers to Title = 'A combined search for the standard model Higgs boson at s = 1.96 Â TeV'
SQL: SELECT T1.Affiliation FROM PaperAuthor AS T1 INNER JOIN Paper AS T2 ON T1.PaperId = T2.Id WHERE T2.Title = 'A combined search for the standard model Higgs boson at s = 1.96 Â TeV'

Database: shakespeare
Question: When did Shakespeare create his work that has 154 scenes?
Evidence: When refers to Date; has 154 scenes refers to count(Scene) = 154
SQL: SELECT T1.Date, T1.id FROM works AS T1 INNER JOIN chapters AS T2 ON T1.id = T2.work_id WHERE T2.Scene = 154