Database: talkingdata
Question: State the number of users who are under 50 and above 20 use device model of Galaxy Premier.
Evidence: under 50 and above 20 refers to age BTWEEEN 20 AND 50;
SQL: SELECT COUNT(T1.device_id) FROM gender_age AS T1 INNER JOIN phone_brand_device_model2 AS T2 ON T1.device_id = T2.device_id WHERE T1.age BETWEEN 20 AND 50 AND T2.device_model = 'Galaxy Premier'

Database: movie_platform
Question: User 58149469's critic on which film got 1 like and 2 comments?
Evidence: user 58149469 refers to user_id = 58149469; critic with 1 like refers to critic_likes = 1; critic with 2 comments refers to critic_comments = 2;
SQL: SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T1.user_id = 58149469 AND T1.critic_likes = 1 AND T1.critic_comments = 2

Database: movie_platform
Question: What's the description of user 85981819's movie list with the most followers?
Evidence: user 85981819 refers to user_id = 85981819; most followers refers to Max(list_followers); description refers to list_descriptions;
SQL: SELECT T1.list_description FROM lists AS T1 INNER JOIN lists_users AS T2 ON T1.list_id = T2.list_id AND T1.user_id = T2.user_id WHERE T1.user_id = 85981819 ORDER BY T1.list_followers DESC LIMIT 1

Database: movie_platform
Question: Among the lists created by user 4208563, which one has the highest number of followers? Indicate how many followers it has and whether the user was a subscriber or not when he created the list.
Evidence: User 4208563 refers to user_id;highest number of followers refers to MAX(list_followers); user_subscriber = 1 means that the user was a subscriber when he created the list; user_subscriber = 0 means the user was not a subscriber when he created the list (to replace)
SQL: SELECT T1.list_followers, T2.user_subscriber = 1 FROM lists AS T1 INNER JOIN lists_users AS T2 ON T1.user_id = T2.user_id AND T2.list_id = T2.list_id WHERE T2.user_id = 4208563 ORDER BY T1.list_followers DESC LIMIT 1

Database: law_episode
Question: Write down the title, summary, and air date of the episode that garnered 72 10-star votes.
Evidence: 72 10-star votes refers to stars = 10 and votes = 72
SQL: SELECT T2.title, T2.summary, T2.air_date FROM Vote AS T1 INNER JOIN Episode AS T2 ON T2.episode_id = T1.episode_id WHERE T1.stars = 10 AND T1.votes = 72

Database: authors
Question: How many of the papers are preprinted?
Evidence: year = 0 means this paper is preprint; papers refers to Paper.Id
SQL: SELECT COUNT(Id) FROM Paper WHERE ConferenceId = 0 AND JournalId = 0

Database: law_episode
Question: List the names of all the cast members in the series.
Evidence: cast member refers to category = 'Cast'
SQL: SELECT T2.name FROM Credit AS T1 INNER JOIN Person AS T2 ON T2.person_id = T1.person_id WHERE T1.category = 'Cast'

Database: simpson_episodes
Question: State the number of votes for episode with rating of 7 and above.
Evidence: rating of 7 and above refers to rating > 7.0
SQL: SELECT votes FROM Episode WHERE rating > 7;

Database: talkingdata
Question: What is the average age of the female users who uses a vivo device?
Evidence: average age = AVG(age); female refers to gender = 'F'; vivo device refers to phone_brand = 'vivo';
SQL: SELECT AVG(T1.age) FROM gender_age AS T1 INNER JOIN phone_brand_device_model2 AS T2 ON T1.device_id = T2.device_id WHERE T2.phone_brand = 'vivo' AND T1.gender = 'F'

Database: movie_platform
Question: What is the name of the longest movie title? When was it released?
Evidence: longest movie title refers to MAX(LENGTH(movie_title)); when it was released refers to movie_release_year;
SQL: SELECT movie_title, movie_release_year FROM movies ORDER BY LENGTH(movie_popularity) DESC LIMIT 1

Database: authors
Question: Please list the names of the authors of the paper "Hypermethylation of the <I>TPEF/HPP1</I> Gene in Primary and Metastatic Colorectal Cancers".
Evidence: paper "Hypermethylation of the <I>TPEF/HPP1</I> Gene in Primary and Metastatic Colorectal Cancers" refers to Title = 'Hypermethylation of the <I>TPEF/HPP1</I> Gene in Primary and Metastatic Colorectal Cancers'
SQL: SELECT T2.Name FROM Paper AS T1 INNER JOIN PaperAuthor AS T2 ON T1.Id = T2.PaperId WHERE T1.Title = 'Hypermethylation of the <I>TPEF/HPP1</I> Gene in Primary and Metastatic Colorectal Cancers'

