Database: regional_sales
Question: Provide order number, warehouse code of customers Elorac, Corp.
Evidence: "Elorac, Corp" is the Customer Names
SQL: SELECT DISTINCT T1.OrderNumber, T1.WarehouseCode FROM `Sales Orders` AS T1 INNER JOIN Customers AS T2 ON T2.CustomerID = T1._CustomerID WHERE T2.`Customer Names` = 'Elorac, Corp'

Database: talkingdata
Question: Describe the number of app IDs and location of the event ID "79641".
Evidence: location = longitude, latitude;
SQL: SELECT COUNT(T1.app_id), T2.longitude, T2.latitude FROM app_events AS T1 INNER JOIN events AS T2 ON T1.event_id = T2.event_id WHERE T1.event_id = 79641 GROUP BY T2.longitude, T2.latitude

Database: address
Question: Among the zip code under Saint Croix county, which zip code has the biggest land area?
Evidence: biggest land area refers to Max(land_area); "SAINT CROIX" is the county
SQL: SELECT T1.zip_code FROM country AS T1 INNER JOIN zip_data AS T2 ON T1.zip_code = T2.zip_code WHERE T1.county = 'SAINT CROIX' ORDER BY T2.land_area DESC LIMIT 1

Database: movielens
Question: Please list all horror films that have a rating of 1.
SQL: SELECT T1.movieid FROM u2base AS T1 INNER JOIN movies2directors AS T2 ON T1.movieid = T2.movieid WHERE T1.rating = 1 AND T2.genre = 'Horror'

Database: bike_share_1
Question: Write down the times when there is no available bike to borrow in a station. List down the stations name and location coordinate.
Evidence: no available bike to borrow refers to bikes_available = 0; latitude and longitude coordinates can be used to indicate a location;
SQL: SELECT T2.time, T1.name, T1.lat, T1.long FROM station AS T1 INNER JOIN status AS T2 ON T2.station_id = T1.id WHERE T2.bikes_available = 0

Database: legislator
Question: Which party has the highest number of legislators who are Baptist?
Evidence: party that has the highest number of legislators refers to MAX(COUNT(party)); Baptist refers to religion_bio = 'Baptist';
SQL: SELECT T2.party FROM current AS T1 INNER JOIN `current-terms` AS T2 ON T1.bioguide_id = T2.bioguide WHERE T1.religion_bio = 'Baptist' GROUP BY T2.party ORDER BY COUNT(T2.party) DESC LIMIT 1

Database: sales
Question: How many customers have the first name Abigail?
SQL: SELECT COUNT(CustomerID) FROM Customers WHERE FirstName = 'Abigail'

Database: book_publishing_company
Question: How many sales did the store in Remulade make?
Evidence: Remulade is a city; sales in the store refers to ord_num
SQL: SELECT COUNT(T1.ord_num) FROM sales AS T1 INNER JOIN stores AS T2 ON T1.stor_id = T2.stor_id WHERE T2.city = 'Remulade'

Database: retail_complains
Question: For how long was the complaint filed by Matthew Pierce on 2016/10/28 delayed?
Evidence: on 2016/10/28 refers to "Date received" = '2016-10-28'; delayed = SUBTRACT("Date sent to company', 'Date received");
SQL: SELECT 365 * (strftime('%Y', T2.`Date sent to company`) - strftime('%Y', T2.`Date received`)) + 30 * (strftime('%M', T2.`Date sent to company`) - strftime('%M', T2.`Date received`)) + (strftime('%d', T2.`Date sent to company`) - strftime('%d', T2.`Date received`)) FROM client AS T1 INNER JOIN events AS T2 ON T1.client_id = T2.Client_ID WHERE T1.first = 'Matthew' AND T1.last = 'Pierce' AND T2.`Date received` = '2016-10-28'

Database: university
Question: Provide the number of international students and number of students in 2013 in university ID 20.
Evidence: number of international students refers to DIVIDE(MULTIPLY(pct_international_students, num_students), 100); in 2013 refers to year = 2013
SQL: SELECT pct_international_students * num_students, num_students FROM university_year WHERE year = 2013 AND university_id = 20

