Database: social_media
Question: Among all the tweets that have a positive sentiment, how many of them are posted on Thursday?
Evidence: positive sentiment refers to Sentiment > 0; posted on Thursday refers to Weekday = 'Thursday'
SQL: SELECT COUNT(TweetID) AS tweet_number FROM twitter WHERE Sentiment > 0 AND Weekday = 'Thursday'

Database: car_retails
Question: How much did customer 103 pay in total?
Evidence: Pay in total refers to SUM(amount);
SQL: SELECT SUM(t.amount) FROM payments t WHERE t.customerNumber = '103'

Database: movie_3
Question: List at least 3 cities under the country of Philippines.
SQL: SELECT T1.city FROM city AS T1 INNER JOIN country AS T2 ON T2.country_id = T1.country_id WHERE country = 'Philippines'

Database: disney
Question: Please list the movies directed by Wolfgang Reitherman that can be watched by the general audience.
Evidence: directed by Wolfgang Reitherman refers to director = 'Wolfgang Reitherman'; movies refer to movie_title; general audience refers to MPAA_rating = 'G';
SQL: SELECT T1.movie_title FROM `movies_total_gross` AS T1 INNER JOIN director AS T2 ON T1.movie_title = T2.name WHERE T1.MPAA_rating = 'G' AND T2.director = 'Wolfgang Reitherman'

Database: professional_basketball
Question: How many times have coaches who were from CHI been awarded as NBA Coach of the Year?
Evidence: CHI refers to tmID = 'CHI'; awarded Coach of the Year refers to award = 'Coach of the Year'; NBA refers to lgID = 'NBA'
SQL: SELECT COUNT(DISTINCT T2.coachID) FROM coaches AS T1 INNER JOIN awards_coaches AS T2 ON T1.coachID = T2.coachID WHERE T1.tmID = 'CHI' AND T2.award = 'NBA Coach of the Year'

Database: world
Question: List the countries and their official languages in Antarctica.
Evidence: official language refers to IsOfficial = 'T'; Antarctica refers to Continent = 'Antarctica';
SQL: SELECT T1.Name, T2.Language FROM Country AS T1 INNER JOIN CountryLanguage AS T2 ON T1.Code = T2.CountryCode WHERE T1.Continent = 'Antarctica' AND T2.IsOfficial = 'T'

Database: shakespeare
Question: In "Twelfth Night, Or What You Will", what is the description of the chapter in 2nd scene, Act 2?
Evidence: "Twelfth Night, Or What You Will"  refers to LongTitle = 'Twelfth Night, Or What You Will'; 2nd scene refers to Scene = 2
SQL: SELECT T2.Description FROM works AS T1 INNER JOIN chapters AS T2 ON T1.id = T2.work_id WHERE T1.LongTitle = 'Twelfth Night, Or What You Will' AND T2.Scene = 2 AND T2.Act = 2

Database: retail_world
Question: Among the seafoods, how many of them have an order quantity of more than 50?
Evidence: "Seafood" is the CategoryName; order quantity of more than 50 refers to Quantity > 50
SQL: SELECT COUNT(T1.ProductID) FROM Products AS T1 INNER JOIN `Order Details` AS T2 ON T1.ProductID = T2.ProductID INNER JOIN Categories AS T3 ON T1.CategoryID = T3.CategoryID WHERE T3.CategoryName = 'Seafood' AND T2.Quantity > 50

Database: talkingdata
Question: When did event number 2 happen and how many users were active?
Evidence: event number refers to event_id; event_id = 2; active refers to is_active = 1;
SQL: SELECT COUNT(T1.app_id) AS num FROM app_events AS T1 INNER JOIN events AS T2 ON T1.event_id = T2.event_id WHERE T1.event_id = 2 AND T1.is_active = 1 GROUP BY T2.timestamp

Database: car_retails
Question: List out full name and email of employees who are working in Paris?
Evidence: full name = firstName+LastName; Paris is a city;
SQL: SELECT T1.firstName, T1.lastName, T1.email FROM employees AS T1 INNER JOIN offices AS T2 ON T1.officeCode = T2.officeCode WHERE T2.city = 'Paris'

Database: music_platform_2
Question: Which titles have the content "love" but the category is art produced between 2018 and 2019.
Evidence: content love refers to content = 'love'; 'arts' is the category; produced between 2018 and 2019 refers to year (created_at) BETWEEN 2018 and 2019
SQL: SELECT DISTINCT T2.title FROM categories AS T1 INNER JOIN reviews AS T2 ON T2.podcast_id = T1.podcast_id WHERE (T2.created_at LIKE '2018-%' AND T1.category = 'arts' AND T2.content LIKE '%love%') OR (T2.created_at LIKE '2019-%' AND T1.category = 'arts' AND T2.content LIKE '%love%')

