Database: soccer_2016
Question: In which country do most players have the 'slow left-arm chinaman' bowling style?
Evidence: 'slow left-arm chinaman' bowling style refers to Bowling_skill = 'Slow left-arm chinaman'; most players  refers to max(count(Country_Id))
SQL: SELECT T3.Country_Name FROM Bowling_Style AS T1 INNER JOIN Player AS T2 ON T1.Bowling_Id = T2.Bowling_skill INNER JOIN Country AS T3 ON T2.Country_Name = T3.Country_Id WHERE T1.Bowling_skill = 'Slow left-arm chinaman'

Database: public_review_platform
Question: How many Yelp_Businesses do not provide alcohol?
Evidence: do not provide alcohol refers to attribute_name = 'Alcohol'and attribute_value = 'none'

SQL: SELECT COUNT(T1.attribute_id) FROM Attributes AS T1 INNER JOIN Business_Attributes AS T2 ON T1.attribute_id = T2.attribute_id WHERE T1.attribute_name LIKE 'Alcohol' AND T2.attribute_value LIKE 'none'

Database: law_episode
Question: What role was Julia Roberts nominated for?
Evidence: nominated refers to result = 'Nominee'
SQL: SELECT T2.role FROM Person AS T1 INNER JOIN Award AS T2 ON T1.person_id = T2.person_id WHERE T2.Result = 'Nominee' AND T1.name = 'Julia Roberts'

Database: college_completion
Question: What is the number of female graduate for all students cohort from Oakwood University in 2013?
Evidence: female refers to gender = 'F'; graduates refers to grad_cohort; Oakwood University refers to chronname = 'Oakwood University'; in 2013 refers to year = 2013; all sutdents refer to rae = 'X';
SQL: SELECT COUNT(*) FROM institution_details AS T1 INNER JOIN institution_grads AS T2 ON T1.unitid = T2.unitid WHERE T2.year = 2013 AND T2.gender = 'F' AND T2.race = 'X' AND T1.chronname = 'Oakwood University'

Database: disney
Question: What is the average total gross for the movies featuring Sterling Holloway?
Evidence: DIVIDE(SUM(total_gross where voice-actor = 'Sterling Holloway'); COUNT(movie_title where voice-actor = 'Sterling Holloway'));
SQL: SELECT SUM(CAST(REPLACE(trim(T2.total_gross, '$'), ',', '') AS REAL)) / COUNT(T2.movie_title) FROM `voice-actors` AS T1 INNER JOIN movies_total_gross AS T2 ON T1.movie = T2.movie_title WHERE T1.`voice-actor` = 'Sterling Holloway'

Database: menu
Question: On 1887-07-21, what was the event that lead to the creation of menu id 21380?
Evidence: On 1887-07-21 refers to date = '1887-07-21';
SQL: SELECT event FROM Menu WHERE date = '1887-07-21' AND id = 21380

Database: simpson_episodes
Question: Among the crew members of the simpson 20s born in the New York city, how many of them were born after the year 1970?
Evidence: born in New York city refers to birth_region = 'New York'; born after year 1970 refers to ('%Y', birthdate) > 1970
SQL: SELECT COUNT(name) FROM Person WHERE birth_region = 'New York' AND SUBSTR(birthdate, 1, 4) > '1970';

Database: superstore
Question: Please list any three orders that caused a loss to the company.
Evidence: caused a loss to the company refers to Profit < 0
SQL: SELECT `Order ID` FROM central_superstore WHERE Profit < 0 LIMIT 3

Database: social_media
Question: Tweet with ID tw-682723090279841798 was posted from which country?
Evidence: "tw-682723090279841798" is the TweetID
SQL: SELECT T2.Country FROM twitter AS T1 INNER JOIN location AS T2 ON T1.LocationID = T2.LocationID WHERE T1.TweetID = 'tw-682723090279841798'

Database: authors
Question: What are the journal homepages and author ID of the papers published in 2000 to 2005 with a word "social" in its title?
Evidence: in 2000 to 2005 refers to Year BETWEEN 2000 AND 2005; a word "social" in its title refers to Title = '%SOCIAL%'
SQL: SELECT T3.HomePage, T2.AuthorId FROM Paper AS T1 INNER JOIN PaperAuthor AS T2 ON T1.Id = T2.PaperId INNER JOIN Journal AS T3 ON T1.JournalId = T3.Id WHERE T1.Year BETWEEN 2000 AND 2005 AND T1.Title LIKE '%SOCIAL%'

