Database: movie_platform
Question: How many users who created a list in the February of 2016 were eligible for trial when they created the list? Indicate the user id of the user who has the most number of followers in his list in February of 2016.
Evidence: created a list in the February of 2016 refer to list_creation_date_utc BETWEEN 2/1/2016 and 2/29/2016; eligible for trial refers to user_eligible_for_trial = 1;

SQL: SELECT T1.list_followers FROM lists AS T1 INNER JOIN lists_users AS T2 ON T1.user_id = T2.user_id AND T1.list_id = T2.list_id WHERE T2.list_creation_date_utc BETWEEN '2016-02-01' AND '2016-02-29' AND T2.user_eligible_for_trial = 1

Database: shooting
Question: Which are the cases where the subject are female. List the case number, subject status and weapon.
Evidence: female refers to gender = 'F'; weapon refers to subject_weapon
SQL: SELECT T1.case_number, T1.subject_statuses, T1.subject_weapon FROM incidents AS T1 INNER JOIN subjects AS T2 ON T1.case_number = T2.case_number WHERE T2.gender = 'F'

Database: retail_complains
Question: How did Kyran Muller submit his complaint?
Evidence: how it was submitted refers to "Submitted via";
SQL: SELECT DISTINCT T2.`Submitted via` FROM client AS T1 INNER JOIN events AS T2 ON T1.client_id = T2.Client_ID WHERE T1.first = 'Kyran' AND T1.last = 'Muller'

Database: food_inspection_2
Question: How many employees are under Gregory Cardenas?
SQL: SELECT COUNT(T1.employee_id) FROM employee AS T1 WHERE T1.supervisor = ( SELECT employee_id FROM employee WHERE first_name = 'Gregory' AND last_name = 'Cardenas' )

Database: university
Question: List the universities in Denmark.
Evidence: in Denmark refers to country_name = 'Denmark'; name of university refers to university_name;
SQL: SELECT T1.university_name FROM university AS T1 INNER JOIN country AS T2 ON T1.country_id = T2.id WHERE T2.country_name = 'Denmark'

Database: talkingdata
Question: How many events did the device ID "3915082290673130000" join?
SQL: SELECT COUNT(event_id) FROM events WHERE device_id = 3915082290673130000

Database: world_development_indicators
Question: What are the Indicator names and aggregation methods when the topic is Economic Policy & Debt: Balance of payments: Capital & financial account?
SQL: SELECT IndicatorName, AggregationMethod FROM Series WHERE Topic = 'Economic Policy & Debt: Balance of payments: Capital & financial account'

Database: european_football_1
Question: How many Eredivisie teams have played in 2008?
Evidence: Eredivisie is the name of division; 2008 refers to season; teams refer to HomeTeam;
SQL: SELECT COUNT(DISTINCT T1.HomeTeam) FROM matchs AS T1 INNER JOIN divisions AS T2 ON T1.Div = T2.division WHERE T2.name = 'Eredivisie' AND T1.season = 2008

