Database: app_store
Question: How many of the reviews for the app "Brit + Co" have a comment?
Evidence: Brit + Co refers to App = 'Brit + Co'; comment refers to Translated Review NOT null;
SQL: SELECT COUNT(App) FROM user_reviews WHERE App = 'Brit + Co' AND Translated_Review IS NOT NULL

Database: talkingdata
Question: Describe the device user gender and age of the event ID of 15251.
SQL: SELECT T1.gender, T1.age FROM gender_age AS T1 INNER JOIN events AS T2 ON T2.device_id = T1.device_id WHERE T2.event_id = 15251

Database: movie_3
Question: Please list any two films that Penelope Guiness acted in.
Evidence: film refers to title of the film; 'Penelope Guiness' is a full name of an actor; full name refers to first_name, last_name
SQL: SELECT T3.title FROM actor AS T1 INNER JOIN film_actor AS T2 ON T1.actor_id = T2.actor_id INNER JOIN film AS T3 ON T2.film_id = T3.film_id WHERE T1.first_name = 'Penelope' AND T1.last_name = 'Guiness' LIMIT 2

Database: food_inspection_2
Question: How much is the salary of the employee who has the highest number of inspections done of all time?
Evidence: the highest number of inspections done refers to max(count(employee_id))
SQL: SELECT T1.salary FROM employee AS T1 INNER JOIN ( SELECT employee_id, COUNT(inspection_id) FROM inspection GROUP BY employee_id ORDER BY COUNT(inspection_id) DESC LIMIT 1 ) AS T2 ON T1.employee_id = T2.employee_id

Database: food_inspection
Question: Which restaurant has the highest total number of high risk violations?
Evidence: the highest total number of high risk violations refer to MAX(COUNT(risk_category = 'High Risk'));
SQL: SELECT T2.name FROM violations AS T1 INNER JOIN businesses AS T2 ON T1.business_id = T2.business_id WHERE T1.risk_category = 'High Risk' GROUP BY T2.name ORDER BY COUNT(T2.name) DESC LIMIT 1

Database: superstore
Question: What is the order ID of the security-Tint Envelopes product ordered on June 3, 2013, in the Central region?
Evidence: Security-Tint Envelopes' refers to "Product Name"; ordered on June 3, 2013 refers to "Order Date" = '2013-06-03'
SQL: SELECT DISTINCT T1.`Order ID` FROM central_superstore AS T1 INNER JOIN product AS T2 ON T1.`Product ID` = T2.`Product ID` WHERE T2.`Product Name` = 'Security-Tint Envelopes' AND T1.`Order Date` = '2013-06-03'

Database: superstore
Question: List the name of all products that Cindy Stewart ordered in the east superstore.
Evidence: name of all products refers to Product Name; Cindy Stewart is the Customer Name;
SQL: SELECT T3.`Product Name` FROM south_superstore AS T1 INNER JOIN people AS T2 ON T1.`Customer ID` = T2.`Customer ID` INNER JOIN product AS T3 ON T3.`Product ID` = T1.`Product ID` WHERE T2.`Customer Name` = 'Cindy Stewart'

Database: legislator
Question: Among the legislators who started a term on 2nd December 1793, how many of them were males?
Evidence: started a term on 2nd December 1793 refers to start = '1793-12-02'; male refers to gender_bio = 'M'
SQL: SELECT COUNT(T1.bioguide_id) FROM historical AS T1 INNER JOIN `historical-terms` AS T2 ON T1.bioguide_id = T2.bioguide WHERE T1.gender_bio = 'M' AND T2.start = '1793-12-02'

Database: beer_factory
Question: List out the root beers bought by Tim Ocel and Dawn Childress.
Evidence: FALSE;
SQL: SELECT T2.RootBeerID FROM customers AS T1 INNER JOIN `transaction` AS T2 ON T2.CustomerID = T1.CustomerID WHERE (T1.First = 'Tim' AND T1.Last = 'Ocel') OR (T1.First = 'Dawn' AND T1.Last = 'Childress')

Database: world_development_indicators
Question: Name the country in which the topic is about Poverty: Shared Prosperity. Indicate the long name of the country.
SQL: SELECT DISTINCT T1.LongName FROM Country AS T1 INNER JOIN footnotes AS T2 ON T1.CountryCode = T2.Countrycode INNER JOIN Series AS T3 ON T2.Seriescode = T3.SeriesCode WHERE T3.Topic = 'Poverty: Shared prosperity'

