Database: simpson_episodes
Question: Name of the crew that were born in California, USA between 1958 and 1969.
Evidence: born in California refers to birth_place = 'California'; USA refers to birth_country = 'USA'; between 1958 and 1969 refers to birthdate BETWEEN '1958-01-01' and '1958-12-31'
SQL: SELECT name FROM Person WHERE SUBSTR(birthdate, 1, 4) = '1958' AND birth_place = 'California' AND birth_country = 'USA';

Database: address
Question: Among all the residential areas in Arecibo county, what is the zip_code of the one with the highest white population?
Evidence: "ARECIBO" is the county; highest white population refers to Max(white_population)
SQL: SELECT T1.zip_code FROM zip_data AS T1 INNER JOIN country AS T2 ON T1.zip_code = T2.zip_code WHERE T2.county = 'ARECIBO' ORDER BY T1.white_population DESC LIMIT 1

Database: simpson_episodes
Question: In year 2009, what is the percentage of the episode titled by "Gone Maggie Gone" being nominated?
Evidence: being nominated refers to result = 'Nominee'; percentage = divide(count(result = 'Nominee'), count(result)) * 100%
SQL: SELECT CAST((SUM(CASE WHEN T1.result = 'Nominee' THEN 1 ELSE 0 END) - SUM(CASE WHEN T1.result = 'Winner' THEN 1 ELSE 0 END)) AS REAL) * 100 / COUNT(T1.result) FROM Award AS T1 INNER JOIN Episode AS T2 ON T1.episode_id = T2.episode_id WHERE T2.title = 'Gone Maggie Gone' AND T1.year = 2009;

Database: public_review_platform
Question: For the Yelp businesses which received a "5" star review with "uber" number of votes for funny, which one is located in "Phoenix"? Give the business ID.
Evidence: located in "Phoenix" refers to city = 'Phoenix'; received a "5" star review refers to review_stars = '5'; "uber" number of votes for funny refers to review_votes_funny = 'Uber'
SQL: SELECT T1.business_id FROM Business AS T1 INNER JOIN Reviews AS T2 ON T1.business_id = T2.business_id WHERE T1.city = 'Phoenix' AND T2.review_stars = 5 AND T2.review_votes_funny = 'Uber'

Database: retails
Question: What is the region with the most customers?
Evidence: region refers to r_name; the most customers refers to max(count(c_custkey))
SQL: SELECT T.r_name FROM ( SELECT T3.r_name, COUNT(T2.c_custkey) AS num FROM nation AS T1 INNER JOIN customer AS T2 ON T1.n_nationkey = T2.c_nationkey INNER JOIN region AS T3 ON T1.n_regionkey = T3.r_regionkey GROUP BY T3.r_name ) AS T ORDER BY T.num DESC LIMIT 1

Database: talkingdata
Question: How many female users over the age of 50 are there?
Evidence: female refers to gender = 'F'; over the age of 50 refers to age > 50;
SQL: SELECT COUNT(gender) FROM gender_age WHERE age > 50 AND gender = 'F'

Database: book_publishing_company
Question: In which year has the most hired employees?
Evidence: most hired employees refers to MAX(count(emp_id))
SQL: SELECT STRFTIME('%Y', hire_date) FROM employee GROUP BY STRFTIME('%Y', hire_date) ORDER BY COUNT(emp_id) DESC LIMIT 1

Database: movies_4
Question: Write all the keywords belonging to the movie 'Sky Captain and the World of Tomorrow.'
Evidence: keywords refers to keyword_name; movie 'Sky Captain and the World of Tomorrow' refers to title = 'Sky Captain and the World of Tomorrow'
SQL: SELECT T3.keyword_name FROM movie AS T1 INNER JOIN movie_keywords AS T2 ON T1.movie_id = T2.movie_id INNER JOIN keyword AS T3 ON T2.keyword_id = T3.keyword_id WHERE T1.title = 'Sky Captain and the World of Tomorrow'

Database: synthea
Question: Indicate the full name of the patients who have 3 different allergies.
Evidence: full name refers to first, last; have 3 different allergies refer to allergies where COUNT(DESCRIPTION) > 3;
SQL: SELECT T1.first, T1.last FROM patients AS T1 INNER JOIN allergies AS T2 ON T1.patient = T2.PATIENT GROUP BY T1.patient ORDER BY COUNT(DISTINCT T2.DESCRIPTION) > 3