Database: european_football_1
Question: When did the first match that score more than 10 goals happen?
Evidence: score more than 10 goals refers to SUM(FTHG, FTAG)>10, which are short names for Final-time Home-team Goals and Final-time Away-team Goals; the first means the earliest and refers to MIN(Date);
SQL: SELECT MIN(Date) FROM matchs WHERE FTHG + FTAG > 10

Database: law_episode
Question: Park Dietz was credited in which role in the episode titled "Cherished"?
Evidence: credited refers to credited = 'true'; titled "Cherished" refers to title = 'Cherished'
SQL: SELECT T2.role FROM Episode AS T1 INNER JOIN Credit AS T2 ON T1.episode_id = T2.episode_id INNER JOIN Person AS T3 ON T3.person_id = T2.person_id WHERE T1.title = 'Cherished' AND T3.name = 'Park Dietz' AND T2.credited = 'true'

Database: cars
Question: How many American cars have an acceleration time of less than 12 seconds?
Evidence: American car refers to country = 'USA'; an acceleration time of less than 12 seconds refers to acceleration < 12
SQL: SELECT COUNT(*) FROM data AS T1 INNER JOIN production AS T2 ON T1.ID = T2.ID INNER JOIN country AS T3 ON T3.origin = T2.country WHERE T3.country = 'USA' AND T1.acceleration < 12

Database: university
Question: What are the names of the criteria under Center for World University Rankings?
Evidence: names of the criteria refers to criteria_name; under Center for World University Rankings refers to system_name = 'Center for World University Rankings';
SQL: SELECT T2.criteria_name FROM ranking_system AS T1 INNER JOIN ranking_criteria AS T2 ON T1.id = T2.ranking_system_id WHERE T1.system_name = 'Center for World University Rankings'

Database: soccer_2016
Question: List the id of the player who won the Orange Cap for 2 consecutive seasons.
Evidence: id of the player who won the Orange Cap refers to Orange_Cap; for 2 consecutive seasons refers to count(Season_Year) > 1
SQL: SELECT Orange_Cap FROM Season GROUP BY Orange_Cap HAVING COUNT(Season_Year) > 1

Database: student_loan
Question: Which organization did student285 enlist?
SQL: SELECT organ FROM enlist WHERE name = 'student285'

Database: public_review_platform
Question: How many users became an elite user the same year they joined Yelp?
Evidence: became an elite user the same year they joined Yelp refers to user_yelping_since_year = year_id
SQL: SELECT COUNT(T1.user_id) FROM Users AS T1 INNER JOIN Elite AS T2 ON T1.user_id = T2.user_id WHERE T1.user_yelping_since_year = T2.year_id

Database: donor
Question: What is the project title of the school located at latitude 42003718 and longitude -87668289?
Evidence: latitude 42003718 refers to school_latitude = 42003718; longitude -87668289 refers to school_longitude = -87668289
SQL: SELECT T1.title FROM essays AS T1 INNER JOIN projects AS T2 ON T1.projectid = T2.projectid WHERE T2.school_latitude = 42003718 AND T2.school_longitude = -87668289

Database: professional_basketball
Question: List the team name and the total wins of the team in year 2005 which has greater winning from the previous year.
Evidence: 2005 refers to year = 2005 ; previous year refers to year = 2004; team with greater winning than previous year refers to Won where year = 2005 > Won where year = 2004; team name refers to tmID
SQL: SELECT T1.name, T1.won FROM teams AS T1 INNER JOIN ( SELECT * FROM teams WHERE year = 2004 ) AS T2 on T1.tmID = T2.tmID WHERE T1.year = 2005 and T1.won > T2.won

Database: simpson_episodes
Question: How many crew have their own nickname? List their full name along with the nickname.
Evidence: crew refers to Person; full name refers to name; have nickname refers to nickname IS NOT NULL
SQL: SELECT COUNT(name) FROM Person WHERE nickname IS NOT NULL;

Database: legislator
Question: How many current legislators chose Republican as their political party?
Evidence: chose Republican as their political party refers to party = 'Republican'
SQL: SELECT COUNT(*) FROM `current-terms` WHERE party = 'Republican'

Database: soccer_2016
Question: How many first teams chose to bat after winning the toss?
Evidence: first teams refers to Team_1; chose to bat after winning the toss refers to Toss_Winner and Toss_Decide = 2
SQL: SELECT COUNT(Team_1) FROM `Match` WHERE Team_1 = Toss_Winner AND Toss_Decide = 2