Database: talkingdata
Question: Please list the device models of all the devices used by a user in the M23-26 user group.
Evidence: M23-26 user group refers to `group` = 'M23-26';
SQL: SELECT T2.device_model FROM gender_age AS T1 INNER JOIN phone_brand_device_model2 AS T2 ON T1.device_id = T2.device_id WHERE T1.`group` = 'M23-26'

Database: donor
Question: What is the total number of students impacted by the projects with a donation from a donor with zip code "22205"?
Evidence: zip code "22205" refers to donor_zip = '22205'; students impacted refers to students_reached
SQL: SELECT SUM(T2.students_reached) FROM donations AS T1 INNER JOIN projects AS T2 ON T1.projectid = T2.projectid WHERE T1.donor_zip = 22205

Database: public_review_platform
Question: In how many businesses have customers had a bad or terrible experience?
Evidence: stars = 2 means bad experience; stars = 1 means terrible experience; customers had a bad or terrible experience refers to stars = 2 OR stars = 1
SQL: SELECT COUNT(business_id) FROM Business WHERE stars IN (1, 2)

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

Database: movie_3
Question: What is the inventory ID of the films starred by Russell Close with a duration between 110 to 150 minutes?
Evidence: 'Russell Close' is a full name of an actor; full name refers to first_name, last_name; duration between 110 to 150 minutes refers to length BETWEEN 110 AND 150
SQL: SELECT T4.inventory_id 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 INNER JOIN inventory AS T4 ON T3.film_id = T4.film_id WHERE T3.length BETWEEN 110 AND 150 AND T1.first_name = 'Russell' AND T1.last_name = 'Close'

Database: talkingdata
Question: Please list any three OPPO device models.
Evidence: OPPO refers to phone_brand = 'OPPO';
SQL: SELECT device_model FROM phone_brand_device_model2 WHERE phone_brand = 'OPPO' LIMIT 3

