Database: university
Question: What are the names of the top 5 universities with the highest number of international students?
Evidence: highest number of international students refers to MAX(DIVIDE(MULTIPLY(num_students, pct_international_students), 100)); 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 ORDER BY (CAST(T1.num_students * T1.pct_international_students AS REAL) / 100) DESC LIMIT 5

Database: menu
Question: What are the names of the dishes with a stable price that were created in April of 2011?
Evidence: dishes with a stable price refers to highest_price is null; created in April of 2011 refers to SUBSTR(created_at,1,4) = '2011' and SUBSTR(created_at, 7, 1) = '4';
SQL: SELECT T1.name FROM Dish AS T1 INNER JOIN MenuItem AS T2 ON T1.id = T2.dish_id WHERE SUBSTR(T2.created_at, 1, 4) = '2011' AND SUBSTR(T2.created_at, 7, 1) = '4' AND T1.highest_price IS NULL

Database: public_review_platform
Question: Under which categories is Yelp_Business no. 1?
Evidence: categories refers to category_name; Yelp_Business no.1 refers to business_id = 1
SQL: SELECT T1.category_name FROM Categories AS T1 INNER JOIN Business_Categories AS T2 ON T1.category_id = T2.category_id WHERE T2.business_id = 1

Database: computer_student
Question: What is the total of professional courses available at the university? List out all the course id.
Evidence: professional courses refers to courseLevel = 'Level_500'; course id refers to course.course_id
SQL: SELECT COUNT(course_id) FROM course WHERE courseLevel = 'Level_500'

Database: shakespeare
Question: List the number of acts in Two Gentlemen of Verona.
Evidence: Two Gentlemen of Verona refers to LongTitle = 'Two Gentlemen of Verona'
SQL: SELECT DISTINCT T1.Act FROM chapters AS T1 INNER JOIN works AS T2 ON T1.id = T1.work_id WHERE T2.LongTitle = 'Two Gentlemen of Verona'

Database: world_development_indicators
Question: List down the series codes in which the topic is about Environment: Emissions and the license type is restricted. Please include their alpha code.
SQL: SELECT SeriesCode FROM Series WHERE Topic = 'Environment: Emissions' AND LicenseType = 'Restricted'

Database: airline
Question: How many flights were there from San Diego International airport to Los Angeles International airport in the August of 2018?
Evidence: flights from refers to ORIGIN; San Diego International airport refers to Description = 'San Diego, CA: San Diego International'; flights to refers to DEST; Los Angeles International airport refers to Description = 'Los Angeles, CA: Los Angeles International'; in the August of 2018 refers to FL_DATE like '2018/8%';
SQL: SELECT COUNT(FL_DATE) FROM Airlines WHERE FL_DATE LIKE '2018/8%' AND ORIGIN = ( SELECT T2.ORIGIN FROM Airports AS T1 INNER JOIN Airlines AS T2 ON T1.Code = T2.ORIGIN WHERE T1.Description = 'San Diego, CA: San Diego International' ) AND DEST = ( SELECT T4.DEST FROM Airports AS T3 INNER JOIN Airlines AS T4 ON T3.Code = T4.DEST WHERE T3.Description = 'Los Angeles, CA: Los Angeles International' )

Database: retail_world
Question: Which company supplies Gula Malacca?
Evidence: Gula Malacca is the name of the product; company refers to CompanyName;
SQL: SELECT T2.CompanyName FROM Products AS T1 INNER JOIN Suppliers AS T2 ON T1.SupplierID = T2.SupplierID WHERE T1.ProductName = 'Gula Malacca'

Database: movie
Question: Find the actor's name that played as Don Altobello in a drama movie that has a gross of 136766062.
Evidence: actor's name refers to Name; as Don Altobello refers to Character Name = 'Don Altobello'; drama movie refers to Genre = 'Drama'
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 T1.Gross = 136766062 AND T2.`Character Name` = 'Don Altobello' AND T1.Genre = 'Drama'

Database: software_company
Question: What is the total number of customers with an age below 30?
Evidence: age below 30 refers to age < 30;
SQL: SELECT COUNT(ID) FROM Customers WHERE age < 30

