Database: talkingdata
Question: Calculate the percentage of the app user IDs under Industry tag category.
Evidence: percentage = DIVIDE(MULTIPLY(CONCAT(COUNT(app_id WHERE category = 'Industry tag'), 100), COUNT(app_id)),'%');
SQL: SELECT SUM(IIF(T1.category = 'Industry tag', 1, 0)) * 100 / COUNT(T2.app_id) AS per FROM label_categories AS T1 INNER JOIN app_labels AS T2 ON T2.label_id = T1.label_id

Database: sales
Question: What is the average number of customers per sales person?
Evidence: average = DIVIDE(COUNT(CustomerID), COUNT(EmployeeID));
SQL: SELECT CAST(COUNT(T1.CustomerID) AS REAL) / COUNT(T3.EmployeeID) FROM Customers AS T1 INNER JOIN Sales AS T2 ON T1.CustomerID = T2.CustomerID INNER JOIN Employees AS T3 ON T2.SalesPersonID = T3.EmployeeID

Database: movie_3
Question: List the films' titles which were rented on 24th May,2005.
Evidence: rented on 24th May 2005 refers to rental_date = '2005-05-24%'
SQL: SELECT T1.title FROM film AS T1 INNER JOIN inventory AS T2 ON T1.film_id = T2.film_id INNER JOIN rental AS T3 ON T2.inventory_id = T3.inventory_id WHERE SUBSTR(T3.rental_date, 1, 10) = '2005-05-24'

Database: book_publishing_company
Question: Find and list the full name of employees who were hired between 1990 and 1995. Also, arrange them in the descending order of job level.
Evidence: job level refers to job_lvl; YEAR(hire_date) between 1990 and 1995
SQL: SELECT fname, minit, lname FROM employee WHERE STRFTIME('%Y', hire_date) BETWEEN '1990' AND '1995' ORDER BY job_lvl DESC

Database: books
Question: How many pages does 'Seaward' have?
Evidence: "Seaward" is the title of the book; pages refers to num_pages
SQL: SELECT num_pages FROM book WHERE title = 'Seaward'

Database: movies_4
Question: How many movies were produced in Canada?
Evidence: produced in Canada refers to country_name = 'Canada'
SQL: SELECT COUNT(T2.movie_id) FROM COUNTry AS T1 INNER JOIN production_COUNTry AS T2 ON T1.COUNTry_id = T2.COUNTry_id WHERE T1.COUNTry_name = 'Canada'

Database: retails
Question: What is the discounted price of the part "burnished seashell gainsboro navajo chocolate" in order no.1?
Evidence: part "burnished seashell gainsboro navajo chocolate" refers to p_name = 'burnished seashell gainsboro navajo chocolate'; order no.1 refers to l_orderkey = 1; discounted price refers to multiply(l_extendedprice, subtract(1, l_discount))
SQL: SELECT T1.l_extendedprice * (1 - T1.l_discount) FROM lineitem AS T1 INNER JOIN part AS T2 ON T1.l_partkey = T2.p_partkey WHERE T2.p_name = 'burnished seashell gainsboro navajo chocolate' AND T1.l_orderkey = 1

Database: retail_complains
Question: Among the elderlies, state the last name of whose complaint is handled in server YIFAT?
Evidence: elder refers to age < = 65; last name refers to last
SQL: SELECT T1.last FROM client AS T1 INNER JOIN callcenterlogs AS T2 ON T1.client_id = T2.`rand client` WHERE T1.age > 65 AND T2.server = 'YIFAT'

Database: coinmarketcap
Question: List the names of the coins above the average price on April 28, 2013.
Evidence: average price = divide(sum(price), count(name)); on April 28, 2013 refers to date = '2013-04-28'
SQL: SELECT T1.name FROM coins AS T1 INNER JOIN historical AS T2 ON T1.id = T2.coin_id WHERE T2.date = '2018-04-28' AND T2.price > ( SELECT AVG(price) FROM historical WHERE date = '2018-04-28' )

Database: shakespeare
Question: What are the character names for a senator of Venice?
Evidence: character names refers to CharName; a senator of Venice refers to characters.Description = 'a senator of Venice'
SQL: SELECT CharName FROM characters WHERE Description = 'a senator of Venice'

Database: airline
Question: What is the total number of flights that have Oklahoma as their origin?
Evidence: Oklahoma as origin refers to Origin = 'OKC';
SQL: SELECT COUNT(*) AS num FROM Airlines WHERE Origin = 'OKC'