Database: codebase_comments
Question: What the percentage of the english methods among the methods whose comments is XML format?
Evidence: english methods refers to lang = 'en'; comment is XML format refers to CommentIsXml = 1;
SQL: SELECT CAST(SUM(CASE WHEN Lang = 'en' THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(Name) FROM Method WHERE CommentIsXml = 1

Database: student_loan
Question: How many disabled students are male?
Evidence: male students are mentioned in male.name;
SQL: SELECT COUNT(T1.name) FROM male AS T1 INNER JOIN disabled AS T2 ON T1.name = T2.name

Database: movies_4
Question: List the character names in the "Open Water" movie.
Evidence: "Open Water" movie refers to title = 'Open Water'
SQL: SELECT T2.character_name FROM movie AS T1 INNER JOIN movie_cast AS T2 ON T1.movie_id = T2.movie_id WHERE T1.title = 'Open Water'

Database: authors
Question: Please list the titles of the papers published in the journal "Concepts in Magnetic Resonance Part A" in 2008.
Evidence: journal "Concepts in Magnetic Resonance Part A" refers to FullName = 'Concepts in Magnetic Resonance Part A'; in 2018 refers to Year = 2018
SQL: SELECT T2.Title FROM Journal AS T1 INNER JOIN Paper AS T2 ON T1.Id = T2.JournalId WHERE T1.FullName = 'Concepts in Magnetic Resonance Part A' AND T2.Year = 2008

Database: retail_complains
Question: List the full name and phone number of clients who submitted the complaint via fax.
Evidence: full name = first, middle, last; submitted the complaint via fax refers to "Submitted via" = 'fax';
SQL: SELECT T1.first, T1.middle, T1.last, T1.phone FROM client AS T1 INNER JOIN events AS T2 ON T1.client_id = T2.Client_ID WHERE T2.`Submitted via` = 'Fax'

Database: retail_world
Question: What is the difference in the number of employees from the UK and the USA who work as sales representatives?
Evidence: SUBTRACT(COUNT(EmployeeID where Country = 'UK' and Title = 'sales representative'), COUNT(EmployeeID where Country = 'USA' and Title = 'sales representative'));
SQL: SELECT ( SELECT COUNT(Title) FROM Employees WHERE Country = 'UK' AND Title = 'Sales Representative' ) - ( SELECT COUNT(Title) FROM Employees WHERE Country = 'USA' AND Title = 'Sales Representative' ) AS DIFFERENCE

Database: movie
Question: List the runtime of movies starred by an African-American actor born on December 28, 1954.
Evidence: African-American refers to Ethnicity = 'African American'; born on December 28 1954 refers to Date of Birth = '1954-12-28'
SQL: SELECT T1.Runtime 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.Ethnicity = 'African American' AND T3.`Date of Birth` = '1954-12-28'

Database: airline
Question: What is the IATA code of the Anita Bay Airport in Anita Bay, Alaska?
Evidence: IATA code refers to Code; Anita Bay Airport in Anita Bay, Alaska refers to Description = 'Anita Bay, AK: Anita Bay Airport';
SQL: SELECT Code FROM Airports WHERE Description = 'Anita Bay, AK: Anita Bay Airport'

Database: soccer_2016
Question: Describe any five matches IDs that reached over ID 20.
Evidence: reached over ID 20 refers to Over_Id = 20
SQL: SELECT Match_Id FROM Ball_by_Ball WHERE Over_Id = 20 GROUP BY Match_Id LIMIT 5

Database: professional_basketball
Question: Among the players who went to high school in Chicago, how many of them belongs to the west conference?
Evidence: high school in Chicago refers to hsCity = 'Chicago'; belong to the west conference refers to divID = 'WE'
SQL: SELECT COUNT(DISTINCT T1.playerID) FROM players AS T1 INNER JOIN player_allstar AS T2 ON T1.playerID = T2.playerID WHERE T1.hsCity = 'Chicago' AND T2.conference = 'West'

Database: trains
Question: Among the trains that have at least one non-regular shaped car, what is the percentage of it running in the east direction?
Evidence: non-regular shaped car refers to shape in ('bucket', 'ellipse'); calculation = MULTIPLY(DIVIDE(count(direction = 'east' then train_id)), count(train_id), 100)
SQL: SELECT CAST(COUNT(DISTINCT CASE WHEN T2.direction = 'east' THEN T1.train_id ELSE NULL END) AS REAL) * 100 / COUNT(DISTINCT T1.train_id) FROM cars AS T1 INNER JOIN trains AS T2 ON T1.train_id = T2.id WHERE T1.shape IN ('bucket', 'ellipse')

Database: restaurant
Question: How many restaurants have not obtained a minimum of 3 in their reviews?
Evidence: have not obtained a minimum of 3 in review refers to review < 3
SQL: SELECT COUNT(id_restaurant) FROM generalinfo WHERE review < 3

Database: movie_platform
Question: What is the average number of followers of the lists created by the user who rated the movie "Pavee Lackeen: The Traveller Girl" on 3/27/2011 at 2:06:34 AM?
Evidence: average number of followers refers to AVG(list_followers); movie "Pavee Lackeen: The Traveller Girl" refers to movie_title = 'Pavee Lackeen: The Traveller Girl'; on 3/27/2011 at 2:06:34 AM refers to rating_timestamp_utc = '2011-03-27 02:06:34'
SQL: SELECT CAST(SUM(T4.list_followers) AS REAL) / COUNT(T2.list_id) FROM ratings AS T1 INNER JOIN lists_users AS T2 ON T1.user_id = T2.user_id INNER JOIN movies AS T3 ON T1.movie_id = T3.movie_id INNER JOIN lists AS T4 ON T2.list_id = T4.list_id WHERE T3.movie_title LIKE 'Pavee Lackeen: The Traveller Girl' AND T1.rating_timestamp_utc LIKE '2011-03-27 02:06:34'

Database: video_games
Question: Calculate the average game sales for the PS2 platform.
Evidence: average = AVG(MULTIPLY(num_sales), 100000); PS2 refers to platform_name = 'PS2';
SQL: SELECT SUM(T3.num_sales * 100000) / COUNT(T1.id) FROM platform AS T1 INNER JOIN game_platform AS T2 ON T1.id = T2.platform_id INNER JOIN region_sales AS T3 ON T2.id = T3.game_platform_id WHERE T1.platform_name = 'PS2'