Database: public_review_platform
Question: How many reviews of businesses that are still open received an uber rating on the funny vote?
Evidence: businesses that still open refers to active = 'true'; business received an uber rating on the funny vote refers to review_votes_funny = 'Uber'
SQL: SELECT COUNT(T1.business_id) FROM Business AS T1 INNER JOIN Reviews AS T2 ON T1.business_id = T2.business_id WHERE T2.review_votes_funny = 'Uber' AND T1.active = 'true'

Database: bike_share_1
Question: How many trips with a bike borrowed from the stations in San Francisco were made by a subscriber?
Evidence: bike was borrowed from refers to start_station_id; San Francisco refers to city = 'San Francisco'; subscriber refers to subscription_type = 'Subscriber';
SQL: SELECT COUNT(T1.id) FROM trip AS T1 INNER JOIN station AS T2 ON T2.ID = T1.start_station_id WHERE T2.city = 'San Francisco' AND T1.subscription_type = 'Subscriber'

Database: olympics
Question: How many games has Prithipal Singh participated in?
Evidence: games refer to games_id;
SQL: SELECT COUNT(T2.games_id) FROM person AS T1 INNER JOIN games_competitor AS T2 ON T1.id = T2.person_id WHERE T1.full_name = 'Prithipal Singh'

Database: retail_complains
Question: How many male clients are from the state of Massachusetts?
Evidence: male refers to sex = 'Male';
SQL: SELECT COUNT(T3.sex) FROM state AS T1 INNER JOIN district AS T2 ON T1.StateCode = T2.state_abbrev INNER JOIN client AS T3 ON T2.district_id = T3.district_id WHERE T1.state = 'Massachusetts' AND T3.sex = 'Male'

Database: cs_semester
Question: What percentage of students are highly satisfied with the Intro to Database 2 course?
Evidence: percentage = MULTIPLY(DIVIDE(COUNT(MAX(sat)), (COUNT(student_id))), 1.0); highly satisfied refers to MAX(sat);
SQL: SELECT CAST(( SELECT COUNT(*) FROM course WHERE name = 'Intro to Database 2' AND course_id IN ( SELECT course_id FROM registration WHERE sat = ( SELECT MAX(sat) FROM registration ) ) ) AS REAL) * 100  / COUNT(T1.student_id) FROM registration AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T2.name = 'Intro to Database 2'

Database: retails
Question: Among the parts that are returned, how many of them are provided by a supplier in debt?
Evidence: returned refers to l_returnflag = 'R'; in debt refers to s_acctbal < 0
SQL: SELECT COUNT(T1.l_partkey) FROM lineitem AS T1 INNER JOIN supplier AS T2 ON T1.l_suppkey = T2.s_suppkey WHERE T1.l_returnflag = 'R' AND T2.s_acctbal < 0

Database: movie_3
Question: What films did Burt Dukakis got star in?
Evidence: film refers to title
SQL: SELECT T3.title FROM film_actor AS T1 INNER JOIN actor AS T2 ON T1.actor_id = T2.actor_id INNER JOIN film AS T3 ON T1.film_id = T3.film_id WHERE T2.first_name = 'BURT' AND T2.last_name = 'DUKAKIS'

Database: university
Question: What is the student staff ratio of the university with the highest student staff ratio of all time?
Evidence: highest student staff ratio refers to max(student_staff_ratio)
SQL: SELECT MAX(student_staff_ratio) FROM university_year WHERE student_staff_ratio = ( SELECT MAX(student_staff_ratio) FROM university_year )

Database: talkingdata
Question: Please list the app IDs of all the users in the Securities category.
SQL: SELECT T2.app_id FROM label_categories AS T1 INNER JOIN app_labels AS T2 ON T1.label_id = T2.label_id WHERE T1.category = 'Securities'

Database: retail_world
Question: How many orders was handled by employees who reported to employee id 5?
Evidence: reported to employee id 5 refers to ReportsTo = 5
SQL: SELECT COUNT(T2.OrderID) FROM Employees AS T1 INNER JOIN Orders AS T2 ON T1.EmployeeID = T2.EmployeeID WHERE T1.ReportsTo = 5

Database: menu
Question: List down the menu page IDs for menu sponsored by Occidental & Oriental?
Evidence: menu page IDs refers to MenuPage.id; sponsored by Occidental & Oriental refers to sponsor = 'Occidental & Oriental';
SQL: SELECT T2.id FROM MenuPage AS T1 INNER JOIN Menu AS T2 ON T2.id = T1.menu_id WHERE T2.sponsor = 'Occidental & Oriental'