Database: world_development_indicators
Question: Which countries have a fertility rate between 4 and 5 in 1979? List their names.
Evidence: Year = 1979; fertility rate refers to IndicatorName = 'Fertility rate, total (births per woman)'; Value is between 4 and 5;
SQL: SELECT CountryName FROM Indicators WHERE Year = 1979 AND IndicatorName = 'Fertility rate, total (births per woman)' AND value >= 4 AND Value <= 5

Database: retail_complains
Question: List the products involved in the complaints received on March 2017 via TOVA server.
Evidence: on March 2017 refers to Date received LIKE '%03%' AND Date received LIKE '2017%'
SQL: SELECT DISTINCT T2.Product FROM callcenterlogs AS T1 INNER JOIN events AS T2 ON T1.`Complaint ID` = T2.`Complaint ID` WHERE T1.server = 'TOVA' AND T2.`Date received` LIKE '2017-03%'

Database: bike_share_1
Question: What is the shortest trip made starting from Franklin at Maple and what is the maximum wind speed at that date?
Evidence: shortest trip refers to MIN(duration); starting from refers to start_station_name; start_station_name = 'Franklin at Maple'; maximum wind speed refers to max_wind_Speed_mph;
SQL: SELECT MIN(T1.duration), MAX(T2.max_wind_Speed_mph) FROM trip AS T1 INNER JOIN weather AS T2 ON T2.zip_code = T1.zip_code WHERE T1.start_station_name = 'Franklin at Maple' AND T2.date = '9/4/2013'

Database: beer_factory
Question: What brands of beers are manufactured at coordinates 38,566,129, -121,426,432?
Evidence: coordinates 38,566,129, -121,426,432 refers to Latitude = 38.566129 AND Longitude = -121.426432;
SQL: SELECT DISTINCT T2.BrandName FROM rootbeer AS T1 INNER JOIN rootbeerbrand AS T2 ON T1.BrandID = T2.BrandID INNER JOIN geolocation AS T3 ON T1.LocationID = T3.LocationID WHERE T3.Latitude = '38.566129' AND T3.Longitude = '-121.426432'

Database: chicago_crime
Question: In Albany Park, how many arrests were made in an apartment due to criminal sexual abuse?
Evidence: Albany Park refers to district_name = 'Albany Park'; in an apartment refers to location_description = 'APARTMENT'; criminal sexual abuse refers to title = 'Criminal Sexual Abuse'
SQL: SELECT SUM(CASE WHEN T3.title = 'Criminal Sexual Abuse' THEN 1 ELSE 0 END) FROM District AS T1 INNER JOIN Crime AS T2 ON T1.district_no = T2.district_no INNER JOIN FBI_Code AS T3 ON T2.fbi_code_no = T3.fbi_code_no WHERE T1.district_name = 'Albany Park' AND T2.arrest = 'TRUE' AND T2.location_description = 'APARTMENT'

Database: law_episode
Question: Which continent was Michael Preston born on?
Evidence: continent refers to birth_country
SQL: SELECT birth_country FROM Person WHERE name = 'Michael Preston'

Database: retail_world
Question: Indicate the name of the products that have been shipped to the city of Paris.
Evidence: shipped to the city of Paris refers to ShipCity = 'Paris';
SQL: SELECT T3.ProductName FROM Orders AS T1 INNER JOIN `Order Details` AS T2 ON T1.OrderID = T2.OrderID INNER JOIN Products AS T3 ON T2.ProductID = T3.ProductID WHERE T1.ShipCity = 'Paris'

Database: university
Question: Which university had the most students in 2011? Show its name.
Evidence: in 2011 refers to year 2011; the most students refers to MAX(num_students); which university refers to university_name;
SQL: SELECT T2.university_name FROM university_year AS T1 INNER JOIN university AS T2 ON T1.university_id = T2.id WHERE T1.year = 2011 ORDER BY T1.num_students DESC LIMIT 1

Database: genes
Question: If a pair of genes is positively correlated, what is the possibility of it being composed of two genes both with over 10 chromosomes?
Evidence: Positively correlated means Expression_Corr > 0; Possibility = count(the pairs of genes with both chromosomes over 20) / count(pairs of genes that are positively correlated)
SQL: SELECT CAST(SUM(IIF(T1.Chromosome > 10 AND T3.Chromosome > 10, 1, 0)) AS REAL) * 100 / COUNT(T1.GeneID) FROM Genes AS T1 INNER JOIN Interactions AS T2 ON T1.GeneID = T2.GeneID1 INNER JOIN Genes AS T3 ON T3.GeneID = T2.GeneID2 WHERE T2.Expression_Corr > 0

