Database: computer_student
Question: Which courses were taught by a professor who is not a faculty member?
Evidence: courses refers to taughtBy.course_id; professor refers to professor = 1; is not a faculty member refers to hasPosition = 0
SQL: SELECT DISTINCT T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1 AND T1.hasPosition = 0

Database: retail_world
Question: Among the products, how many of them were discontinued in production?
Evidence: discontinued refers to Discontinued = 1
SQL: SELECT COUNT(*) FROM Products WHERE Discontinued = 1

Database: book_publishing_company
Question: What is the highest level of job to get to for the employee who got hired the earliest?
Evidence: highest job level refers to MAX(job_lvl); hired the earliest refers to MIN(hire_date)
SQL: SELECT T2.max_lvl FROM employee AS T1 INNER JOIN jobs AS T2 ON T1.job_id = T2.job_id ORDER BY T1.hire_date LIMIT 1

Database: language_corpus
Question: How many times did the word number 8 appear?
Evidence: word number 8 refers to wid = 8; How many times refer to occurrences;
SQL: SELECT occurrences FROM words WHERE wid = 8

Database: bike_share_1
Question: What is the ratio for subscriber to customer given that the starting and the ending stations is 2nd at South Park?
Evidence: subscriber refers to subscription_type = 'Subscriber'; customer refers to subscription_type = 'customer';starting station refers to start_station_name; ending station refers to end_statio_name; start_station_name = '2nd at South Park' AND end_station_name = '2nd at South Park'
SQL: SELECT CAST(SUM(IIF(subscription_type = 'Subscriber', 1, 0)) AS REAL) / SUM(IIF(subscription_type = 'Customer', 1, 0)) FROM trip WHERE start_station_name = '2nd at South Park' AND end_station_name = '2nd at South Park'

Database: authors
Question: In the year 2012, which conference had the most papers presented? Give the short name of the conference.
Evidence: Papers refers to Paper.Id; short name of the conference refers to Conference.ShortName
SQL: SELECT T2.ShortName FROM Paper AS T1 INNER JOIN Conference AS T2 ON T1.ConferenceId = T2.Id WHERE T1.Year = '2012' GROUP BY T1.ConferenceId ORDER BY COUNT(T1.Id) DESC LIMIT 1

Database: car_retails
Question: Where can I find the office of the President of the company?
Evidence: Where can I find the office refers to address, comprising of addressLine1 and addressLine2; President is a jobTitle
SQL: SELECT t2.addressLine1, t2.addressLine2 FROM employees AS t1 INNER JOIN offices AS t2 ON t1.officeCode = t2.officeCode WHERE t1.jobTitle = 'President'

Database: regional_sales
Question: Which order number has the highest unit price?
Evidence: the highest unit price refers to MAX(Unit Price);
SQL: SELECT OrderNumber FROM `Sales Orders` WHERE REPLACE(`Unit Price`, ',', '') = ( SELECT REPLACE(`Unit Price`, ',', '') FROM `Sales Orders` ORDER BY REPLACE(`Unit Price`, ',', '') DESC LIMIT 1 )

Database: cookbook
Question: Provide the title and total time of the recipe which can be made with only lima beans.
Evidence: total time refers to total time refers to TOTAL(prep_min, cook_min, stnd_min); lima beans is a name of an ingredient
SQL: SELECT T1.title, T1.prep_min + T1.cook_min + T1.stnd_min FROM Recipe AS T1 INNER JOIN Quantity AS T2 ON T1.recipe_id = T2.recipe_id INNER JOIN Ingredient AS T3 ON T3.ingredient_id = T2.ingredient_id WHERE T3.name = 'lima beans'

Database: book_publishing_company
Question: Tell me about the information of the French publisher.
Evidence: French publisher means publisher in France where country = 'France'
SQL: SELECT T1.pr_info FROM pub_info AS T1 INNER JOIN publishers AS T2 ON T1.pub_id = T2.pub_id WHERE T2.country = 'France'

