Database: address
Question: What is the country and state of the city named Dalton?
Evidence: Dalton is the city;
SQL: SELECT T2.county FROM state AS T1 INNER JOIN country AS T2 ON T1.abbreviation = T2.state INNER JOIN zip_data AS T3 ON T2.zip_code = T3.zip_code WHERE T3.city = 'Dalton' GROUP BY T2.county

Database: college_completion
Question: List the site of institution within the student count of 500 to 1000 that has the recent year of data release.
Evidence: recent year of data release refers to newest year;
SQL: SELECT DISTINCT T1.site FROM institution_details AS T1 INNER JOIN institution_grads AS T2 ON T2.unitid = T1.unitid WHERE T1.student_count BETWEEN 500 AND 1000 AND T2.year = ( SELECT MAX(T2.year) FROM institution_details AS T1 INNER JOIN institution_grads AS T2 ON T2.unitid = T1.unitid )

Database: simpson_episodes
Question: How many 10 star votes did the top 4 episodes with the highest rating received?
Evidence: 10 stars votes refers to stars = 10; highest rating refers to Max(rating); number of votes refers to SUM(votes)
SQL: SELECT SUM(T1.votes) FROM Episode AS T1 INNER JOIN Vote AS T2 ON T2.episode_id = T1.episode_id WHERE T2.stars = 10 ORDER BY T1.rating DESC LIMIT 4;

Database: human_resources
Question: What is Kenneth Charles's position title?
Evidence: Kenneth Charles is the full name of an employee; full name = firstname, lastname
SQL: SELECT T2.positiontitle FROM employee AS T1  INNER JOIN position AS T2  ON T1.positionID = T2.positionID WHERE T1.firstname = 'Kenneth' AND T1.lastname = 'Charles'

Database: image_and_language
Question: List all the explanations about object classes of all the images with an x and y coordinate of 0.
Evidence: explanations about distinct object classes refers to OBJ_CLASS; images refers to IMG_ID; x and y coordinate of 0 refers to X = 0 AND Y = 0
SQL: SELECT T1.OBJ_CLASS FROM OBJ_CLASSES AS T1 INNER JOIN IMG_OBJ AS T2 ON T1.OBJ_CLASS_ID = T2.OBJ_CLASS_ID WHERE T2.X = 0 AND T2.Y = 0 GROUP BY T1.OBJ_CLASS

Database: law_episode
Question: How many credits have been displayed from episode 1 until 10?
Evidence: credit displayed refers to credited = 'true'; from episode 1 until 10 refers to episode > = 1 AND episode < = 10
SQL: SELECT COUNT(T1.person_id) FROM Credit AS T1 INNER JOIN Episode AS T2 ON T1.episode_id = T2.episode_id WHERE T1.credited = 'true' AND T2.episode BETWEEN 1 AND 10

Database: retails
Question: Which ship mode has more "deliver in person" instructions, rail or mail?
Evidence: ship mode refers to l_shipmode; "deliver in person" instruction refers to l_shipinstruct = 'DELIVER IN PERSON'
SQL: SELECT IIF(SUM(IIF(l_shipmode = 'RAIL', 1, 0)) - SUM(IIF(l_shipmode = 'MAIL', 1, 0)), 'RAIL', 'MAIL') AS result FROM lineitem WHERE l_shipinstruct = 'DELIVER IN PERSON'

Database: world_development_indicators
Question: In Sub-Saharan Africa, how many female out-of-school children of primary school age are there in the country with the higest number of female out-of-school children of primary school age? Indicate the year of when it was recorded.
Evidence: in Sub-Saharan Africa refers to Region = 'Sub-Saharan Africa'; the higest number of female out-of-school children of primary school age refers to max(value where IndicatorName = 'Out-of-school children of primary school age, female (number)')
SQL: SELECT MAX(T1.value), T1.year FROM indicators AS T1 INNER JOIN country AS T2 ON T1.CountryCode = T2.CountryCode WHERE T2.Region = 'Sub-Saharan Africa' AND T1.IndicatorName = 'Out-of-school children of primary school age, female (number)'

Database: books
Question: How many orders has Cordy Dumbarton made?
SQL: SELECT COUNT(*) FROM customer AS T1 INNER JOIN cust_order AS T2 ON T1.customer_id = T2.customer_id WHERE T1.first_name = 'Cordy' AND T1.last_name = 'Dumbarton'

