Database: books
Question: Provide the authors and titles of the books which have more than 3000 pages.
Evidence: authors refers to author_name; more than 3000 pages refers to num_pages > 3000
SQL: SELECT T3.author_name, 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 T1.num_pages > 3000

Database: video_games
Question: Calculate the number of game publisher IDs for games released in 1984.
Evidence: released in 1984 refers to release_year = 1984;
SQL: SELECT COUNT(T.game_publisher_id) FROM game_platform AS T WHERE T.release_year = 1984

Database: college_completion
Question: How many students for both genders graduated from a 2-year institute in Alabama in 2011?
Evidence: 2-year institute refers to cohort = '2y all'; Alabama refers to state = 'Alabama'; in 2011 refers to year = 2011; T2.gender = 'B' means both genders;
SQL: SELECT SUM(T2.grad_cohort) FROM institution_details AS T1 INNER JOIN institution_grads AS T2 ON T2.unitid = T1.unitid WHERE  T2.cohort = '2y all' AND T2.year = 2011 AND T1.state = 'Alabama'

Database: sales
Question: Of the employees who sold Blade, who has the most amount of sales?
Evidence: Blade' is name of product; most amount of sales refers to MAX(MULTIPLY(Quantity, Price));
SQL: SELECT T1.FirstName, T1.MiddleInitial, T1.LastName FROM Employees AS T1 INNER JOIN Sales AS T2 ON T1.EmployeeID = T2.SalesPersonID INNER JOIN Products AS T3 ON T2.ProductID = T3.ProductID ORDER BY T2.Quantity * T3.Price DESC LIMIT 1

Database: language_corpus
Question: State one biword pair with occurence of 4.
Evidence: biword pair refers to w1st.word w2nd.word; occurrence of 4 refers to occurrences = 4
SQL: SELECT T1.word, T3.word 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 T2.occurrences = 4 LIMIT 1

Database: movies_4
Question: Which movies did the company Paramount Pictures produce in 2000?
Evidence: Which movies refers to title; company Paramount Pictures refers to company_name = 'Paramount Pictures'; in 2000 refers to release_date LIKE '2000%'
SQL: SELECT T3.title FROM production_company AS T1 INNER JOIN movie_company AS T2 ON T1.company_id = T2.company_id INNER JOIN movie AS T3 ON T2.movie_id = T3.movie_id WHERE T1.company_name = 'Paramount Pictures' AND CAST(STRFTIME('%Y', T3.release_date) AS INT) = 2000

Database: cs_semester
Question: Among professors with the highest popularity, how many of their students have research capability of 5?
Evidence: highest popularity refers to MAX(popularity); research capability refers to capability; capability = 5;
SQL: SELECT COUNT(T1.student_id) FROM RA AS T1 INNER JOIN prof AS T2 ON T1.prof_id = T2.prof_id WHERE T1.capability = 5 ORDER BY T2.popularity DESC LIMIT 1

Database: movielens
Question: How many unique directors with an average earnings of 2 and a quality of 3 have not made comedy films? List them.
SQL: SELECT DISTINCT T1.directorid FROM directors AS T1 INNER JOIN movies2directors AS T2 ON T1.directorid = T2.directorid WHERE T1.d_quality = 3 AND T1.avg_revenue = 2 AND T2.genre != 'Comedy'

Database: menu
Question: Under what events was the menu page's full width less than 2000 mm?
Evidence: full width less than 2000 mm refers to full_width < 2000;
SQL: SELECT T1.event FROM Menu AS T1 INNER JOIN MenuPage AS T2 ON T1.id = T2.menu_id WHERE T2.full_width = 2000

Database: language_corpus
Question: What is the title of the page that has the fewest words?
Evidence: has the fewest words refers to MIN(COUNT(words));
SQL: SELECT title FROM pages WHERE title = ( SELECT MIN(words) FROM pages )

Database: law_episode
Question: Please list all the keywords of the episode "Refuge: Part 1".
Evidence: episode "Refuge: Part 1" refers to title = 'Refuge: Part 1'
SQL: SELECT T2.keyword FROM Episode AS T1 INNER JOIN Keyword AS T2 ON T1.episode_id = T2.episode_id WHERE T1.title = 'Refuge: Part 1'

