Database: student_loan
Question: List at least 10 students who have no payment due and are enlisted in Fire Department organization.
Evidence: no payment due refers to bool = 'neg'; organization refers to organ; organ = 'fire_department';
SQL: SELECT T1.name FROM no_payment_due AS T1 INNER JOIN enlist AS T2 ON T2.name = T1.name WHERE T1.bool = 'neg' AND T2.organ = 'fire_department' LIMIT 10

Database: video_games
Question: Provide the ID of the most popular platform in Europe.
Evidence: ID refers to game_platform_id; the most popular refers to max(num_sales); in Europe refers to region_name = 'Europe'
SQL: SELECT T.game_platform_id FROM ( SELECT T1.game_platform_id, SUM(T1.num_sales) FROM region_sales AS T1 INNER JOIN region AS T2 ON T1.region_id = T2.id WHERE T2.region_name = 'Europe' GROUP BY T1.game_platform_id ORDER BY SUM(T1.num_sales) DESC LIMIT 1 ) t

Database: talkingdata
Question: What is the device model used by the most female users over 30?
Evidence: female users refers to gender = 'F'; most female users refers to MAX(COUNT(gender = 'F')); over 30 refers to age > 30;
SQL: SELECT T.device_model FROM ( SELECT T2.device_model, COUNT(T2.device_model) AS num FROM gender_age AS T1 INNER JOIN phone_brand_device_model2 AS T2 ON T1.device_id = T2.device_id WHERE T1.age > 30 AND T1.gender = 'F' GROUP BY T2.device_model ) AS T ORDER BY T.num DESC LIMIT 1

Database: retail_world
Question: List out the phone number of the shipping company of order id 10296.
Evidence: shipping company refers to Shippers; phone number refers to Phone
SQL: SELECT T2.Phone FROM Orders AS T1 INNER JOIN Shippers AS T2 ON T1.ShipVia = T2.ShipperID WHERE T1.OrderID = 10260

Database: movie_3
Question: In which year was the film with the highest replacement cost released?
Evidence: highest replacement_cost refers to Max (replacement_cost); year refers to release_year
SQL: SELECT DISTINCT release_year FROM film WHERE replacement_cost = ( SELECT MAX(replacement_cost) FROM film )

Database: shipping
Question: List the driver's name of the shipment with a weight greater than 95% of the average weight of all shipments.
Evidence: weight greater than 95% of average weight refers to weight > Multiply (AVG(weight), 0.95); driver name refers to first_name, last_name
SQL: SELECT T2.first_name, T2.last_name FROM shipment AS T1 INNER JOIN driver AS T2 ON T1.driver_id = T2.driver_id WHERE T1.weight * 100 > ( SELECT 95 * AVG(weight) FROM shipment )

Database: public_review_platform
Question: How many of the businesses are active?
Evidence: active refers to active = 'true'
SQL: SELECT COUNT(business_id) FROM Business WHERE active LIKE 'True'

Database: law_episode
Question: In which region were the assistant location managers born?
Evidence: region refers to birth_region; assistant location manager refers to role = 'assistant location manager'
SQL: SELECT T2.birth_region FROM Credit AS T1 INNER JOIN Person AS T2 ON T2.person_id = T1.person_id WHERE T1.role = 'president of NBC West Coast'

Database: movie
Question: List the character's name of actress born in Sherman Oaks and starred in the movie Bruce Almighty with height greater than the 50% of average height of all actors listed.
Evidence: actress refers to Gender = 'Female'; born in Sherman Oaks refers to Birth City = 'Sherman Oaks'; movie Bruce Almighty refers to Title = 'Bruce Almighty'; height greater than the 50% of average height refers to Height (Inches) > multiply(avg(Height (Inches)), 0.5)
SQL: SELECT T3.Name FROM movie AS T1 INNER JOIN characters AS T2 ON T1.MovieID = T2.MovieID INNER JOIN actor AS T3 ON T3.ActorID = T2.ActorID WHERE T3.Gender = 'Female' AND T1.Title = 'Godzilla' AND T3.`Birth City` = 'Sherman Oaks' AND T3.`Height (Inches)` * 100 > ( SELECT AVG(`Height (Inches)`) FROM actor ) * 50

Database: legislator
Question: Provide the current legislators' official full names who are from the Independent party.
Evidence: Independent party refers to party = 'Independent'
SQL: SELECT T1.official_full_name FROM current AS T1 INNER JOIN `current-terms` AS T2 ON T1.bioguide_id = T2.bioguide WHERE T2.party = 'Independent' GROUP BY T1.official_full_name

