Database: shakespeare
Question: In Shakespeare's works before 1600, list down the title of the tragic story he had written that involved a character named "Tybalt".
Evidence: works before 1600 refers to DATE < 1600; tragic story refers to GenreType = 'Tragedy'; character named "Tybalt" refers to CharName = 'Tybalt'
SQL: SELECT DISTINCT T1.title FROM works AS T1 INNER JOIN chapters AS T2 ON T1.id = T2.work_id INNER JOIN paragraphs AS T3 ON T2.id = T3.chapter_id INNER JOIN characters AS T4 ON T3.character_id = T4.id WHERE T1.DATE < 1600 AND T1.GenreType = 'Tragedy' AND T4.CharName = 'Tybalt'

Database: cookbook
Question: Among the recipes from The California Tree Fruit Agreement, calculate the percentage of sodium-free recipes.
Evidence: The California Tree Fruit Agreement is a source; calculation = MULTIPLY(DIVIDE(COUNT(sodium BETWEEN 0 AND 5 THEN recipe_id), COUNT(recipe_id)), 100)
SQL: SELECT CAST(SUM(CASE WHEN T2.sodium < 5 THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(*) FROM Recipe AS T1 INNER JOIN Nutrition AS T2 ON T1.recipe_id = T2.recipe_id WHERE T1.source = 'The California Tree Fruit Agreement'

Database: coinmarketcap
Question: How much was a Bitcoin on 2013/4/28?
Evidence: how much refers to price; on 2013/4/28 refers to date = '2013-04-28'
SQL: SELECT T2.price FROM coins AS T1 INNER JOIN historical AS T2 ON T1.id = T2.coin_id WHERE T2.date = '2013-04-28' AND T1.name = 'Bitcoin'

Database: address
Question: Provide the population of Arecibo in 2020.
Evidence: population of Arecibo in 2020 refers to SUM(population_2020) where county = 'ARECIBO';
SQL: SELECT SUM(T2.population_2020) FROM country AS T1 INNER JOIN zip_data AS T2 ON T1.zip_code = T2.zip_code WHERE T1.county = 'ARECIBO'

Database: car_retails
Question: How many Australian customers who have credit line under 220000?
Evidence: Australian is a nationality of country = 'Australia'; credit line refers to creditLimit; creditLimit < 220000;
SQL: SELECT COUNT(creditLimit) FROM customers WHERE creditLimit < 220000 AND country = 'Australia'

Database: public_review_platform
Question: Among the active businesses located at Chandler, AZ, list the category and atrributes of business with a medium review count.
Evidence: active businesses refers to active = 'true'; located at Chandler, AZ refers to city = 'Chandler', state = 'AZ'; category refers to category_name; atrributes refers to attribute_name
SQL: SELECT T3.category_name, T5.attribute_name FROM Business AS T1 INNER JOIN Business_Categories ON T1.business_id = Business_Categories.business_id INNER JOIN Categories AS T3 ON Business_Categories.category_id = T3.category_id INNER JOIN Business_Attributes AS T4 ON T1.business_id = T4.business_id INNER JOIN Attributes AS T5 ON T4.attribute_id = T5.attribute_id WHERE T1.active LIKE 'TRUE' AND T1.state LIKE 'AZ' AND T1.city LIKE 'Chandler' AND T1.review_count LIKE 'Medium'

Database: public_review_platform
Question: Identify the operating hours of businesses in Black Canyon City with review count greater than average.
Evidence: operating hours refers to opening_time closing_time on day_id; in Black Canyon City refers to city = 'Black Canyon City'; greater than average refers to review_count > AVG(T1.review_count)
SQL: SELECT T2.opening_time, T2.closing_time 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 T1.city = 'Black Canyon City' GROUP BY t2.business_id HAVING T1.review_count > AVG(T1.review_count)

Database: language_corpus
Question: How many times does the Catalan word "nombre" repeat itself?
Evidence: the Catalan means Catalan language and refers to lid = 1; How many times repeat refers to occurrences;
SQL: SELECT T1.occurrences FROM langs_words AS T1 INNER JOIN words AS T2 ON T1.wid = T2.wid WHERE T2.word = 'nombre'

Database: movie_3
Question: What percentage of films are horror films?
Evidence: horror' is a name of a category; calculation = DIVIDE(SUM(name = 'Horror'), COUNT(film_id)) * 100
SQL: SELECT CAST(SUM(IIF(T2.name = 'Horror', 1, 0)) AS REAL) * 100 / COUNT(T1.film_id) FROM film_category AS T1 INNER JOIN category AS T2 ON T1.category_id = T2.category_id INNER JOIN film AS T3 ON T1.film_id = T3.film_id

Database: professional_basketball
Question: How many players did not get more than 10 steals between the years 2000 and 2005?
Evidence: did not get more than 10 steals refers to count(steals) < = 10; between the years 2000 and 2005 refers to season_id between 2000 and 2005
SQL: SELECT COUNT(DISTINCT playerID) FROM player_allstar WHERE season_id BETWEEN 2000 AND 2005 AND steals <= 10

Database: public_review_platform
Question: Calculate the percentage of users with a high number of fans who were elite in 2011.
Evidence: users with a high number of fans refers to user_fans = 'High'; 2011 refers to actual_year = 2011; Calculation = DIVIDE(Elite.user_id where user_fans = 'High' AND actual_year = 2011, Elite.user_id where actual_year = 2011) * 100
SQL: SELECT CAST(SUM(CASE WHEN T3.user_fans = 'High' THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(T3.user_fans) FROM Years AS T1 INNER JOIN Elite AS T2 ON T1.year_id = T2.year_id INNER JOIN Users AS T3 ON T2.user_id = T3.user_id WHERE T1.actual_year = 2011

Database: soccer_2016
Question: How many of the players are from Sri Lanka?
Evidence: from Sri Lanka refers to Country_Name = 'Sri Lanka';
SQL: SELECT COUNT(*) FROM Player AS T1 INNER JOIN Country AS T2 ON T1.Country_Name = T2.Country_ID WHERE T2.Country_Name = 'Sri Lanka'

Database: soccer_2016
Question: Among the matches played by Royal Challengers Bangalore, what is the match ID of the match with the highest winning margin?
Evidence: Royal Challengers Bangalore refers to team_name = 'Royal Challengers Bangalore'; highest winning margin refers to MAX(win_margin)
SQL: SELECT T2.match_id FROM Team AS T1 INNER JOIN Match AS T2 ON T1.team_id = T2.match_winner WHERE T1.team_name = 'Royal Challengers Bangalore' AND T2.match_date LIKE '2012%' ORDER BY T2.win_margin DESC LIMIT 1

Database: human_resources
Question: How much is the salary of the first ever employee that was hired?
Evidence: first-ever employee that was hired refers to MIN(hiredate)
SQL: SELECT salary FROM employee ORDER BY hiredate ASC LIMIT 1

Database: cars
Question: Which Dodge car is the cheapest?
Evidence: Dodge car refers to car_name LIKE 'dodge%'; the cheapest refers to min(price); name of the car refers to car_name
SQL: SELECT T1.car_name FROM data AS T1 INNER JOIN price AS T2 ON T1.ID = T2.ID WHERE T1.car_name LIKE 'dodge%' ORDER BY T2.price ASC LIMIT 1

Database: music_platform_2
Question: Among the reviews for the podcast "Please Excuse My Dead Aunt Sally", how many of them are made in the year 2019?
Evidence: "Please Excuse My Dead Aunt Sally" is the title of podcast; made in the year 2019 refers to created_at like '2019%'
SQL: SELECT COUNT(T2.created_at) FROM podcasts AS T1 INNER JOIN reviews AS T2 ON T2.podcast_id = T1.podcast_id WHERE T1.title = 'Please Excuse My Dead Aunt Sally' AND T2.created_at LIKE '2019-%'

Database: retail_world
Question: Which company placed the order with the id 10257?
Evidence: "10257" is the OrderID; company refers to CompanyName
SQL: SELECT T1.CompanyName FROM Customers AS T1 INNER JOIN Orders AS T2 ON T1.CustomerID = T2.CustomerID WHERE T2.OrderID = 10257

Database: talkingdata
Question: What is the brand of the device used by the youngest female user?
Evidence: brand of the device refers to phone_brand; youngest refers to MIN(age); female refers to gender = 'F';
SQL: SELECT phone_brand FROM phone_brand_device_model2 WHERE device_id IN ( SELECT * FROM ( SELECT device_id FROM gender_age WHERE gender = 'F' ORDER BY age LIMIT 1 ) AS T )