Database: restaurant
Question: Find the percentage of restaurant in Napa Valley.
Evidence: Napa Valley refers to region = 'Napa Valley'; percentage = divide(count(id_restaurant where region = 'Napa Valley'), count(id_restaurant)) * 100%
SQL: SELECT CAST(SUM(IIF(region = 'Napa Valley', 1, 0)) AS REAL) * 100 / COUNT(region) FROM geographic

Database: university
Question: List the names of universities with a score less than 28% of the average score of all universities in 2015.
Evidence: in 2015 refers to year = 2015; score less than 28% refers to score < MULTIPLY(avg(score), 0.28) where year = 2015; names of universities refers to university_name
SQL: SELECT T2.university_name FROM university_ranking_year AS T1 INNER JOIN university AS T2 ON T1.university_id = T2.id WHERE T1.year = 2015 AND T1.score * 100 < ( SELECT AVG(score) * 28 FROM university_ranking_year WHERE year = 2015 )

Database: beer_factory
Question: What credit card is the most used in the purchase of non-alcoholic beer?
Evidence: credit card that is the most used refers to MAX(COUNT(CreditCardType)); non-alcoholic beer refers to Alcoholic = 'FALSE';
SQL: SELECT T2.CreditCardType FROM rootbeer AS T1 INNER JOIN `transaction` AS T2 ON T1.RootBeerID = T2.RootBeerID INNER JOIN rootbeerbrand AS T3 ON T1.BrandID = T3.BrandID WHERE T3.Alcoholic = 'FALSE' GROUP BY T2.CreditCardType ORDER BY COUNT(T2.CreditCardType) DESC LIMIT 1

Database: car_retails
Question: Where was the order No. 10383 shipped to? Show me the address.
Evidence: Address comprises addressLine1 and addressLine2;
SQL: SELECT t2.addressLine1, t2.addressLine2 FROM orders AS t1 INNER JOIN customers AS t2 ON t1.customerNumber = t2.customerNumber WHERE t1.orderNumber = '10383'

Database: address
Question: List all the counties in Georgia.
Evidence: Georgia is the name of the state, in which name = 'Georgia';
SQL: SELECT T2.county FROM state AS T1 INNER JOIN country AS T2 ON T1.abbreviation = T2.state WHERE T1.name = 'Georgia' GROUP BY T2.county

Database: cookbook
Question: What are the optional ingredients for Warm Chinese Chicken Salad?
Evidence: optional refers to optional = 'TRUE'; Warm Chinese Chicken Salad refers to title
SQL: SELECT T3.name FROM Recipe AS T1 INNER JOIN Quantity AS T2 ON T1.recipe_id = T2.recipe_id INNER JOIN Ingredient AS T3 ON T3.ingredient_id = T2.ingredient_id WHERE T1.title = 'Warm Chinese Chicken Salad' AND T2.optional = 'TRUE'

Database: soccer_2016
Question: What is the bowling skill used by most players?
Evidence: bowling skill used by most players refers to max(count(Bowling_Skill))
SQL: SELECT T1.Bowling_Skill FROM Bowling_Style AS T1 INNER JOIN Player AS T2 ON T2.Bowling_skill = T1.Bowling_Id GROUP BY T1.Bowling_Skill ORDER BY COUNT(T1.Bowling_Skill) DESC LIMIT 1

Database: chicago_crime
Question: How many domestic violence cases were reported in May 2018?
Evidence: domestic violence refers to domestic = 'TRUE'; in May 2018 refers to date LIKE '5/%/2018%'
SQL: SELECT COUNT(*) FROM Crime WHERE date LIKE '5/%/2018%' AND domestic = 'TRUE'

Database: music_platform_2
Question: Please list the titles of all the podcasts under the category "arts-performing-arts".
Evidence: category 'arts-performing-arts' refers to category = 'arts-performing-arts';
SQL: SELECT DISTINCT T2.title FROM categories AS T1 INNER JOIN podcasts AS T2 ON T2.podcast_id = T1.podcast_id WHERE T1.category = 'arts-performing-arts'

Database: world_development_indicators
Question: What are the years when countries have indicator name of "Air transport, passengers carried"? List the table name of these countries.
SQL: SELECT DISTINCT T2.Year, T1.TableName FROM Country AS T1 INNER JOIN Indicators AS T2 ON T1.CountryCode = T2.CountryCode WHERE T2.IndicatorName = 'Air transport, passengers carried'