Database: retail_world
Question: List the products whose supplier is Pavlova, Ltd. Please include the product ID and re-order level.
Evidence: "Pavlova, Ltd" is the CompanyName; products refers to ProductName
SQL: SELECT T1.ProductName, T1.ProductID, T1.ReorderLevel FROM Products AS T1 INNER JOIN Suppliers AS T2 ON T1.SupplierID = T2.SupplierID WHERE T2.CompanyName = 'Pavlova, Ltd.'

Database: app_store
Question: Which free app has the most Negative comments?
Evidence: paid app refers to Type = 'Paid'; negative comment refers to Sentiment = 'Negative'; paid app with most negative comments refers to MAX(COUNT(Sentiment = 'Negative')) where Type = 'Paid';
SQL: SELECT T1.App FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Type = 'Free' AND T2.Sentiment = 'Negative' GROUP BY T1.App ORDER BY COUNT(T2.Sentiment) DESC LIMIT 1

Database: language_corpus
Question: Calculate the average number of the word occurrences in which ‘system’ appeared as the first word in the pair.
Evidence: average word occurrences = divide(sum(occurrences), count(occurrences)); ‘system’ appeared as the first word refers to w1st = 'system'
SQL: SELECT AVG(T2.occurrences) FROM words AS T1 INNER JOIN biwords AS T2 ON T1.wid = T2.w1st WHERE T2.w1st = ( SELECT wid FROM words WHERE word = 'sistema' )

Database: regional_sales
Question: State the customer name of orders which has shipped date in 7/8/2018.
Evidence: shipped date in 7/8/2018 refers to ShipDate = '7/8/18'
SQL: SELECT T FROM ( SELECT DISTINCT CASE  WHEN T2.ShipDate = '7/8/18' THEN T1.`Customer Names` END AS T FROM Customers T1 INNER JOIN `Sales Orders` T2 ON T2._CustomerID = T1.CustomerID ) WHERE T IS NOT NULL

Database: movie_platform
Question: What is the list ID that was first created by user 85981819?
Evidence: first created list refers to oldest list_creation_date_utc;
SQL: SELECT list_id FROM lists_users WHERE user_id = 85981819 ORDER BY list_creation_date_utc ASC LIMIT 1

Database: world
Question: How many countries use Portuguese?
Evidence: Portuguese refers to `Language` = 'Portuguese';
SQL: SELECT SUM(CASE WHEN Language = 'Portuguese' THEN 1 ELSE 0 END) FROM CountryLanguage

Database: codebase_comments
Question: How many stars does the repository of the solution No. 45997 have?
Evidence: repository of solution no. refers to Id
SQL: SELECT T1.Stars FROM Repo AS T1 INNER JOIN Solution AS T2 ON T1.Id = T2.RepoId WHERE T2.Id = 45997

Database: retail_world
Question: List all product names under Confections.
Evidence: 'Confections' is a CompanyName;
SQL: SELECT T1.ProductName FROM Products AS T1 INNER JOIN Categories AS T2 ON T1.CategoryID = T2.CategoryID WHERE T2.CategoryName = 'Confections'

Database: beer_factory
Question: What percentage of customers who paid with a Discover Credit Card gave a 3-star rating?
Evidence: percentage = MULTIPLY(DIVIDE(COUNT(CustomerID WHERE StarRating = 3), COUNT(CustomerID) WHERE CreditCardType = 'Discover'), 100); Discover Credit Card refers to CreditCardType = 'Discover'; 3-star rating refers to StarRating = 3;
SQL: SELECT CAST(COUNT(CASE WHEN T1.StarRating = 3 THEN 1 ELSE NULL END) AS REAL) * 100 / COUNT(T1.CustomerID) FROM rootbeerreview AS T1 INNER JOIN `transaction` AS T2 ON T1.CustomerID = T2.CustomerID WHERE T2.CreditCardType = 'Discover'