Database: university
Question: What is the id of the criteria "Citations Rank"?
Evidence: criteria "Citations Rank" refers to criteria_name = 'Citations Rank';
SQL: SELECT id FROM ranking_criteria WHERE criteria_name = 'Citations Rank'

Database: olympics
Question: How many athletes took part in the Olympic games held in Barcelona?
Evidence: Barcelona refers to city_name = 'Barcelona';
SQL: SELECT COUNT(T1.person_id) FROM games_competitor AS T1 INNER JOIN games_city AS T2 ON T1.games_id = T2.games_id INNER JOIN city AS T3 ON T2.city_id = T3.id WHERE T3.city_name = 'Barcelona'

Database: movielens
Question: List the movie that has been rated most by 25 years old users.
SQL: SELECT T2.movieid FROM users AS T1 INNER JOIN u2base AS T2 ON T1.userid = T2.userid WHERE T1.age = 25 GROUP BY T2.movieid ORDER BY COUNT(T1.userid) DESC LIMIT 1

Database: retail_complains
Question: How many times per year does a credit card customer complain about overlimit fees?
Evidence: credit card customer refers to product = 'Credit card'; about overlimit fees refers to issue = 'Overlimit fee'
SQL: SELECT strftime('%Y', `Date received`), COUNT(`Date received`) FROM events WHERE product = 'Credit card' AND issue = 'Overlimit fee' GROUP BY strftime('%Y', `Date received`) HAVING COUNT(`Date received`)

Database: codebase_comments
Question: What is the linearized sequenced of API calls of the method whose solution path is "mauriciodeamorim_tdd.encontro2\Tdd.Encontro2.sln"?
Evidence: linearized sequenced of API calls refers to ApiCalls;
SQL: SELECT T2.ApiCalls FROM Solution AS T1 INNER JOIN Method AS T2 ON T1.Id = T2.SolutionId WHERE T1.Path = 'mauriciodeamorim_tdd.encontro2Tdd.Encontro2.sln'

Database: codebase_comments
Question: What is the percentage of solutions for the method that needs to be compiled in the English methods?
Evidence: method that needs to be compiled refers to WasCompiled = 0; English method refers to Lang = 'en'; percentage of solutions = MULTIPLY(DIVIDE(SUM(WasCompiled = 0), COUNT(Solution.Id)), 100);
SQL: SELECT CAST(SUM(CASE WHEN T1.WasCompiled = 0 THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(Lang) FROM Solution AS T1 INNER JOIN Method AS T2 ON T1.Id = T2.SolutionId WHERE T2.Lang = 'en'

Database: codebase_comments
Question: List all the solutions ids of the repository with "636430969128176000" processed time
Evidence: solution ids refers to Solution.Id;
SQL: SELECT T2.Id FROM Repo AS T1 INNER JOIN Solution AS T2 ON T1.Id = T2.RepoId WHERE T1.ProcessedTime = 636430969128176000

Database: soccer_2016
Question: Give the name of venue for the game with a win margin of 138 points.
Evidence: name of venue refers to Venue_Name; a win margin of 138 points refers to Win_Margin = 138
SQL: SELECT T2.Venue_Name FROM `Match` AS T1 INNER JOIN Venue AS T2 ON T1.Venue_Id = T2.Venue_Id WHERE T1.Win_Margin = 138

Database: software_company
Question: Of the first 60,000 customers who sent a true response to the incentive mailing sent by the marketing department, how many of them are from a place with more than 30,000 inhabitants?
Evidence: RESPONSE = 'true'; place with more than 30,000 inhabitants refers to GEOID where INHABITANTS_K > 30;
SQL: SELECT COUNT(T1.ID) FROM Customers AS T1 INNER JOIN Mailings1_2 AS T2 ON T1.ID = T2.REFID INNER JOIN Demog AS T3 ON T1.GEOID = T3.GEOID WHERE T3.INHABITANTS_K > 30 AND T2.RESPONSE = 'true'

Database: video_games
Question: How many role-playing games are there?
Evidence: role-playing game refers to genre_name = 'Role-Playing'
SQL: SELECT COUNT(T1.id) FROM game AS T1 INNER JOIN genre AS T2 ON T1.genre_id = T2.id WHERE T2.genre_name = 'Role-Playing'