Database: public_review_platform
Question: Under the attribute name of "music_playlist", describe the attribute ID, business ID, city and inactive status.
Evidence: active status refers to active; active = 'true' means the business is still running; active = 'false' means the business is inactive or not running now
SQL: SELECT T1.attribute_id, T2.business_id, T3.city FROM Attributes AS T1 INNER JOIN Business_Attributes AS T2 ON T1.attribute_id = T2.attribute_id INNER JOIN Business AS T3 ON T2.business_id = T3.business_id WHERE T1.attribute_name = 'music_playlist' AND T3.active = 'false'

Database: public_review_platform
Question: What is the most common type of compliments that a user has received from other users?
Evidence: the most common type of compliments refers to MAX(COUNT(compliment_type))
SQL: SELECT T2.compliment_type FROM Users_Compliments AS T1 INNER JOIN Compliments AS T2 ON T1.compliment_id = T2.compliment_id GROUP BY T2.compliment_type ORDER BY COUNT(T2.compliment_type) DESC LIMIT 1

Database: law_episode
Question: What is the average star rating of the episodes Jim Bracchitta has worked on?
Evidence: average star rating = divide(sum(stars), count(episode_id)) where name = 'Jim Bracchitta'
SQL: SELECT CAST(SUM(T3.stars) AS REAL) / COUNT(T2.episode_id) FROM Person AS T1 INNER JOIN Credit AS T2 ON T1.person_id = T2.person_id INNER JOIN Vote AS T3 ON T2.episode_id = T3.episode_id WHERE T3.stars = 1 AND T1.name = 'Jim Bracchitta'

Database: books
Question: Among Daisey Lamball's orders, how many were shipped via International shipping?
Evidence: via international shipping refers to method_name = 'International'
SQL: SELECT COUNT(*) FROM customer AS T1 INNER JOIN cust_order AS T2 ON T1.customer_id = T2.customer_id INNER JOIN shipping_method AS T3 ON T3.method_id = T2.shipping_method_id WHERE T1.first_name = 'Daisey' AND T1.last_name = 'Lamball' AND T3.method_name = 'International'

Database: university
Question: Give the names of universities with number of students ranges from 400 to 1000.
Evidence: number of students ranges from 400 to 1000 refers to num_students BETWEEN 400 AND 1000; name of university refers to university_name
SQL: SELECT DISTINCT T2.university_name FROM university_year AS T1 INNER JOIN university AS T2 ON T1.university_id = T2.id WHERE T1.num_students BETWEEN 400 AND 1000

Database: college_completion
Question: List the race of institutions in Alabama with number of students greater than the 90% of average number of students of all institutions?
Evidence: Alabama refers to state = 'Alabama'; number of students greater than the 90% of average = MULTIPLY(AVG(student_count), 90%) < student_count;
SQL: SELECT DISTINCT T2.race FROM institution_details AS T1 INNER JOIN institution_grads AS T2 ON T2.unitid = T1.unitid WHERE T1.student_count > ( SELECT AVG(T1.student_count) * 0.9 FROM institution_details AS T1 INNER JOIN institution_grads AS T2 ON T2.unitid = T1.unitid WHERE T1.state = 'Alabama' ) AND T1.state = 'Alabama'

Database: language_corpus
Question: How many times does the word "riu" appears in the biwords pair?
Evidence: riu refers to word = 'riu'; SUM(w1st where wid is word = 'riu' AND w2nd where wid is word = 'riu')
SQL: SELECT COUNT(T1.wid) FROM words AS T1 INNER JOIN biwords AS T2 ON T1.wid = T2.w1st INNER JOIN words AS T3 ON T3.wid = T2.w2nd WHERE T1.word = 'riu'

Database: world_development_indicators
Question: What is the short name of the country in which the "Net bilateral aid flows from DAC donors, Sweden (current US$)" indicator hit the 570,000 value in 1970?
Evidence: Net bilateral aid flows from DAC donors, Sweden (current US$) is the name of indicator where IndicatorName = 'Net bilateral aid flows from DAC donors, Sweden (current US$)'; Year = 1970; Value > 570,000
SQL: SELECT T2.ShortName FROM Indicators AS T1 INNER JOIN Country AS T2 ON T1.CountryCode = T2.CountryCode WHERE T1.IndicatorName = 'Net bilateral aid flows FROM DAC donors, Sweden (current US$)' AND T1.Year = 1970 AND T1.Value = 570000