Database: books
Question: What is the book with the most orders?
Evidence: books refers to title; the most orders refers to Max(Count(order_id))
SQL: SELECT T2.title FROM order_line AS T1 INNER JOIN book AS T2 ON T1.book_id = T2.book_id GROUP BY T2.title ORDER BY COUNT(T1.book_id) DESC LIMIT 1

Database: video_games
Question: What are the genres of games published by the publisher with an ID of 464?
Evidence: genres of games refers to genre_name; publisher with an ID of 464 refers to publisher_id = 464;
SQL: SELECT DISTINCT T2.genre_name FROM game AS T1 INNER JOIN genre AS T2 ON T1.genre_id = T2.id INNER JOIN game_publisher AS T3 ON T1.id = T3.game_id WHERE T3.publisher_id = 464

Database: regional_sales
Question: Identify the store location and sales team who processed the sales order 'SO - 0001004'.
Evidence: sales order 'SO - 0001004' refers to OrderNumber = 'SO - 0001004'; store location refers to City Name
SQL: SELECT T3.`Sales Team`, T1.`City Name` FROM `Store Locations` AS T1 INNER JOIN `Sales Orders` AS T2 ON T2._StoreID = T1.StoreID INNER JOIN `Sales Team` AS T3 ON T3.SalesTeamID = T2._SalesTeamID WHERE T2.OrderNumber = 'SO - 0001004'

Database: movies_4
Question: What is the percentage of male characters in the movie "Bride Wars"?
Evidence: male refers to gender = 'Male'; "Bride Wars" refers to title = 'Bride Wars'; percentage = divide(sum(gender = 'Male'), count(gender)) * 100 as percentage
SQL: SELECT CAST(COUNT(CASE WHEN T3.gender = 'Male' THEN 1 ELSE NULL END) AS REAL) * 100 / COUNT(T3.gender) FROM movie AS T1 INNER JOIN movie_cast AS T2 ON T1.movie_id = T2.movie_id INNER JOIN gender AS T3 ON T2.gender_id = T3.gender_id WHERE T1.title = 'Bride Wars'

Database: retail_world
Question: What is the name of the company that has the product with the highest unit price?
Evidence: name of the company refers to CompanyName; the highest unit price refers to MAX(UnitPrice)
SQL: SELECT T2.CompanyName FROM Products AS T1 INNER JOIN Suppliers AS T2 ON T1.SupplierID = T2.SupplierID WHERE T1.UnitPrice = ( SELECT MAX(UnitPrice) FROM Products )

Database: airline
Question: How many flights from American Airlines were cancelled due to a type A cancellation code?
Evidence: American Airlines refers to Description = 'American Airlines Inc.: AA'; cancelled refers to Cancelled = 1; cancelled due to type A cancellation code refers to CANCELLATION_CODE = 'A';
SQL: SELECT COUNT(*) FROM Airlines AS T1 INNER JOIN `Air Carriers` AS T2 ON T1.OP_CARRIER_AIRLINE_ID = T2.Code WHERE T1.CANCELLATION_CODE = 'A' AND T2.Description = 'American Airlines Inc.: AA' AND T1.CANCELLED = 1

Database: donor
Question: What is the total amount of donations in 2012.
Evidence: total amount of donations refers to sum(donation_total); 2012 refers to donation_timestamp LIKE'2012%'
SQL: SELECT SUM(donation_total) FROM donations WHERE donation_timestamp LIKE '2012%'

Database: soccer_2016
Question: For the game on 2008/5/12, who was the man of the match?
Evidence: on 2008/5/12 refers to Match_Date = '2008-05-12'; name refers to Player_Name;
SQL: SELECT T1.Player_Name FROM Player AS T1 INNER JOIN Match AS T2 ON T1.Player_Id = T2.Man_of_the_Match WHERE T2.Match_Date = '2008-05-12'

Database: video_games
Question: Give the genre of the following game titled 'Airlock' , 'Airline Tycoon' , and 'Airblade', respectively.
Evidence: genre refers to genre_name; 'Airlock', 'Airline Tycoon' , and 'Airblade' refers to game_name IN ('Airlock', 'Airline Tycoon', 'Airblade');
SQL: SELECT T2.genre_name FROM game AS T1 INNER JOIN genre AS T2 ON T1.genre_id = T2.id WHERE T1.game_name IN ('Airlock', 'Airline Tycoon', 'Airblade')