Database: language_corpus
Question: Please list the titles of the Wikipedia pages on the Catalan language with more than 4000 words.
Evidence: Catalan language refers to lid = 1; more than 4000 words refers to words > 4000;
SQL: SELECT title FROM pages WHERE lid = 1 AND words > 4000

Database: address
Question: Which state is area code 878 in? Give the name of the state.
SQL: SELECT T2.state FROM area_code AS T1 INNER JOIN zip_data AS T2 ON T1.zip_code = T2.zip_code WHERE T1.area_code = 878

Database: regional_sales
Question: Which product was ordered the most in 2018?
Evidence: product refers to Product Name; ordered the most in 2018 refers to MAX(COUNT(OrderNumber)) where SUBSTR(OrderDate, -2) = '18';
SQL: SELECT T2.`Product Name` FROM `Sales Orders` AS T1 INNER JOIN Products AS T2 ON T2.ProductID = T1._ProductID WHERE T1.OrderDate LIKE '%/%/18' GROUP BY T1._ProductID ORDER BY COUNT(T1._ProductID) DESC LIMIT 1

Database: cs_semester
Question: What is the full name of the professor who graduated from an Ivy League School?
Evidence: Ivy League school is assembled by 8 universities: Brown University, Columbia University, Cornell University, Dartmouth College, Harvard University, Princeton University, University of Pennsylvania and Yale University;
SQL: SELECT first_name, last_name FROM prof WHERE graduate_from IN ( 'Brown University',  'Columbia University',  'Cornell University',  'Dartmouth College',  'Harvard University',  'Princeton University',  'University of Pennsylvania',  'Yale University' )

Database: human_resources
Question: What is the education required to be account representative? Mention account representative full name and salary who got poor in performance status.
Evidence: account representative is a position title; full name = firstname, lastname; poor performance refers to performance = 'Poor'
SQL: SELECT T2.educationrequired, T1.firstname, T1.lastname, T1.salary FROM employee AS T1  INNER JOIN position AS T2  ON T1.positionID = T2.positionID WHERE T1.performance = 'Poor' AND T2.positiontitle = 'Account Representative'

Database: retail_world
Question: What are the order ids of the orders with freight of over 800?
Evidence: freight of over 800 refers to Freight > 800
SQL: SELECT OrderID FROM Orders WHERE Freight > 800

Database: university
Question: How many universities scored 0 in Awards between 2005 to 2015?
Evidence: between 2005 to 2015 refers to year BETWEEN 2005 AND 2015; scored 0 refers to score = 0; in Awards refers to criteria_name = 'Award'
SQL: SELECT COUNT(*) FROM ranking_criteria AS T1 INNER JOIN university_ranking_year AS T2 ON T1.id = T2.ranking_criteria_id WHERE T1.criteria_name = 'Award' AND T2.year BETWEEN 2005 AND 2015 AND T2.score = 0

Database: movie_platform
Question: What's the number of the paying subscribers when rating a movie after the year 2014?
Evidence: paying subscribers refers to user_has_payment_method = 1; rating a movie after the year 2014 refers to rating_date_utc>'2014%'
SQL: SELECT COUNT(user_subscriber) FROM ratings_users WHERE user_has_payment_method = 1 AND rating_date_utc > '2014%'

Database: beer_factory
Question: What are the full names of the customer who gave River City a 5-star?
Evidence: full name = First, Last; River City refers to BrandName = 'River City'; 5-star refers to StarRating = 5;
SQL: SELECT T1.First, T1.Last FROM customers AS T1 INNER JOIN rootbeerreview AS T2 ON T1.CustomerID = T2.CustomerID INNER JOIN rootbeerbrand AS T3 ON T2.BrandID = T3.BrandID WHERE T3.BrandName = 'River City' AND T2.StarRating = 5

Database: synthea
Question: What is the care plan, procedure, medication and the patient's full name for encounter 6f2e3935-b203-493e-a9c0-f23e847b9798?
Evidence: car plan refers to careplans.DESCRIPTION; procedure refers to procedures.DESCRIPTION; medication refers to medications.DESCRIPTION; full name = first, last; encounter refers to encounters.ID; encounters.ID = '6f2e3935-b203-493e-a9c0-f23e847b9798';
SQL: SELECT DISTINCT T3.DESCRIPTION, T4.DESCRIPTION, T5.DESCRIPTION, T1.first, T1.last FROM patients AS T1 INNER JOIN encounters AS T2 ON T1.patient = T2.PATIENT INNER JOIN careplans AS T3 ON T1.patient = T3.PATIENT INNER JOIN procedures AS T4 ON T1.patient = T4.PATIENT INNER JOIN medications AS T5 ON T1.patient = T5.PATIENT WHERE T2.ID = '6f2e3935-b203-493e-a9c0-f23e847b9798'