Database: cookbook
Question: List the ingredients in Tomato-Cucumber Relish.
Evidence: Tomato-Cucumber Relish 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 = 'Tomato-Cucumber Relish'

Database: chicago_crime
Question: Which district commander was responsible for more incidents in January, 2018, Robert A. Rubio or Glenn White?
Evidence: in January 2018 refers to Substr(date, 1, 1) = '1' AND Substr(date, 5, 4) = '2018'; 'Robert A. Rubio' and 'Glenn White' are both commander; responsible for more incident refers to Max(count(ward_no))
SQL: SELECT T1.commander FROM District AS T1 INNER JOIN Crime AS T2 ON T1.district_no = T2.district_no WHERE T1.commander IN ('Robert A. Rubio', 'Glenn White') AND SUBSTR(T2.date, 1, 1) = '1' AND SUBSTR(T2.date, 5, 4) = '2018' GROUP BY T1.commander

Database: movie_3
Question: List at least 10 films that falls into the Horror category.
Evidence: film refers to title; Horror category refers to category.name = 'Horror'
SQL: SELECT T1.title FROM film AS T1 INNER JOIN film_category AS T2 ON T1.film_id = T2.film_id INNER JOIN category AS T3 ON T2.category_id = T3.category_id WHERE T3.name = 'Horror'

Database: software_company
Question: List the level of education and income of customers ages from 30 to 55 with a true response.
Evidence: ages from 30 to 55 refer to age BETWEEN 30 AND 55; RESPONSE = 'true'; income refers to INCOME_K; education level refers to EDUCATIONNUM;
SQL: SELECT T1.EDUCATIONNUM, T3.INCOME_K FROM Customers AS T1 INNER JOIN Mailings1_2 AS T2 ON T1.ID = T2.REFID INNER JOIN Demog AS T3 ON T1.GEOID = T3.GEOID WHERE T1.age >= 30 AND T1.age <= 55 AND T2.RESPONSE = 'true'

Database: music_tracker
Question: How many times was the album released by blowfly in 1980 downloaded?
Evidence: blowfly is an artist; groupYear = 1980; album refers to releaseType; downloaded refers to totalSnatched;
SQL: SELECT totalSnatched FROM torrents WHERE artist LIKE 'blowfly' AND groupYear = 1980

Database: chicago_crime
Question: List the case number of the crimes in wards with population below 52000 that have beat greater than the 90% of the average beat of all crimes.
Evidence: population below 52000 refers to population < 52000; beat greater than the 90% of the average beat refers to beat > multiply(avg(beat), 0.9) where population < 52000
SQL: SELECT COUNT(T1.report_no) FROM Crime AS T1 INNER JOIN Ward AS T2 ON T1.ward_no = T2.ward_no WHERE T2.Population < 52000 AND T1.beat > ( SELECT AVG(T1.beat) * 0.9 FROM Crime AS T1 INNER JOIN Ward AS T2 ON T1.ward_no = T2.ward_no WHERE T2.Population < 52000 )

Database: legislator
Question: Provide the start date, end date, and party of Pearl Peden Oldfield.
Evidence: start date refers to start; end date refers to end date; Pearl Peden Oldfield refers to official_full_name; official_full_name refers to first_name, middle_name, last_name
SQL: SELECT T2.start, T2.`end`, T2.party FROM historical AS T1 INNER JOIN `historical-terms` AS T2 ON T1.bioguide_id = T2.bioguide WHERE T1.first_name = 'Pearl' AND T1.middle_name = 'Peden' AND T1.last_name = 'Oldfield'

Database: talkingdata
Question: Please provide the gender of at least one user who owns an HTC Desire 826 device.
Evidence: HTC Desire 826 refers to phone_brand = 'HTC' AND device_model = 'Desire 826';
SQL: SELECT T1.gender FROM gender_age AS T1 INNER JOIN phone_brand_device_model2 AS T2 ON T1.device_id = T2.device_id WHERE T2.device_model = 'Desire 826' AND T2.phone_brand = 'HTC'

Database: codebase_comments
Question: What is the tokenized name of the solution whose path is "maravillas_linq-to-delicious\tasty.sln"?
Evidence: tokenized name refers to NameTokenized
SQL: SELECT DISTINCT T2.NameTokenized FROM Solution AS T1 INNER JOIN Method AS T2 ON T1.Id = T2.SolutionId WHERE T1.Path = 'maravillas_linq-to-delicious'