Database: world_development_indicators
Question: What's the description of the series code SM.POP.TOTL for Aruba?
Evidence: Aruba is the name of the country where ShortName = 'Aruba'
SQL: SELECT T2.Description FROM Country AS T1 INNER JOIN CountryNotes AS T2 ON T1.CountryCode = T2.Countrycode WHERE T1.ShortName = 'Aruba' AND T2.Seriescode = 'SM.POP.TOTL'

Database: movie_3
Question: Please list the titles of all the films that the customer RUTH MARTINEZ has rented.
SQL: SELECT T4.title FROM customer AS T1 INNER JOIN rental AS T2 ON T1.customer_id = T2.customer_id INNER JOIN inventory AS T3 ON T2.inventory_id = T3.inventory_id INNER JOIN film AS T4 ON T3.film_id = T4.film_id WHERE T1.first_name = 'RUTH' AND T1.last_name = 'MARTINEZ'

Database: synthea
Question: In 2009, who among the married patients had undergone a care plan for more than 60 days?
Evidence: in 2009 refers to year(careplans.START) = 2009; married patients refers to marital = 'M'; undergone a care plan for more than 60 days refers to SUBTRACT(careplans.STOP, careplans.START) > 60;
SQL: SELECT DISTINCT T1.first, T1.last FROM patients AS T1 INNER JOIN careplans AS T2 ON T1.patient = T2.PATIENT WHERE T1.marital = 'M' AND strftime('%J', T2.STOP) - strftime('%J', T2.START) > 60

Database: cars
Question: How many cars were released in the USA in 1981?
Evidence: in the USA refers to country = 'USA'; in 1981 refers to model_year = 1981
SQL: SELECT COUNT(*) FROM production AS T1 INNER JOIN country AS T2 ON T1.country = T2.origin WHERE T2.country = 'USA' AND T1.model_year = 1981

Database: music_tracker
Question: From 1979 to 1982, what was the percentage of united.states albums out of total albums were released?
Evidence: From 1979 to 1982 refers to groupYear between 1979 and 1982; United States refer to tag; albums refer to releaseType; DIVIDE(COUNT(releaseType = 'album' where tag = 'united.states' and groupYear between 1979 and 1982), COUNT(releaseType = 'album' where groupYear between 1979 and 1982)) as percentage;
SQL: SELECT CAST(SUM(CASE WHEN T2.tag LIKE 'united.states' THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(T1.releaseType) FROM torrents AS T1 INNER JOIN tags AS T2 ON T1.id = T2.id WHERE T1.groupYear BETWEEN 1979 AND 1982 AND T1.releaseType LIKE 'album'

Database: shakespeare
Question: Please list any two character names in chapter 18708.
Evidence: character names refers to CharName; chapter 18708 refers to chapter_id = 18708
SQL: SELECT T1.CharName FROM characters AS T1 INNER JOIN paragraphs AS T2 ON T1.id = T2.character_id WHERE T2.chapter_id = 18708 LIMIT 2

Database: movie_3
Question: What is the title of the films in which Cuba Allen acted?
Evidence: 'Cuba Allen' 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 = 'Cuba' AND T1.last_name = 'Allen'

Database: movie_platform
Question: What is the name of the list that was updated most recently?
Evidence: updated most recently refers to MAX(list_update_date_utc)
SQL: SELECT list_title FROM lists WHERE list_update_timestamp_utc = ( SELECT list_update_timestamp_utc FROM lists ORDER BY list_update_timestamp_utc DESC LIMIT 1 )

Database: disney
Question: Determine Disney's total box office gross between 2010 and 2016.
Evidence: between 2010 and 2016 refers to Year between 2010 and 2016;
SQL: SELECT SUM(Total) FROM revenue WHERE `Year` BETWEEN 2010 AND 2016

Database: movies_4
Question: How many movies released in 1995 did Quentin Tarantino appear in?
Evidence: released in 1995 refers to release_date LIKE '1995%'
SQL: SELECT COUNT(T1.movie_id) FROM movie AS T1 INNER JOIN movie_cast AS T2 ON T1.movie_id = T2.movie_id INNER JOIN person AS T3 ON T2.person_id = T3.person_id WHERE T3.person_name = 'Quentin Tarantino' AND CAST(STRFTIME('%Y', T1.release_date) AS INT) = 1995