Database: donor
Question: In what percentage of counties has the ABC Read project been launched?
Evidence: ABC Read project been launched refers to title = 'ABC Read'; percentage refers to DIVIDE(count(case when title = 'ABC Read' then school_county else null end),count(school_county))*100
SQL: SELECT CAST(SUM(CASE WHEN T2.title LIKE 'ABC Read' THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(T1.school_county) FROM projects AS T1 INNER JOIN essays AS T2 ON T1.projectid = T2.projectid

Database: beer_factory
Question: Calculate the difference between the number of root beers sold that use cane sugar and corn syrup.
Evidence: difference = SUBTRACT(SUM(CaneSugar = 'TRUE'), SUM(CornSyrup = 'TRUE')); use cane sugar refers to CaneSugar = 'TRUE'; corn syrup refers to CornSyrup = 'TRUE';
SQL: SELECT COUNT(CASE WHEN T3.CaneSugar = 'TRUE' THEN T1.BrandID ELSE NULL END) - COUNT(CASE WHEN T3.CornSyrup = 'TRUE' THEN T1.BrandID ELSE NULL END) AS DIFFERENCE FROM rootbeer AS T1 INNER JOIN `transaction` AS T2 ON T1.RootBeerID = T2.RootBeerID INNER JOIN rootbeerbrand AS T3 ON T1.BrandID = T3.BrandID

Database: public_review_platform
Question: User No."63469" has got "1" like for a tip to the Yelp business, which city is that business located in?
Evidence: user No. refers to user_id;
SQL: SELECT T1.city FROM Business AS T1 INNER JOIN Tips AS T2 ON T1.business_id = T2.business_id WHERE T2.likes = 1 AND T2.user_id = 63469

Database: menu
Question: What is the highest price of the dish "Clear green turtle" on a menu page?
Evidence: highest price refers to MAX(Price); Clear green turtle is a name of dish;
SQL: SELECT T2.price FROM Dish AS T1 INNER JOIN MenuItem AS T2 ON T1.id = T2.dish_id WHERE T1.name = 'Clear green turtle' ORDER BY T2.price DESC LIMIT 1

Database: superstore
Question: Please list the names of all the products ordered by Aimee Bixby in 2016.
Evidence: ordered by Aimee Bixby refers to "Customer Name" = 'Aimee Bixby'; ordered n 2016 refers to strftime('%Y', "Order Date") = '2016';
SQL: SELECT DISTINCT T3.`Product Name` FROM people AS T1 INNER JOIN central_superstore AS T2 ON T1.`Customer ID` = T2.`Customer ID` INNER JOIN product AS T3 ON T3.`Product ID` = T2.`Product ID` WHERE T1.`Customer Name` = 'Aimee Bixby' AND STRFTIME('%Y', T2.`Ship Date`) = '2016'

Database: retails
Question: Among all the suppliers in debt, how many of them are in Europe?
Evidence: in debt refers to s_acctbal < 0; Europe refers to r_name = 'EUROPE'
SQL: SELECT COUNT(T1.n_nationkey) FROM nation AS T1 INNER JOIN region AS T2 ON T1.n_regionkey = T2.r_regionkey INNER JOIN supplier AS T3 ON T1.n_nationkey = T3.s_nationkey WHERE T2.r_name = 'EUROPE' AND T3.s_acctbal < 0

Database: public_review_platform
Question: How many of the busineses are in Casa Grande?
Evidence: in Casa Grande refers to city = 'Casa Grande'
SQL: SELECT COUNT(city) FROM Business WHERE city LIKE 'Casa Grande'

Database: ice_hockey_draft
Question: Which team does Andreas Jamtin belong to?
Evidence: FALSE;
SQL: SELECT DISTINCT T1.TEAM FROM SeasonStatus AS T1 INNER JOIN PlayerInfo AS T2 ON T1.ELITEID = T2.ELITEID WHERE T2.PlayerName = 'Andreas Jamtin'

Database: shipping
Question: Identify the full name of the driver who delivered a shipment to the city of New York in February 2016.
Evidence: "New York" is the city_name; in February 2016 refers to ship_date LIKE '2016-02%'; full name refers to first_name, last_name
SQL: SELECT T3.first_name, T3.last_name FROM shipment AS T1 INNER JOIN city AS T2 ON T1.city_id = T2.city_id INNER JOIN driver AS T3 ON T3.driver_id = T1.driver_id WHERE T2.city_name = 'New York' AND T1.ship_date LIKE '2016-02%'

Database: book_publishing_company
Question: Which type of book had the most pre-paid amount?
Evidence: most pre-paid amount refers to MAX(advance)
SQL: SELECT type FROM titles ORDER BY advance DESC LIMIT 1

Database: movie_platform
Question: For movie titled 'Welcome to the Dollhouse', how many percentage of the ratings were rated with highest score.
Evidence: rated with highest score refers to rating_score = 5; percentage = MULTIPLY(DIVIDE(SUM(rating_score = 5), COUNT(rating_score)), 100)
SQL: SELECT CAST(SUM(CASE WHEN T2.rating_score = 5 THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(*) FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T1.movie_title = 'Welcome to the Dollhouse'

Database: address
Question: What is the average median female age of all the residential areas in the Arecibo county?
Evidence: "ARECIBO" is the county; average median female age = Divide (Sum(median_female_age), Count(country))
SQL: SELECT SUM(T1.female_median_age) / COUNT(T1.zip_code) FROM zip_data AS T1 INNER JOIN country AS T2 ON T1.zip_code = T2.zip_code WHERE T2.county = 'ARECIBO'

Database: citeseer
Question: What is the total number of word cited under that class labelled 'AI'?
SQL: SELECT COUNT(DISTINCT T2.word_cited_id) FROM paper AS T1 INNER JOIN content AS T2 ON T1.paper_id = T2.paper_id WHERE T1.class_label = 'AI'