Database: university
Question: How many times more was the number of students of University of Ottawa than Joseph Fourier University in 2013?
Evidence: Joseph Fourier University refers to university_name = 'Joseph Fourier University'; University of Ottawa refers to university_name = 'University of Ottawa'; in 2013 refers to year = 2013; how many times more refers to DIVIDE(SUM(num_students where university_name = 'University of Ottawa'), SUM(num_students where university_name = 'Joseph Fourier University'))
SQL: SELECT CAST(SUM(CASE WHEN T2.university_name = 'University of Ottawa' THEN T1.num_students ELSE 0 END) AS REAL) / SUM(CASE WHEN T2.university_name = 'Joseph Fourier University' THEN T1.num_students ELSE 0 END) FROM university_year AS T1 INNER JOIN university AS T2 ON T1.university_id = T2.id WHERE T1.year = 2013

Database: movie_platform
Question: How many more movie lists were created by the user who created the movie list "250 Favourite Films"?
Evidence: 250 Favourite Films refers to list_title;
SQL: SELECT COUNT(list_id) FROM lists_users WHERE user_id = ( SELECT user_id FROM lists WHERE list_title = '250 Favourite Films' )

Database: public_review_platform
Question: Compare and get the difference of the number of businesses that are open in Monday and Tuesday from 10 am to 9 pm.
Evidence: 10 am refers to opening_time = '10AM'; 9 pm refers to closing_time = '9PM'; 'Monday' and 'Tuesday' are both day_of_week; difference number of business = Subtract(Count(business_id(day_of_week = 'Monday')), Count(business_id(day_of_week = 'Tuesday')))
SQL: SELECT SUM(CASE WHEN T3.day_of_week = 'Monday' THEN 1 ELSE 0 END) - SUM(CASE WHEN T3.day_of_week = 'Tuesday' THEN 1 ELSE 0 END) AS DIFF FROM Business AS T1 INNER JOIN Business_Hours AS T2 ON T1.business_id = T2.business_id INNER JOIN Days AS T3 ON T2.day_id = T3.day_id WHERE T2.opening_time = '10AM' AND T2.closing_time = '9PM'

Database: university
Question: Which ranking system is criteria "Total Shanghai" in?
Evidence: criteria "Total Shanghai" refers to criteria_name = 'Total Shanghai'; which ranking system refers to system_name
SQL: SELECT T1.system_name FROM ranking_system AS T1 INNER JOIN ranking_criteria AS T2 ON T1.id = T2.ranking_system_id WHERE T2.criteria_name = 'Total Shanghai'

Database: food_inspection_2
Question: What is the restaurant's name at "41.9532864854" latitude and "-87.7673790701422" longitude?
Evidence: restaurant refers to facility_type = 'Restaurant'; name refers to dba_name; "41.9532864854" latitude and "-87.7673790701422" longitude refers to latitude = 41.9532864854 and longitude = -87.7673790701422
SQL: SELECT dba_name FROM establishment WHERE latitude = 41.9532864854 AND longitude = -87.7673790701422 AND facility_type = 'Restaurant'

Database: movielens
Question: Please list the actor IDs whose movies have the newest published date.
Evidence: Year contains relative value, higher year value refers to newer date; Year = 4 refers to newest date
SQL: SELECT T1.actorid FROM movies2actors AS T1 INNER JOIN movies AS T2 ON T1.movieid = T2.movieid WHERE T2.year = 4

Database: books
Question: Which shipping method is preferred by customers the most?
Evidence: shipping method preferred the most by customers refers to method_id where Max(Count(method_id)); which shipping method refers to method_name
SQL: SELECT T2.method_name FROM cust_order AS T1 INNER JOIN shipping_method AS T2 ON T1.shipping_method_id = T2.method_id GROUP BY T2.method_name ORDER BY COUNT(T2.method_id) DESC LIMIT 1

Database: human_resources
Question: What is the required education for the position of regional manager?
Evidence: required education refers to educationrequired; position of regional manager refers to  positiontitle = 'Regional Manager'
SQL: SELECT educationrequired FROM position WHERE positiontitle = 'Regional Manager'

