Database: movie
Question: Which movie is the character Dr. Archibald 'Moonlight' Graham from?
Evidence: movie name refers to title; character Dr. Archibald 'Moonlight' Graham refers to character_name = 'Dr. Archibald 'Moonlight' Graham'
SQL: SELECT T1.Title FROM movie AS T1 INNER JOIN characters AS T2 ON T1.MovieID = T2.MovieID WHERE T2.`Character Name` = 'Dr. Archibald ''Moonlight'' Graham'

Database: donor
Question: For all donors from Texas City, list their donation message and name of the project they donated to.
Evidence: from Texas City refers to donor_city = 'Texas City'; name of the project refers title
SQL: SELECT T2.donation_message, T1.title FROM essays AS T1 INNER JOIN donations AS T2 ON T1.projectid = T2.projectid WHERE T2.donor_city = 'Texas City'

Database: law_episode
Question: List out director names that received an award along with the episode number.
Evidence: director refers to role = 'director'; received an award refers to result = 'Winner'; episode number refers to episode
SQL: SELECT T3.name, T1.episode_id FROM Episode AS T1 INNER JOIN Award AS T2 ON T1.episode_id = T2.episode_id INNER JOIN Person AS T3 ON T2.person_id = T3.person_id WHERE T2.role = 'director' AND T2.result = 'Winner'

Database: disney
Question: What is the difference in the current gross of Cars and its sequel, Cars 2? Which movie is more popular?
Evidence: SUBTRACT(inflation_adjusted_gross where movie_title = 'Cars', inflation_adjusted_gross where movie_title = 'Cars 2'); more popular movie refers to movie_title where MAX(inflation_adjusted_gross);
SQL: SELECT SUM(CASE WHEN movie_title = 'Cars' THEN CAST(REPLACE(trim(inflation_adjusted_gross, '$'), ',', '') AS REAL) ELSE 0 END), SUM(CASE WHEN movie_title = 'Cars 2' THEN CAST(REPLACE(trim(inflation_adjusted_gross, '$'), ',', '') AS REAL) ELSE 0 END) FROM movies_total_gross

Database: chicago_crime
Question: How many vandalisms were arrested in the ward represented by Edward Burke?
Evidence: vandalism refers to title = 'Vandalism'; arrested refers to arrest = 'TRUE'
SQL: SELECT SUM(CASE WHEN T1.alderman_last_name = 'Burke' THEN 1 ELSE 0 END) FROM Ward AS T1 INNER JOIN Crime AS T2 ON T1.ward_no = T2.ward_no INNER JOIN FBI_Code AS T3 ON T2.fbi_code_no = T3.fbi_code_no WHERE T3.title = 'Vandalism' AND T2.arrest = 'TRUE' AND T1.alderman_first_name = 'Edward'

Database: social_media
Question: How many tweets have a klout of over 50?
Evidence: klout of over 50 refers to Klout > 50
SQL: SELECT COUNT(DISTINCT TweetID) FROM twitter WHERE Klout > 50

Database: video_games
Question: Provide the platform where the Panzer Tactics can be played.
Evidence: platform refers to platform_name; the Panzer Tactics is a game name.
SQL: SELECT T4.platform_name FROM game AS T1 INNER JOIN game_publisher AS T2 ON T1.id = T2.game_id INNER JOIN game_platform AS T3 ON T2.id = T3.game_publisher_id INNER JOIN platform AS T4 ON T3.platform_id = T4.id WHERE T1.game_name = 'Panzer Tactics'

Database: retail_world
Question: For the orders of Customer "WHITC", what is the percentage of the orders were fulfilled with shipper company "United Package"?
Evidence: Customer "WHITC" refers to CustomerID = 'WHITC'; shipper company "United Package" refers to CompanyName = 'United Package'; percentage = divide(count(ShipperID where CompanyName = 'United Package') , count(ShipperID)) * 100%
SQL: SELECT CAST(COUNT(CASE WHEN T2.CompanyName = 'United Package' THEN 1 ELSE NULL END) AS REAL) * 100 / COUNT(T1.OrderID) FROM Orders AS T1 INNER JOIN Shippers AS T2 ON T1.ShipVia = T2.ShipperID WHERE T1.CustomerID = 'WHITC'