Database: video_games
Question: Please list all the games that have the same game genre as 3D Lemmings.
Evidence: game refers to game_name; 3D Lemmings refers to game_name = '3D Lemmings'
SQL: SELECT T1.game_name FROM game AS T1 WHERE T1.genre_id = ( SELECT T.genre_id FROM game AS T WHERE T.game_name = '3D Lemmings' )

Database: chicago_crime
Question: Who is the crime against criminal sexual abuse?
Evidence: "Criminal Sexual Abuse" is the title of crime
SQL: SELECT crime_against FROM FBI_Code WHERE title = 'Criminal Sexual Abuse'

Database: professional_basketball
Question: Which player had the most game presentatons in 2011 NBA season.
Evidence: player refers to playerID; the most game presentations refers to max(GP); in 2020 refers to year = 2020; NBA season refers to lgID = 'NBA'
SQL: SELECT playerID FROM players_teams WHERE year = 2011 ORDER BY GP DESC LIMIT 1

Database: books
Question: Who is the author who wrote the most books?
Evidence: author refers to author_name; who wrote the most book refers to Max(Count(author_id))
SQL: SELECT T1.author_name FROM author AS T1 INNER JOIN book_author AS T2 ON T1.author_id = T2.author_id GROUP BY T1.author_name ORDER BY COUNT(T2.author_id) DESC LIMIT 1

Database: restaurant
Question: List street names in San Francisco city.
SQL: SELECT street_name FROM location WHERE city = 'San Francisco'

Database: cars
Question: What are the names of the cars worth 20000?
Evidence: name of the car refers to car_name; worth 20000 refers to price = 20000
SQL: SELECT T1.car_name FROM data AS T1 INNER JOIN price AS T2 ON T1.ID = T2.ID WHERE T2.price = 20000

Database: movie_platform
Question: How many movie lists with over 100 movies had user 85981819 created when he or she was a paying subscriber?
Evidence: the user was a paying subscriber when he created the list refers to user_has_payment_method = 1;  movie lists with over 100 refers to list_movie_number >100;  user 85981819 refers to user_id = 85981819;
SQL: SELECT COUNT(*) 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 AND T1.list_movie_number > 100 AND T2.user_has_payment_method = 1

Database: retails
Question: Indicate the name of the product that is close to being sold out and that has the lowest cost price.
Evidence: name of the product refers to p_name; close to being sold out refers to ps_availqty < 10; the lowest cost price refers to min(ps_supplycost)
SQL: SELECT T1.p_name FROM part AS T1 INNER JOIN partsupp AS T2 ON T1.p_partkey = T2.ps_partkey WHERE T2.ps_availqty < 10 ORDER BY T2.ps_supplycost LIMIT 1

Database: movie_platform
Question: Give the url of movie which was rated 5 on 2013/5/3 5:11:17.
Evidence: rated 5 refers to rating_score = 5; on 2013/5/3 5:11:17 refers to rating_timestamp_utc = '2013-05-03 05:11:17'
SQL: SELECT T2.movie_url FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE rating_score = 5 AND rating_timestamp_utc LIKE '2013-05-03 05:11:17'

Database: retail_world
Question: Which of the American customers have experienced a delay in the shipment and how long was the longest?
Evidence: "American" refers to Country = 'USA'; longest delay in shipment refers to Max(Subtract(RequiredDate, ShippedDate)); customer refers to CustomerID
SQL: SELECT T1.CompanyName, TIMESTAMPDIFF(DAY, T2.ShippedDate, T2.RequiredDate) FROM Customers AS T1 INNER JOIN Orders AS T2 ON T1.CustomerID = T2.CustomerID WHERE T1.Country = 'USA' AND TIMESTAMPDIFF(DAY, T2.ShippedDate, T2.RequiredDate) < 0

Database: cars
Question: How much is the Peugeot 505s Turbo Diesel?
Evidence: cost refers to price; Peugeot 505s Turbo Diesel refers to car_name = 'peugeot 505s turbo diesel'
SQL: SELECT T2.price FROM data AS T1 INNER JOIN price AS T2 ON T1.ID = T2.ID WHERE T1.car_name = 'peugeot 505s turbo diesel'