Database: simpson_episodes
Question: Write down the title and summary of the episode with the keyword 'eviction.'
SQL: SELECT T1.title, T1.summary FROM Episode AS T1 INNER JOIN Keyword AS T2 ON T1.episode_id = T2.episode_id WHERE T2.keyword = 'eviction';

Database: retail_world
Question: What is the average annual amount of shipped sales from 1997 to 1998?
Evidence: from 1997 to 1998 refers to ShippedDate > '1996-1-1' and ShippedDate < '1998-12-31'; average annual amount refers to SUM(MULTIPLY(UnitPrice, Quantity, SUBTRACT(1, Discount)))
SQL: SELECT SUM(T2.UnitPrice * T2.Quantity * (1 - T2.Discount)) / 3 FROM Orders AS T1 INNER JOIN `Order Details` AS T2 ON T1.OrderID = T2.OrderID WHERE T1.ShippedDate BETWEEN '1996-01-01 00:00:00' AND '1998-12-31 23:59:59'

Database: simpson_episodes
Question: List the nominee, keywords and episode ID of the title "The Good, the Sad and the Drugly".
Evidence: nominee refers to result = 'Nominee'
SQL: SELECT T3.person, T1.keyword, T1.episode_id FROM Keyword AS T1 INNER JOIN Episode AS T2 ON T1.episode_id = T2.episode_id INNER JOIN Award AS T3 ON T2.episode_id = T3.episode_id WHERE T2.title = 'The Good, the Sad and the Drugly' AND T3.result = 'Nominee';

Database: retail_complains
Question: How many complaints were served in 5 minutes or less by DORIT and responded to the customer with an explanation, were made by phone?
Evidence: served in 5 minutes or less refers to ser_time < '00:05:00'; DORIT refers to server = 'DORIT'; responded with an explanation refers to "Company response to consumer" = 'Closed with explanation'; made by refers to "Submitted via";
SQL: SELECT COUNT(T1.`Complaint ID`) FROM callcenterlogs AS T1 INNER JOIN events AS T2 ON T1.`Complaint ID` = T2.`Complaint ID` WHERE T1.ser_time < '00:05:00' AND T1.server = 'DORIT' AND T2.`Submitted via` = 'Phone' AND T2.`Company response to consumer` = 'Closed with explanation'

Database: retail_complains
Question: Which state does the owner of "wyatt.collins@gmail.com" live in? Give the full name of the state.
Evidence: full name of the state refers to state_name;
SQL: SELECT T1.state FROM client AS T1 INNER JOIN district AS T2 ON T1.district_id = T2.district_id WHERE T1.email = 'wyatt.collins@gmail.com'

Database: public_review_platform
Question: How many users received high compliment type in photo?
Evidence: high compliments refers to number_of_compliments = 'High'; type in photo refers to compliment_ID = 1
SQL: SELECT COUNT(T1.user_id) FROM Users_Compliments AS T1 INNER JOIN Compliments AS T2 ON T1.compliment_id = T2.compliment_id WHERE T1.number_of_compliments LIKE 'High' AND T2.compliment_id = 1

Database: public_review_platform
Question: How many businesses ID sell beer and wine?
Evidence: attribute_value = 'beer_and_wine'
SQL: SELECT COUNT(business_id) FROM Business_Attributes WHERE attribute_id = 1 AND attribute_value = 'beer_and_wine'

Database: movies_4
Question: Which movies have the participation of actor Harrison Ford?
Evidence: Which movies refers to title; actor refers to person_name
SQL: SELECT T1.title 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 = 'Harrison Ford'

Database: image_and_language
Question: Which object in image 8 is the widest? State its object sample ID.
Evidence: widest relates to the width of the bounding
box of the object which refers to MAX(W); object in image 8 refers to OBJ_SAMPLE_ID where IMG_ID = 8;
SQL: SELECT OBJ_SAMPLE_ID FROM IMG_OBJ WHERE IMG_ID = 8 ORDER BY W DESC LIMIT 1

Database: genes
Question: What are the functions of the pair of genes that have the lowest expression correlation score?a
SQL: SELECT T1.Function FROM Genes AS T1 INNER JOIN Interactions AS T2 ON T1.GeneID = T2.GeneID1 ORDER BY T2.Expression_Corr ASC LIMIT 1