Database: professional_basketball
Question: Where was the high school of the player who had the most rebounds in the NBA allstar history?
Evidence: the most rebounds refers to max(rebounds)
SQL: SELECT T2.highSchool FROM player_allstar AS T1 INNER JOIN players AS T2 ON T1.playerID = T2.playerID ORDER BY T1.rebounds DESC LIMIT 1

Database: talkingdata
Question: Provide the number of events that happened on 2016/5/6.
Evidence: on 2016/5/6 refers to timestamp = '2016/5/6 XX:XX:XX';
SQL: SELECT COUNT(event_id) FROM events WHERE SUBSTR(`timestamp`, 1, 10) = '2016-05-06'

Database: computer_student
Question: What are the courses taught by the advisors who gave advice to student with ID 376?
Evidence: courses refers to course_id; advisors refers to p_id_dummy and taughtBy.p_id; student with ID 376 refers to advisedBy.p_id = 376
SQL: SELECT T3.course_id FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id INNER JOIN taughtBy AS T3 ON T2.p_id = T3.p_id WHERE T1.p_id = 141

Database: movie_platform
Question: What is the average rating score of the movie "When Will I Be Loved" and who was its director?
Evidence: average rating score = AVG(rating_score);
SQL: SELECT AVG(T1.rating_score), T2.director_name FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T2.movie_title = 'When Will I Be Loved'

Database: shipping
Question: Provide the destination city of the shipment shipped by January 16, 2017.
Evidence: January 16, 2017 refers to ship_date = '2017-01-16'; city refers to city_name
SQL: SELECT T2.city_name FROM shipment AS T1 INNER JOIN city AS T2 ON T1.city_id = T2.city_id WHERE T1.ship_date = '2017-01-16'

Database: public_review_platform
Question: Among the users whose fan is medium, how many users received high compliments from other users.
Evidence: is medium refers to user_fans = 'Medium'; high compliments refers to number_of_compliments = 'High'
SQL: SELECT COUNT(T1.user_id) FROM Users AS T1 INNER JOIN Users_Compliments AS T2 ON T1.user_id = T2.user_id WHERE T2.number_of_compliments = 'High' AND T1.user_fans = 'Medium'

Database: books
Question: On what date did the customers who live at number 460 of their respective streets place their orders?
Evidence: live at number 460 refers to street_number = '460'; date the customers placed their orders refers to order_date
SQL: SELECT T1.order_date FROM cust_order AS T1 INNER JOIN address AS T2 ON T1.dest_address_id = T2.address_id WHERE T2.street_number = 460

Database: retail_complains
Question: What is the division of the review of 5 stars received on December 17, 2017 for the product Eagle National Mortgage?
Evidence: 5 stars refers to Stars = 5; on December 17 2017 refers to Date = '2017-12-17'
SQL: SELECT T1.division FROM district AS T1 INNER JOIN reviews AS T2 ON T1.district_id = T2.district_id WHERE T2.Stars = 5 AND T2.Date = '2017-12-17' AND T2.Product = 'Eagle National Mortgage'

Database: law_episode
Question: How many keywords are there in the episode Disciple?
Evidence: episode Disciple refers to title = 'Disciple'
SQL: SELECT COUNT(T2.keyword) FROM Episode AS T1 INNER JOIN Keyword AS T2 ON T1.episode_id = T2.episode_id WHERE T1.title = 'Disciple'

Database: cookbook
Question: Name the recipe with the most Vitamin C.
Evidence: the most Vitamin C refers to MAX(vitamin_c)
SQL: SELECT T1.title FROM Recipe AS T1 INNER JOIN Nutrition AS T2 ON T1.recipe_id = T2.recipe_id ORDER BY T2.vitamin_c DESC LIMIT 1

Database: public_review_platform
Question: How many stars on average does user no.3 give to Yelp_Business in Arizona?
Evidence: user no.3 refers to user_id = 3; in Arizona refers to state = 'AZ'; stars on average = avg(review_stars(user_id = 3))
SQL: SELECT AVG(T2.review_stars) FROM Business AS T1 INNER JOIN Reviews AS T2 ON T1.business_id = T2.business_id WHERE T1.state LIKE 'AZ' AND T2.user_id = 3