Database: public_review_platform
Question: What is the category of businesses with highest star rating?
Evidence: category refers to category_name; highest star rating refers to max(stars)
SQL: SELECT T3.category_name FROM Business AS T1 INNER JOIN Business_Categories AS T2 ON T1.business_id = T2.business_id INNER JOIN Categories AS T3 ON T2.category_id = T3.category_id ORDER BY T1.stars DESC LIMIT 1

Database: retails
Question: The part "hot spring dodger dim light" is ordered in how many orders?
Evidence: part "hot spring dodger dim light" refers to p_name = 'hot spring dodger dim light'
SQL: SELECT COUNT(T1.p_partkey) FROM part AS T1 INNER JOIN lineitem AS T2 ON T1.p_partkey = T2.l_partkey WHERE T1.p_name = 'hot spring dodger dim light'

Database: food_inspection_2
Question: Provide the inspection ID of the establishment named "PIZZA RUSTICA, INC."
Evidence: "PIZZA RUSTICA, INC." refers to dba_name = 'PIZZA RUSTICA, INC'
SQL: SELECT DISTINCT T2.inspection_id FROM establishment AS T1 INNER JOIN inspection AS T2 ON T1.license_no = T2.license_no WHERE T1.dba_name = 'PIZZA RUSTICA, INC'

Database: public_review_platform
Question: Please list the IDs of the users who have a high number of followers.
Evidence: high number of followers refers to user_fans = 'High'
SQL: SELECT user_id FROM Users WHERE user_fans LIKE 'High' GROUP BY user_id

Database: airline
Question: Please list the flight numbers of all the flights operated by American Airlines Inc. that were scheduled to depart from John F. Kennedy International.
Evidence: flight numbers refers to OP_CARRIER_FL_NUM; American Airlines Inc. refers to Description = 'American Airlines Inc.: AA'; depart from refers to ORIGIN; John F. Kennedy International refers to Description = 'New York, NY: John F. Kennedy International';
SQL: SELECT T2.OP_CARRIER_FL_NUM FROM Airports AS T1 INNER JOIN Airlines AS T2 ON T1.Code = T2.ORIGIN INNER JOIN `Air Carriers` AS T3 ON T2.OP_CARRIER_AIRLINE_ID = T3.Code WHERE T3.Description = 'American Airlines Inc.: AA' AND T1.Description = 'New York, NY: John F. Kennedy International' AND T2.FL_DATE = '2018/8/1'

Database: books
Question: List all the titles of the Spanish books published by Alfaguara.
Evidence: "Spanish" is the language_name; 'Alfaguara' is the publisher_name
SQL: SELECT T2.title FROM book_language AS T1 INNER JOIN book AS T2 ON T2.language_id = T1.language_id INNER JOIN publisher AS T3 ON T3.publisher_id = T2.publisher_id WHERE T1.language_name = 'Spanish' AND T3.publisher_name = 'Alfaguara' GROUP BY T2.title

Database: european_football_1
Question: Which team has the most victories as the home team in matches of the Bundesliga division?
Evidence: Bundesliga is the name of division; the most victories as the home team refers to MAX(COUNT(FTR = 'H'));
SQL: SELECT T1.HomeTeam FROM matchs AS T1 INNER JOIN divisions AS T2 ON T1.Div = T2.division WHERE T2.name = 'Bundesliga' AND T1.FTR = 'H' GROUP BY T1.HomeTeam ORDER BY COUNT(T1.FTR) DESC LIMIT 1

Database: olympics
Question: What is the season of the game where a competitor who weighted 73 kg and 180 cm tall, participated?
Evidence: competitor who weighted 73 kg and 180 cm tall refers to person_id where height = 180 and weight = 73;
SQL: SELECT DISTINCT T1.season FROM games AS T1 INNER JOIN games_competitor AS T2 ON T1.id = T2.games_id INNER JOIN person AS T3 ON T2.person_id = T3.id WHERE T3.height = 180 AND T3.weight = 73

Database: software_company
Question: Among the customers with a marital status of married-civ-spouse, list the number of inhabitants and age of those who are machine-op-inspct.
Evidence: OCCUPATION = 'Machine-op-inspct'; number of inhabitants refers to INHABITANTS_K;
SQL: SELECT T2.INHABITANTS_K FROM Customers AS T1 INNER JOIN Demog AS T2 ON T1.GEOID = T2.GEOID WHERE T1.OCCUPATION = 'Farming-fishing' AND T1.SEX = 'Male' AND T1.age >= 20 AND T1.age <= 30