Database: food_inspection_2
Question: How many inspections done in 2010 had serious food safety issue?
Evidence: in 2010 refers to inspection_date like '2010%'; had serious food safety issue refers to risk_level = 3
SQL: SELECT COUNT(T2.inspection_id) FROM establishment AS T1 INNER JOIN inspection AS T2 ON T1.license_no = T2.license_no WHERE strftime('%Y', T2.inspection_date) = '2010' AND T1.risk_level = 3

Database: cs_semester
Question: Of courses with 3 credit, how many students have GPA of 3.2?
SQL: SELECT COUNT(T1.student_id) FROM student AS T1 INNER JOIN registration AS T2 ON T1.student_id = T2.student_id INNER JOIN course AS T3 ON T2.course_id = T3.course_id WHERE T3.credit = 3 AND T1.gpa = 3.2

Database: movie_3
Question: Please list the titles of all the films starring the actor PENELOPE GUINESS.
SQL: SELECT T2.title FROM film_actor AS T1 INNER JOIN film AS T2 ON T1.film_id = T2.film_id INNER JOIN actor AS T3 ON T1.actor_id = T3.actor_id WHERE T3.first_name = 'PENELOPE' AND T3.last_name = 'GUINESS'

Database: movie_3
Question: List all the description of the films starring Lucille Tracy?
SQL: SELECT T1.film_id FROM film_actor AS T1 INNER JOIN actor AS T2 ON T1.actor_id = T2.actor_id WHERE T2.first_name = 'LUCILLE' AND T2.last_name = 'TRACY'

Database: law_episode
Question: How many votes did the episode titled Juvenile get?
Evidence: the episode titled Juvenile refers to title = 'Juvenile'
SQL: SELECT SUM(T2.votes) FROM Episode AS T1 INNER JOIN Vote AS T2 ON T1.episode_id = T2.episode_id WHERE T1.title = 'Juvenile'

Database: regional_sales
Question: How many states located in the Midwest region?
SQL: SELECT COUNT(DISTINCT T) FROM ( SELECT CASE  WHEN Region = 'Midwest' THEN StateCode ELSE NULL END AS T FROM Regions ) WHERE T IS NOT NULL

Database: menu
Question: How much space does page 1 of the menu "Zentral Theater Terrace" cover?
Evidence: how much space = MULTIPLY(full_height, full_width); Zentral Theater Terrace is a name of menu;
SQL: SELECT T2.full_height * T2.full_width FROM Menu AS T1 INNER JOIN MenuPage AS T2 ON T1.id = T2.menu_id WHERE T1.name = 'Zentral Theater Terrace' AND T2.page_number = 1

Database: regional_sales
Question: Identify the top customer of the store located in Gilbert, Arizona based on net profit associated with the customer relationship in 2019.
Evidence: "Gilbert" is the City Name; 'Arizona' is the name of State; customer relationship in 2019 refers to ProcuredDate LIKE '%/19'; top net profit refers to Max(Subtract(Unit Price, Unit Cost))
SQL: SELECT T1.`Customer Names` FROM Customers AS T1 INNER JOIN `Sales Orders` AS T2 ON T2._CustomerID = T1.CustomerID INNER JOIN `Store Locations` AS T3 ON T3.StoreID = T2._StoreID WHERE T3.`City Name` = 'Gilbert' AND T2.ProcuredDate LIKE '%/%/19' ORDER BY REPLACE(T2.`Unit Price`, ',', '') - REPLACE(T2.`Unit Cost`, ',', '') DESC LIMIT 1

Database: image_and_language
Question: How many images have at least one object sample in the class of "man"?
Evidence: have at least one object sample in the class of "man" refers to count(IMG_ID where OBJ_CLASS = 'man') > = 1
SQL: SELECT COUNT(T.IMG_ID) FROM ( SELECT T2.IMG_ID FROM OBJ_CLASSES AS T1 INNER JOIN IMG_OBJ AS T2 ON T1.OBJ_CLASS_ID = T2.OBJ_CLASS_ID WHERE T1.OBJ_CLASS = 'man' GROUP BY T2.IMG_ID ) T

Database: genes
Question: List all genes whose interaction is with genes located in the nucleus in which it is positively correlated.
Evidence: If the Expression_Corr value is positive then it's positively correlated
SQL: SELECT T1.GeneID FROM Genes AS T1 INNER JOIN Interactions AS T2 ON T1.GeneID = T2.GeneID1 WHERE T2.Expression_Corr > 0 AND T1.Localization = 'nucleus'