Database: food_inspection_2
Question: How many inspections done by Lisa Tillman ended up with the result of "Out of Business"?
Evidence: the result of "Out of Business" refers to results = 'Out of Business'
SQL: SELECT COUNT(T1.inspection_id) FROM inspection AS T1 INNER JOIN employee AS T2 ON T1.employee_id = T2.employee_id WHERE T2.first_name = 'Lisa' AND T2.last_name = 'Tillman' AND T1.results = 'Out of Business'

Database: cs_semester
Question: How many courses does Alvera McQuillin take?
SQL: SELECT COUNT(T1.course_id) FROM registration AS T1 INNER JOIN student AS T2 ON T1.student_id = T2.student_id WHERE T2.f_name = 'Alvera' AND T2.l_name = 'McQuillin'

Database: synthea
Question: How many conditions did Tyree Eichmann have?
Evidence: conditions refer to DESCRIPTION from conditions;
SQL: SELECT COUNT(DISTINCT T2.DESCRIPTION) FROM patients AS T1 INNER JOIN conditions AS T2 ON T1.patient = T2.PATIENT WHERE T1.first = 'Tyree' AND T1.last = 'Eichmann'

Database: cs_semester
Question: Which course is more difficult, Intro to BlockChain or Computer Network?
Evidence: diff refers to difficulty; diff is higher means the course is more difficult;
SQL: SELECT name FROM course WHERE name = 'Intro to BlockChain' OR name = 'Computer Network' ORDER BY diff DESC LIMIT 1

Database: talkingdata
Question: What is the ratio of male and female users of vivo X5pro model?
Evidence: ratio = DIVIDE(SUM(gender = 'M' WHERE device_model = 'X5Pro'), SUM(gender = 'F' WHERE device_model = 'X5Pro')); male refers to gender = 'M'; female refers to gender = 'F'; vivo X5pro model refers to phone_brand = 'vivo' AND device_model = 'X5Pro';
SQL: SELECT SUM(IIF(T1.gender = 'M', 1, 0)) / SUM(IIF(T1.gender = 'F', 1, 0)) AS per FROM gender_age AS T1 INNER JOIN phone_brand_device_model2 AS T2 ON T1.device_id = T2.device_id WHERE T2.phone_brand = 'vivo' AND T2.device_model = 'X5Pro'

Database: public_review_platform
Question: Which users become an elite in 2012?
Evidence: in 2012 refers to actual_year = 2012;
SQL: SELECT DISTINCT T1.user_id FROM Elite AS T1 INNER JOIN Years AS T2 ON T1.year_id = T2.year_id WHERE T2.actual_year = 2012

Database: movie_3
Question: What is the full name of the actor who has acted the most times in comedy films?
Evidence: full name refers to first_name, last_name; 'comedy' is a name of a category;
SQL: SELECT T.first_name, T.last_name FROM ( SELECT T4.first_name, T4.last_name, COUNT(T2.actor_id) AS num FROM film_category AS T1 INNER JOIN film_actor AS T2 ON T1.film_id = T2.film_id INNER JOIN category AS T3 ON T1.category_id = T3.category_id INNER JOIN actor AS T4 ON T2.actor_id = T4.actor_id WHERE T3.name = 'Comedy' GROUP BY T4.first_name, T4.last_name ) AS T ORDER BY T.num DESC LIMIT 1

Database: regional_sales
Question: Lists the name of the product and customer who placed an order on 10/21/18 and it was delivered on 11/21/19.
Evidence: ordered on 10/21/18 refers to OrderDate = '10/21/18'; delivered on 11/21/19 refers to DeliveryDate = '11/21/19'; name of product refers to Product Name
SQL: SELECT T3.`Product Name`, T1.`Customer Names` FROM Customers AS T1 INNER JOIN `Sales Orders` AS T2 ON T2._CustomerID = T1.CustomerID INNER JOIN Products AS T3 ON T3.ProductID = T2._ProductID WHERE T2.OrderDate = '10/21/18' AND T2.DeliveryDate = '11/21/19'

Database: regional_sales
Question: Mention the most populated city and median income of the store in Florida state.
Evidence: most populated refers to Max(Population);
SQL: SELECT `City Name`, `Median Income` FROM `Store Locations` WHERE State = 'Florida' ORDER BY Population DESC LIMIT 1