Database: donor
Question: What percentage of projects that have not received a cash donation have received a portion of a donation included corporate sponsored giftcard?
Evidence: have not received a cash donation refers to payment_method = 'no_cash_received'; received a portion of a donation included corporate sponsored giftcard payment_included_campaign_gift_card = 't'; percentage refers to DIVIDE(payment_included_campaign_gift_card = 't',payment_included_campaign_gift_card)*100
SQL: SELECT CAST(SUM(CASE WHEN payment_included_campaign_gift_card = 't' THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(donationid) FROM donations WHERE payment_method = 'no_cash_received'

Database: superstore
Question: Among the products under the office supplies category, what is the product that made the highest sales in the Central region?
Evidence: made the highest sales refers to MAX(Sales)
SQL: SELECT T2.`Product Name` FROM central_superstore AS T1 INNER JOIN product AS T2 ON T1.`Product ID` = T2.`Product ID` WHERE T2.Category = 'Office Supplies' AND T2.Region = 'Central' ORDER BY T1.Sales DESC LIMIT 1

Database: legislator
Question: Provide the full name of all current female legislators that chose Republican as their political party.
Evidence: full name refers to official_full_name; official_full_name refers to first_name, last_name; female refers to gender_bio = 'F'; chose Republican as their political party refers to party = 'Republican'; current legislators refers to END > Date()
SQL: SELECT T1.first_name, T1.last_name FROM current AS T1 INNER JOIN `current-terms` AS T2 ON T1.bioguide_id = T2.bioguide WHERE T2.party = 'Republican' AND T1.gender_bio = 'F' AND T2.END > DATE() GROUP BY T1.bioguide_id

Database: sales_in_weather
Question: Provide the sunrise time recorded by the home weather station of store no.30 on 2014/2/21.
Evidence: store no. 30 refers to store_nbr = 30; on 2014/2/21 refers to date = '2014-02-21'
SQL: SELECT T1.sunrise FROM weather AS T1 INNER JOIN relation AS T2 ON T1.station_nbr = T2.station_nbr WHERE T1.`date` = '2014-02-21' AND store_nbr = 30

Database: airline
Question: Provide the air carrier description of the flight with a tail number N922US from Phoenix.
Evidence: tail number refers to TAIL_NUM; TAIL_NUM = 'N922US'; from Phoenix refers to ORIGIN = 'PHX';
SQL: SELECT T2.Description FROM Airlines AS T1 INNER JOIN `Air Carriers` AS T2 ON T2.Code = T1.OP_CARRIER_AIRLINE_ID WHERE T1.TAIL_NUM = 'N922US' AND T1.ORIGIN = 'PHX' GROUP BY T2.Description

Database: movie_3
Question: What is the difference between the number of children's films and action films?
Evidence: 'children' AND 'action' are names of a category; Calculation = SUBTRACT(AVG('children'), AVG('action'))
SQL: SELECT SUM(IIF(T2.name = 'Children', 1, 0)) - SUM(IIF(T2.name = 'Action', 1, 0)) AS diff FROM film_category AS T1 INNER JOIN category AS T2 ON T1.category_id = T2.category_id

Database: cars
Question: Which is the origin country of the $44274.40748 car?
Evidence: origin country refers to country; the $44274.40748 car refers to price = 44274.40748
SQL: SELECT T3.country FROM price AS T1 INNER JOIN production AS T2 ON T1.ID = T2.ID INNER JOIN country AS T3 ON T3.origin = T2.country WHERE T1.price = 44274.40748

Database: student_loan
Question: Among the students with disabilities, list any five students' names who are unemployed.
Evidence: students with disabilities who are unemployed refers to disabled.name who are IN unemployed.name;
SQL: SELECT T1.name FROM disabled AS T1 INNER JOIN unemployed AS T2 ON T2.name = T1.name LIMIT 5

Database: language_corpus
Question: What is the total word of title "Adam" and "Acampada"?
Evidence: total word refers to sum(words); title "Adam" and "Acampada" refers to title IN('Adam','Acampada')
SQL: SELECT SUM(words) FROM pages WHERE title IN ('Adam', 'Acampada')

Database: public_review_platform
Question: What are the attributes that business number 56 have?
Evidence: business number refers to business_id; attributes that business have refers to attribute_value = 'true';
SQL: SELECT T1.attribute_name FROM Attributes AS T1 INNER JOIN Business_Attributes AS T2 ON T1.attribute_id = T2.attribute_id WHERE T2.attribute_value LIKE 'TRUE' AND T2.business_id = 56