Database: ice_hockey_draft
Question: How much taller is David Bornhammar than Pauli Levokari in centimeters?
Evidence: how much taller = SUBTRACT(SUM(height_in_cm WHERE PlayerName = 'David Bornhammar'), SUM(height_in_cm WHERE PlayerName = 'Pauli Levokari')); height in centimeters refers to height_in_cm;
SQL: SELECT ( SELECT T2.height_in_cm FROM PlayerInfo AS T1 INNER JOIN height_info AS T2 ON T1.height = T2.height_id WHERE T1.PlayerName = 'David Bornhammar' ) - ( SELECT T2.height_in_cm FROM PlayerInfo AS T1 INNER JOIN height_info AS T2 ON T1.height = T2.height_id WHERE T1.PlayerName = 'Pauli Levokari' )

Database: talkingdata
Question: How many events does the device "4069764298338760000" have?
SQL: SELECT COUNT(event_id) FROM events WHERE device_id = 4069764298338760000

Database: image_and_language
Question: State the object class of the image with tallest bounding box.
Evidence: bounding box refers to X, Y, W, H from IMG_OBJ; tallest relates to the height of the bounding box which refers to MAX(H); object class refers to OBJ_CLASS;
SQL: SELECT T2.OBJ_CLASS FROM IMG_OBJ AS T1 INNER JOIN OBJ_CLASSES AS T2 ON T1.OBJ_CLASS_ID = T2.OBJ_CLASS_ID ORDER BY T1.H DESC LIMIT 1

Database: car_retails
Question: State top 3 emails of UK Sales Rep who have the highest credit limit.
Evidence: UK is a country; Sales Rep is a job title;
SQL: SELECT T2.email FROM customers AS T1 INNER JOIN employees AS T2 ON T1.salesRepEmployeeNumber = T2.employeeNumber WHERE T2.jobTitle = 'Sales Rep' AND T1.country = 'UK' GROUP BY T1.customerName, T2.email ORDER BY SUM(T1.creditLimit) DESC LIMIT 3

Database: public_review_platform
Question: How many active businesses are there in Phoenix?
Evidence: active businesses refers to active = 'true'; Phoenix refers to city = 'Phoenix';
SQL: SELECT COUNT(business_id) FROM Business WHERE city LIKE 'Phoenix' AND active LIKE 'TRUE'

Database: retails
Question: Provide the phone number of the customer with the highest total price in an order.
Evidence: phone number of the customer refers to c_phone; the highest total price refers to MAX(o_totalprice);
SQL: SELECT T2.c_phone FROM orders AS T1 INNER JOIN customer AS T2 ON T1.o_custkey = T2.c_custkey ORDER BY T1.o_totalprice DESC LIMIT 1

Database: soccer_2016
Question: From which country does the most umpires are from? How many of them are from the mentioned country?

Evidence: which country refers to Country_Id; most umpires refers to max(count(Umpire_Id))
SQL: SELECT T2.Country_Id, COUNT(T1.Umpire_Id) FROM Umpire AS T1 INNER JOIN Country AS T2 ON T2.Country_Id = T1.Umpire_Country GROUP BY T2.Country_Id ORDER BY COUNT(T1.Umpire_Id) DESC LIMIT 1

Database: talkingdata
Question: What is the age of the oldest male user of the app?
Evidence: oldest user refers to MAX(age); male refers to gender = 'M';
SQL: SELECT MAX(age) FROM gender_age WHERE gender = 'M'

Database: public_review_platform
Question: State the ID number for the attribute named "Accepts Insurance"?
Evidence: ID number refers to attribute_id
SQL: SELECT attribute_id FROM Attributes WHERE attribute_name = 'Accepts Insurance'

Database: world_development_indicators
Question: How many low-income countries under the lending category of the International Development Associations have a note on the series code SM.POP.TOTL?
Evidence: low-income countries are where the incomegroup = Low income
SQL: SELECT COUNT(T1.Countrycode) FROM Country AS T1 INNER JOIN CountryNotes AS T2 ON T1.CountryCode = T2.Countrycode WHERE T1.LendingCategory = 'IDA' AND T2.Seriescode = 'SM.POP.TOTL' AND IncomeGroup = 'Low income'