Database: codebase_comments
Question: What is the percentage of Forks to Stars of repository for solution "104086"?
Evidence: solution refers to Solution.Id; Solution.Id = 104086; percentage = MULTIPLY(DIVIDE(Forkk, Stars), 100);
SQL: SELECT CAST(T1.Forks AS REAL) * 100 / T1.Stars FROM Repo AS T1 INNER JOIN Solution AS T2 ON T1.Id = T2.RepoId WHERE T2.Id = 104086

Database: menu
Question: How many pages were there on the menu created on 17th November 1898?
Evidence: created on 17th November 1898 refers to date = '1898-11-17';
SQL: SELECT SUM(CASE WHEN T1.date = '1898-11-17' THEN 1 ELSE 0 END) FROM Menu AS T1 INNER JOIN MenuPage AS T2 ON T1.id = T2.menu_id

Database: computer_student
Question: List the professor ID who taught the course ID from 121 to 130 of basic undergraduate courses.
Evidence: professor ID refers to taughtBy.p_id; course ID from 121 to 130 of basic undergraduate courses refers to courseLevel = 'Level_300' and course.course_id between 121 and 130
SQL: SELECT T2.p_id FROM course AS T1 INNER JOIN taughtBy AS T2 ON T1.course_id = T2.course_id WHERE T1.courseLevel = 'Level_300' AND T1.course_id > 121 AND T1.course_id < 130

Database: retails
Question: Calculates the profit processed by Supplier No. 7414 on order No. 817154.
Evidence: SUBTRACT(MULTIPLY(l_extendedprice, (SUBTRACT(1, l_discount)), MULTIPLY(ps_supplycost, l_quantity))) WHERE l_suppkey = 7414 AND l_orderkey = 817154;
SQL: SELECT T1.l_extendedprice * (1 - T1.l_discount) - T2.ps_supplycost * T1.l_quantity FROM lineitem AS T1 INNER JOIN partsupp AS T2 ON T1.l_suppkey = T2.ps_suppkey WHERE T1.l_suppkey = 7414 AND T1.l_orderkey = 817154

Database: food_inspection_2
Question: List the full names of the employees who were responsible for inspecting Taqueria La Paz.
Evidence: full name refers to first_name, last_name; Taqueria La Paz refers to dba_name = 'TAQUERIA LA PAZ'
SQL: SELECT DISTINCT T3.first_name, T3.last_name FROM establishment AS T1 INNER JOIN inspection AS T2 ON T1.license_no = T2.license_no INNER JOIN employee AS T3 ON T2.employee_id = T3.employee_id WHERE T1.dba_name = 'TAQUERIA LA PAZ'

Database: movie_3
Question: Which film has the longest duration?
Evidence: film refers to the title; the longest duration refers to MAX(length)
SQL: SELECT title FROM film WHERE length = ( SELECT MAX(length) FROM film )

Database: talkingdata
Question: When did event number 7 happen for user number -8022267440849930000?
Evidence: event number refers to event_id; event_id = 7; user number refers to app_id; app_id = -8022267440849930000;
SQL: SELECT T1.timestamp FROM events_relevant AS T1 INNER JOIN app_events AS T2 ON T1.event_id = T2.event_id WHERE T2.app_id = -8022267440849930000 AND T1.event_id = 7

Database: simpson_episodes
Question: How many of the crew members who are taller than 1.70m were born in Canada?
Evidence: taller than 1.70m refers to height_meters > 1.70; born in Canada refers to birth_country = 'Canada'
SQL: SELECT COUNT(name) FROM Person WHERE height_meters > 1.70 AND birth_country = 'Canada';

Database: superstore
Question: Who was the customer in the South Region superstore who bought the most “Hon Multipurpose Stacking Arm Chairs"?
Evidence: customer refers to "Customer Name"; “Hon Multipurpose Stacking Arm Chairs" is the "Product Name";
SQL: SELECT T2.`Customer Name` FROM south_superstore AS T1 INNER JOIN people AS T2 ON T1.`Customer ID` = T2.`Customer ID` INNER JOIN product AS T3 ON T3.`Product ID` = T1.`Product ID` WHERE T3.`Product Name` = 'Hon Multipurpose Stacking Arm Chairs' GROUP BY T2.`Customer Name` ORDER BY COUNT(T2.`Customer Name`) DESC LIMIT 1