Database: disney
Question: What is the most popular movie directed by Ron Clements?
Evidence: Ron Clements refers to director = 'Ron Clements'; the most popular movie refers to movie_title where MAX(total_gross);
SQL: SELECT T2.name FROM movies_total_gross AS T1 INNER JOIN director AS T2 ON T2.name = T1.movie_title WHERE T2.director = 'Ron Clements' ORDER BY CAST(REPLACE(SUBSTR(total_gross, 2), ',', '') AS int) DESC LIMIT 1

Database: public_review_platform
Question: List down the business ID with a low review count in Phoenix.
Evidence: "Phoenix" is the city; low review count refers to review_count = 'Low'
SQL: SELECT business_id FROM Business WHERE city LIKE 'Phoenix' AND review_count LIKE 'Low'

Database: retail_complains
Question: Which city in the Midwest region has the least number of clients?
Evidence: least number of clients refers to min(count(client_id))
SQL: SELECT T2.city FROM client AS T1 INNER JOIN district AS T2 ON T1.district_id = T2.district_id INNER JOIN state AS T3 ON T2.state_abbrev = T3.StateCode WHERE T3.Region = 'Midwest' GROUP BY T2.city ORDER BY COUNT(T2.city) LIMIT 1

Database: legislator
Question: Provide the address of the legislator with the contact form of http://www.carper.senate.gov/contact/.
SQL: SELECT address FROM `current-terms` WHERE contact_form = 'http://www.carper.senate.gov/contact/'

Database: simpson_episodes
Question: How many people who were born after 1970 are animation executive producer?
Evidence: born after 1980 refers to birthdate > 1970; assistant to the producers refers to role = 'animation executive producer'
SQL: SELECT COUNT(*) FROM Person AS T1 INNER JOIN Credit AS T2 ON T1.name = T2.person WHERE STRFTIME(T1.birthdate) > '1970' AND T2.role = 'animation executive producer';

Database: movies_4
Question: How many production companies does the movie "Four Rooms" have?
Evidence: movie "Four Rooms" refers to title = 'Four Rooms'
SQL: SELECT COUNT(CNAME) FROM ( SELECT T1.company_name AS CNAME FROM production_company AS T1 INNER JOIN movie_company AS T2 ON T1.company_id = T2.company_id INNER JOIN movie AS T3 ON T2.movie_id = T3.movie_id WHERE T3.title = 'Four Rooms' )

Database: world_development_indicators
Question: Which country have the highest CO2 emissions in 1960?
Evidence: which country refers to countryname; the highest CO2 emissions refers to max(value where indicatorname = 'CO2 emissions (metric tons per capita)'); in 1960 refers to year = '1970'
SQL: SELECT CountryName FROM Indicators WHERE Year = 1960 AND IndicatorName = 'CO2 emissions (metric tons per capita)' ORDER BY Value DESC LIMIT 1

Database: image_and_language
Question: How many samples of clouds are there in the image no.2315533?
Evidence: samples of clouds refer to IMG_ID where OBJ_CLASS = 'cloud'; image no.2315533 refers to IMG_ID = 2315533;
SQL: SELECT SUM(CASE WHEN T1.IMG_ID = 2315533 THEN 1 ELSE 0 END) FROM IMG_OBJ AS T1 INNER JOIN OBJ_CLASSES AS T2 ON T1.OBJ_CLASS_ID = T2.OBJ_CLASS_ID WHERE T2.OBJ_CLASS = 'clouds'

Database: movielens
Question: How many different actors have played a role in the highest rating movie?
Evidence: highest rating of a movie is 5
SQL: SELECT COUNT(DISTINCT T2.actorid) FROM u2base AS T1 INNER JOIN movies2actors AS T2 ON T1.movieid = T2.movieid WHERE T1.rating = 5

Database: authors
Question: Among the papers with conference ID of 0, list down the authors of papers with a journal ID less than 100.
Evidence: Conference ID of 0 refers to ConferenceId = 0; journal ID of less than 100 refers to JournalId < 100
SQL: SELECT DISTINCT T2.Name FROM Paper AS T1 INNER JOIN PaperAuthor AS T2 ON T1.Id = T2.PaperId WHERE T1.ConferenceId = 0 AND T1.JournalId < 100