Database: talkingdata
Question: Is the oldest device user male or female?
Evidence: MAX(Age) AND gender = 'M' means that the oldest device user is male; MAX(Age) AND gender = 'F' means that the oldest device user is female;
SQL: SELECT gender FROM gender_age WHERE age = ( SELECT MAX(age) FROM gender_age )

Database: retail_world
Question: What is the highest total price paid for an order?
Evidence: the highest total price paid for an order can be calculated as MAX(MULTIPLY(UnitPrice, Quantity, SUBTRACT(1-Discount)));
SQL: SELECT UnitPrice * Quantity * (1 - Discount) AS THETOP FROM `Order Details` ORDER BY UnitPrice * Quantity * (1 - Discount) DESC LIMIT 1

Database: book_publishing_company
Question: List all titles which have year to date sales higher than the average order by pubisher name.
Evidence: year to date sales refers to ytd_sales; average order = AVG(ytd_sales)
SQL: SELECT T1.title FROM titles AS T1 INNER JOIN publishers AS T2 ON T1.pub_id = T2.pub_id WHERE T1.ytd_sales > ( SELECT AVG(ytd_sales) FROM titles )

Database: movie_3
Question: How many addresses are there in Woodridge city?
Evidence: "Woodridge" is the city
SQL: SELECT COUNT(T1.address_id) FROM address AS T1 INNER JOIN city AS T2 ON T1.city_id = T2.city_id WHERE T2.city = 'Woodridge'

Database: retail_complains
Question: What is the average age of clients in South Atlantic?
Evidence: in South Atlantic refers to division = 'South Atlantic'; average age refers to avg(age)
SQL: SELECT AVG(T1.age) FROM client AS T1 INNER JOIN district AS T2 ON T1.district_id = T2.district_id WHERE T2.division = 'South Atlantic'

Database: book_publishing_company
Question: Please list the first names of the employees who work as Managing Editor.
Evidence: Managing Editor is a job description which refers to job_desc
SQL: SELECT T1.fname FROM employee AS T1 INNER JOIN jobs AS T2 ON T1.job_id = T2.job_id WHERE T2.job_desc = 'Managing Editor'

Database: legislator
Question: Among the legislators who have served in the U.S. House, provide the party and the state of the legislators who were born in 1738.
Evidence: have served in the U.S. House refers to house_history_id IS NOT NULL; born in 1738 refers to birthday_bio = 1738
SQL: SELECT T1.party, T1.state FROM `historical-terms` AS T1 INNER JOIN historical AS T2 ON T2.bioguide_id = T1.bioguide WHERE T2.house_history_id IS NOT NULL AND T2.birthday_bio LIKE '%1738%'

Database: world
Question: What are the official languages of the country where you can find the city with the least population?
Evidence: official language refers to IsOfficial = 'T'; least population refers to MIN(Population);
SQL: SELECT T2.Language FROM City AS T1 INNER JOIN CountryLanguage AS T2 ON T1.CountryCode = T2.CountryCode WHERE T2.IsOfficial = 'T' ORDER BY T1.Population ASC LIMIT 1

Database: student_loan
Question: Give the number of students who enlisted in marines and have payment due.
Evidence: marines refers to organ = 'marines'; have payment due refers to bool = 'pos';
SQL: SELECT COUNT(T1.name) FROM no_payment_due AS T1 INNER JOIN enlist AS T2 ON T1.name = T2.name WHERE T1.bool = 'pos' AND T2.organ = 'marines'

Database: car_retails
Question: List the country and how many customers are there.
SQL: SELECT country, COUNT(customerNumber) FROM customers GROUP BY country

Database: legislator
Question: How many current legislators do not have an account on instagram?
Evidence: do not have an account on instagram refers to instagram is null
SQL: SELECT COUNT(*) FROM `social-media` AS T1 INNER JOIN current AS T2 ON T1.bioguide = T2.bioguide_id WHERE T1.instagram IS NULL

Database: simpson_episodes
Question: Which episode ids are rated 5 stars and have more than 100 votes?
Evidence: more than 100 votes refers to votes > 100
SQL: SELECT episode_id FROM Vote WHERE stars = 5 AND votes > 100;

Database: authors
Question: List the name of the author that affiliated with University of Illinois Chicago?
Evidence: 'University of Illinois Chicago' is an affiliation
SQL: SELECT Name FROM Author WHERE Affiliation = 'University of Illinois Chicago'