Database: professional_basketball
Question: Please list out the first name and last name of player who attended California college and have been selected as all stars?
Evidence: California college refers to college = 'California'
SQL: SELECT DISTINCT T1.firstName, T1.lastName FROM players AS T1 INNER JOIN player_allstar AS T2 ON T1.playerID = T2.playerID WHERE T1.college = 'California'

Database: world_development_indicators
Question: What is the name of the country with the highest percentage of rural population in the overall total population? Indicate the rural population percentage of total population.
Evidence: the highest percentage of rural population in the overall total population refers to max(value where indicatorname = 'Rural population (% of total population)')
SQL: SELECT countryname, MAX(value) FROM indicators WHERE indicatorname = 'Rural population (% of total population)'

Database: image_and_language
Question: List out the number of object samples in image no.41 which are in the class of "kitchen"?
Evidence: object samples in the class of "kitchen" refer to OBJ_CLASS_ID where OBJ_CLASS = 'kitchen'; image no.41 refers to IMG_ID = 41 ;
SQL: SELECT SUM(CASE WHEN T2.OBJ_CLASS = 'kitchen' 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 T1.IMG_ID = 41

Database: language_corpus
Question: Calculate the average number of repetitions in the pairs of words in which the first word id is number 34.
Evidence: Pair is a relationship of two words: w1st and w2nd, where w1st is word id of the first word and w2nd is a word id of the second word; the first word id number 34 refers to w1st = 34; repetition refers to occurrences or times this pair appears; DIVIDE(SUM(occurrences where w1st = 34), COUNT(occurrences where w1st = 34));
SQL: SELECT CAST(SUM(CASE WHEN w1st = 34 THEN 1 ELSE 0 END) AS REAL) / COUNT(w1st) FROM biwords

Database: movie_platform
Question: How many directors have directed atleast 10 movies between 1960 to 1985? Indicate the name of the movie in those years of each director that received the highest amount of 5 rating score.
Evidence: directed at least 10 movies refers to count(direct_name)>10; 1960 to 1985 refer to movie_release_year

SQL: SELECT T2.director_name FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T2.movie_release_year BETWEEN 1960 AND 1985 GROUP BY T2.director_name HAVING COUNT(T2.movie_id) > 10

Database: sales
Question: Identify customer IDs who bought products priced from 1000 to 2000.
Evidence: priced from 1000 to 2000 refers to Price BETWEEN 1000 AND 2000;
SQL: SELECT DISTINCT T2.CustomerID FROM Products AS T1 INNER JOIN Sales AS T2 ON T1.ProductID = T2.ProductID WHERE T1.Price BETWEEN 1000 AND 2000

Database: synthea
Question: What care plans have been received by Mrs. Elly Koss during year 1970?
Evidence: during year 1970 refers to substr(careplans.START, 1, 4) = '1970' and substr(careplans.STOP, 1, 4) = '1970';
SQL: SELECT T2.DESCRIPTION FROM patients AS T1 INNER JOIN careplans AS T2 ON T1.patient = T2.PATIENT WHERE T1.first = 'Elly' AND T1.last = 'Koss' AND strftime('%Y', T2.START) = '2013'

Database: trains
Question: What is the direction of the train with a diamond-shaped load in its 2nd car?
Evidence: 2nd car refers to position = 2
SQL: SELECT T2.direction FROM cars AS T1 INNER JOIN trains AS T2 ON T1.train_id = T2.id WHERE T1.position = 2 AND T1.shape = 'diamond'

Database: soccer_2016
Question: Please list the IDs of all the matches in the year 2008.
Evidence: ID of matches refers to Match_Id; in the year 2008 refers to SUBSTR(Match_Date, 1, 4) = '2008'
SQL: SELECT Match_Id FROM `Match` WHERE SUBSTR(Match_Date, 1, 4) = '2008'

Database: sales
Question: List the first name of all the customers whose last name is Chen.
SQL: SELECT FirstName, LastName FROM Customers WHERE LastName = 'Chen'

Database: retail_world
Question: How many owners are located in Mexico?
Evidence: owners in Mexico refer to ContactTitle where Country = 'Mexico';
SQL: SELECT COUNT(ContactTitle) FROM Customers WHERE Country = 'Mexico' AND ContactTitle = 'Owner'

Database: social_media
Question: Calculate the total number of male tweet IDs.
Evidence: "Male" is the Gender
SQL: SELECT COUNT(T1.TweetID) FROM twitter AS T1 INNER JOIN user AS T2 ON T1.UserID = T2.UserID WHERE T2.Gender = 'Male'

Database: shakespeare
Question: What percentage of all scenes are tragic scenes in Shakespeare's work in 1594?
Evidence: tragic scenes refers to GenreType = 'Tragedy'; work in 1594 refers to Date = '1594'; percentage = divide((sum(Scene) when GenreType = 'Tragedy'), count(Scene))as percentage
SQL: SELECT CAST(SUM(IIF(T2.GenreType = 'Tragedy', 1, 0)) AS REAL) * 100 / COUNT(T1.Scene) FROM chapters AS T1 INNER JOIN works AS T2 ON T1.work_id = T2.id WHERE T2.Date = '1594'

Database: public_review_platform
Question: Which business ID received the review of 4 star and above by 65% of user? Describe their active status and city.
Evidence: review of 4 star and above refers to stars > 4; DIVIDE(SUM(stars > 4), COUNT(business_id)) = 0.65;
SQL: SELECT DISTINCT T2.business_id, T2.city FROM Reviews AS T1 INNER JOIN Business AS T2 ON T1.business_id = T2.business_id WHERE T1.review_stars >= 4 AND ( SELECT CAST(( SELECT COUNT(DISTINCT T1.user_id) FROM Reviews AS T1 INNER JOIN Business AS T2 ON T1.business_id = T2.business_id WHERE T1.review_stars >= 4 ) AS REAL) * 100 / ( SELECT COUNT(user_id) FROM Users ) > 65 )

Database: legislator
Question: How many legislators are not senator?
Evidence: not senator refers to class is null;
SQL: SELECT COUNT(bioguide) FROM `current-terms` WHERE class IS NULL

Database: professional_basketball
Question: What is the nickname of the NBA player whose team competed in the Western Conference in the season 2006 and who had a total of two blocks?
Evidence: completed in the Western conference refers to conference = 'West'; in season 2006 refers to season_id = 2006; total of two blocks refers to blocks = 2; nickname refers to nameNick
SQL: SELECT T2.nameNick FROM player_allstar AS T1 INNER JOIN players AS T2 ON T1.playerID = T2.playerID WHERE T1.blocks = 2 AND T1.conference = 'West' AND T1.season_id = 2006

Database: sales
Question: What is the total cost of all the "Road-650, Red, 60" products that Abraham E. Bennet sold?
Evidence: total cost = SUM(MULTIPLY(Quantity, Price)); 'Road-650, Red, 60' is name of product;
SQL: SELECT SUM(T2.Quantity * T3.Price) FROM Employees AS T1 INNER JOIN Sales AS T2 ON T1.EmployeeID = T2.SalesPersonID INNER JOIN Products AS T3 ON T2.ProductID = T3.ProductID WHERE T1.FirstName = 'Abraham' AND T1.MiddleInitial = 'e' AND T1.LastName = 'Bennet' AND T3.Name = 'Road-650 Red, 60'

Database: student_loan
Question: How many students have been absent above 2 months?
Evidence: absent above 2 months refers to month > 2;
SQL: SELECT COUNT(name) FROM longest_absense_from_school WHERE month > 2

Database: public_review_platform
Question: Among the Yelp_Businesses in Arizona, how many of them are still running?
Evidence: Arizona refers to state = 'AZ'; still running refers to active = 'true';
SQL: SELECT COUNT(business_id) FROM Business WHERE state LIKE 'AZ' AND active LIKE 'True'

Database: music_platform_2
Question: What is the content of the earliest review for the "Stuff You Should Know" podcast?
Evidence: "Stuff You Should Know" is the title of podcast; earliest refers to Min(created_at)
SQL: SELECT T2.content FROM podcasts AS T1 INNER JOIN reviews AS T2 ON T2.podcast_id = T1.podcast_id WHERE T1.title = 'Stuff You Should Know' ORDER BY T2.created_at ASC LIMIT 1

Database: app_store
Question: List all the negative comments on the "Dog Run - Pet Dog Simulator" app.
Evidence: negative comment refers to Sentiment = 'Negative';
SQL: SELECT Translated_Review FROM user_reviews WHERE App = 'Dog Run - Pet Dog Simulator' AND Sentiment = 'Negative'