Database: movies_4
Question: Provide the names and departments of the person who worked as a music editor in the "Pirates of the Caribbean: At World's End" movie.
Evidence: names refers to person_name; departments refers to department_name; worked as a music editor refers to job = 'Music Editor'; "Pirates of the Caribbean: At World's End" refers to title = 'Pirates of the Caribbean: At World''s End'
SQL: SELECT T3.person_name, T4.department_name FROM movie AS T1 INNER JOIN movie_crew AS T2 ON T1.movie_id = T2.movie_id INNER JOIN person AS T3 ON T2.person_id = T3.person_id INNER JOIN department AS T4 ON T2.department_id = T4.department_id WHERE T1.title LIKE 'Pirates of the Caribbean: At World%s End' AND T2.job = 'Music Editor'

Database: movielens
Question: For the movies in English that are the oldest, how many of them have the lowest rating?
Evidence: Year contains relative value, higer year value refers to newer date; Year = 4 refers to newest date, Year = 1 refer to oldest date; Lowest rating = 1；isEnglish = 'T' means English movie
SQL: SELECT COUNT(DISTINCT T1.movieid) FROM movies AS T1 INNER JOIN u2base AS T2 ON T1.movieid = T2.movieid WHERE T1.year = 1 AND T2.rating = 1 AND T1.isEnglish = 'T'

Database: codebase_comments
Question: Please list the IDs of the solutions that contain files within the top 3 followed repositories.
Evidence: more forks refers to more people follow this repository;
SQL: SELECT T2.Id FROM Repo AS T1 INNER JOIN Solution AS T2 ON T1.Id = T2.RepoId ORDER BY T1.Forks DESC LIMIT 3

Database: superstore
Question: What are the names of the products that had been shipped in March 2013 at central superstore?
Evidence: names of the products refers to Product Name; shipped in March 2013 refers to "Ship Date" = '2013-03%'
SQL: SELECT DISTINCT T2.`Product Name` FROM central_superstore AS T1 INNER JOIN product AS T2 ON T1.`Product ID` = T2.`Product ID` WHERE strftime('%Y-%m', T1.`Ship Date`) = '2013-03'

Database: books
Question: How many books did David Foster Wallace write?
Evidence: "David Foster Wallace" is the author_name;
SQL: SELECT COUNT(T1.title) FROM book AS T1 INNER JOIN book_author AS T2 ON T1.book_id = T2.book_id INNER JOIN author AS T3 ON T3.author_id = T2.author_id WHERE T3.author_name = 'David Foster Wallace'

Database: movielens
Question: What is the percentage difference of English and non-English-language crime movies in other countries in year 3?
Evidence: non-English-language refers to isEnglish = 'F'; The percentage difference can be computed by [count(isEnglish = 'T' in movies) - count(isEnglish = 'F' in movies) / (all movies)] * 100%
SQL: SELECT CAST(SUM(IIF(T1.isEnglish = 'T', 1, 0)) - SUM(IIF(T1.isEnglish = 'F', 1, 0)) AS REAL) * 100 / COUNT(T1.movieid) FROM movies AS T1 INNER JOIN movies2directors AS T2 ON T1.movieid = T2.movieid WHERE T1.country = 'other' AND T1.year = 3

Database: retail_world
Question: Compute the total order quantity for Uncle Bob's Organic Dried Pears so far.
Evidence: "Uncle Bob's Organic Dried Pears" is the ProductName; total order quantity refers to Sum(Quantity)
SQL: SELECT SUM(T2.Quantity) FROM Products AS T1 INNER JOIN `Order Details` AS T2 ON T1.ProductID = T2.ProductID WHERE T1.ProductName LIKE 'Uncle Bob%s Organic Dried Pears'

Database: retail_world
Question: What are the products that are supplied by Aux joyeux ecclsiastiques?
Evidence: Aux joyeux ecclsiastiques is the name of supply company; products refer to ProductName;
SQL: SELECT T1.ProductName FROM Products AS T1 INNER JOIN Suppliers AS T2 ON T1.SupplierID = T2.SupplierID WHERE T2.CompanyName = 'Aux joyeux ecclsiastiques'

Database: video_games
Question: How many games were published by Activision?
Evidence: Activision refers to publisher_name = 'Activision';
SQL: SELECT COUNT(DISTINCT T3.id) FROM game_publisher AS T1 INNER JOIN publisher AS T2 ON T1.publisher_id = T2.id INNER JOIN game AS T3 ON T1.game_id = T3.id WHERE T2.publisher_name = 'Activision'