Database: address
Question: What is the name of the CBSA of the city with the highest average house value?
Evidence: the highest average house value refers to avg_house_value;
SQL: SELECT DISTINCT T1.CBSA_name FROM CBSA AS T1 INNER JOIN zip_data AS T2 ON T1.CBSA = T2.CBSA WHERE T2.avg_house_value = ( SELECT MAX(avg_house_value) FROM zip_data ) LIMIT 1

Database: talkingdata
Question: Among the female users of the devices, how many of them are under 30?
Evidence: female refers to gender = 'F'; under 30 refers to age < 30;
SQL: SELECT COUNT(device_id) FROM gender_age WHERE age < 30 AND gender = 'F'

Database: music_tracker
Question: Among the artists with the id from 10 to 30. Which artist released the product with the tag "funk" in 1980?
Evidence: id from 10 to 30 refers to id between 10 and 30; groupYear = 1980;
SQL: SELECT T1.artist FROM torrents AS T1 INNER JOIN tags AS T2 ON T1.id = T2.id WHERE T2.tag = 'funk' AND T1.groupYear = 1980 AND T1.id BETWEEN 10 AND 30

Database: music_platform_2
Question: What are the titles of the podcasts whose reviews were created between 2018-08-22T11:53:16-07:00 and 2018-11-20T11:14:20-07:00?
Evidence: created between 2018-08-22T11:53:16-07:00 and 2018-11-20T11:14:20-07:00 refers to created at BETWEEN '2018-08-22T11:53:16-07:00' and '2018-11-20T11:14:20-07:00'
SQL: SELECT DISTINCT T1.title FROM podcasts AS T1 INNER JOIN reviews AS T2 ON T2.podcast_id = T1.podcast_id WHERE T2.created_at BETWEEN '2018-08-22T11:53:16-07:00' AND '2018-11-20T11:14:20-07:00'

Database: books
Question: What is the name of the publisher that has published the most number of books?
Evidence: name of publisher refers to publisher_name; publisher published the most number of books refers to Max(Count(book_id))
SQL: SELECT T2.publisher_name FROM book AS T1 INNER JOIN publisher AS T2 ON T1.publisher_id = T2.publisher_id GROUP BY T2.publisher_name ORDER BY COUNT(T1.book_id) DESC LIMIT 1

Database: retail_world
Question: Who is the person to contact to get Camembert Pierrot?
Evidence: Camembert Pierrot is the name of the product; person to contact refers to ContactName;
SQL: SELECT T2.ContactName FROM Products AS T1 INNER JOIN Suppliers AS T2 ON T1.SupplierID = T2.SupplierID WHERE T1.ProductName = 'Camembert Pierrot'

Database: movies_4
Question: What is the gender of the character 'USAF Master Sgt. Epps?'
Evidence: character 'USAF Master Sgt. Epps' refers to character_name = 'USAF Master Sgt. Epps'
SQL: SELECT T2.gender FROM movie_cast AS T1 INNER JOIN gender AS T2 ON T1.gender_id = T2.gender_id WHERE T1.character_name = 'USAF Master Sgt. Epps'

Database: world
Question: How many cities are there in the country with the largest surface area?
Evidence: largest surface area refers to MAX(SurfaceArea);
SQL: SELECT T2.ID FROM Country AS T1 INNER JOIN City AS T2 ON T1.Code = T2.CountryCode WHERE T1.SurfaceArea = ( SELECT MAX(SurfaceArea) FROM Country )

Database: food_inspection_2
Question: How many of the inspections with serious point levels have no fines?
Evidence: serious point level refers to point_level = 'Serious'; no fines refers to fine = 0
SQL: SELECT COUNT(DISTINCT T2.inspection_id) FROM inspection_point AS T1 INNER JOIN violation AS T2 ON T1.point_id = T2.point_id WHERE T1.point_level = 'Serious ' AND T2.fine = 0

Database: address
Question: What are the alias of the cities with 0 population in 2010?
Evidence: with 0 population in 2010 refers to population_2010 = 0;
SQL: SELECT DISTINCT T1.alias FROM alias AS T1 INNER JOIN zip_data AS T2 ON T1.zip_code = T2.zip_code WHERE T2.population_2010 = 0