Database: video_games
Question: What is the number of games sold in Europe for game platform ID 26?
Evidence: total number of games sold = MULTIPLY(num_sales, 100000); Europe refers to region_name = 'Europe';
SQL: SELECT T2.num_sales * 100000 AS nums_eur FROM region AS T1 INNER JOIN region_sales AS T2 ON T1.id = T2.region_id WHERE T2.game_platform_id = 26 AND T1.region_name = 'Europe'

Database: movie
Question: How many movies star a male African American actor?
Evidence: male refers to gender = 'Male'; African American refers to ethnicity = 'African American'
SQL: SELECT COUNT(*) FROM characters AS T1 INNER JOIN actor AS T2 ON T1.ActorID = T2.ActorID WHERE T2.Gender = 'Male' AND T2.Ethnicity = 'African American'

Database: authors
Question: What is the name of the authors of papers in which conferences have been published whose full name includes the word Workshop?
Evidence: full name includes the word Workshop refers to FullName LIKE '%Workshop%'
SQL: SELECT T2.Name FROM Paper AS T1 INNER JOIN PaperAuthor AS T2 ON T1.Id = T2.PaperId INNER JOIN Conference AS T3 ON T1.ConferenceId = T3.Id WHERE T3.FullName LIKE '%Workshop%'

Database: public_review_platform
Question: How many businesses in Tempe are rated as 'Wonderful experience?
Evidence: in Tempe refers to city = 'Tempe'; rated as 'Wonderful experience refers to stars > 3
SQL: SELECT COUNT(business_id) FROM Business WHERE city = 'Phoenix' AND stars > 3

Database: public_review_platform
Question: List the categories of active businesses in Glendale, AZ.
Evidence: active business ID refers to active = 'true'; categories refers to category_name; Glendale is a city; AZ is a state
SQL: SELECT DISTINCT T3.category_name FROM Business_Categories AS T1 INNER JOIN Business AS T2 ON T1.business_id = T2.business_id INNER JOIN Categories AS T3 ON T1.category_id = T3.category_id WHERE T2.active = 'true' AND T2.state = 'AZ' AND T2.city = 'Glendale'

Database: professional_basketball
Question: Which non-playoffs team had the most points in the regular season in the year 1998?
Evidence: non-playoff refers to PostGP = 0; in the year 1998 refers to year = 1998; the most points refers to max(o_pts)
SQL: SELECT T2.tmID FROM players_teams AS T1 INNER JOIN teams AS T2 ON T1.tmID = T2.tmID AND T1.year = T2.year WHERE T1.year = 1998 AND T1.PostGP = 0 ORDER BY T1.points DESC LIMIT 1

Database: language_corpus
Question: How many more times does the first word in the biwords pair "àbac-xinès" occur than the biwords pair itself?
Evidence: àbac refers to word = 'àbac'; xinès refers to word = 'xinès'; How many more times the first word in the biwords occur than the biwords pair itself means SUBTRACT(words.occurrence, biwords.occurrences)
SQL: SELECT occurrences - ( SELECT occurrences FROM biwords WHERE w1st = ( SELECT wid FROM words WHERE word = 'àbac' ) AND w2nd = ( SELECT wid FROM words WHERE word = 'xinès' ) ) AS CALUS FROM words WHERE word = 'àbac'

Database: public_review_platform
Question: How many actively running Yelp businesses are there located in "Phoenix" city?
Evidence: actively running business refers to active = 'true'; 'Phoenix' is the name of city
SQL: SELECT COUNT(business_id) FROM Business WHERE active = 'true' AND city = 'Phoenix'

Database: image_and_language
Question: Find the object in image 5 where the object with the coordinate of (634, 468).
Evidence: object in image 5 refers to OBJ_SAMPLE_ID where IMG_ID = 5; coordinates of (634, 468) refer to X and Y coordinates of the bounding box in which X = 634 and Y = 468;
SQL: SELECT OBJ_SAMPLE_ID FROM IMG_OBJ WHERE IMG_ID = 5 AND X = 634 AND Y = 468

Database: world_development_indicators
Question: Please list the short name of countries which have the latest trade data after 2010.
Evidence: the latest trade data after 2010 implies LatestTradeData > 2010;
SQL: SELECT ShortName FROM Country WHERE LatestTradeData > 2010

Database: authors
Question: How many authors is affiliated to the organization "Otterbein University"?
Evidence: Otterbein University is an Affiliation
SQL: SELECT COUNT(Name) FROM Author WHERE Affiliation = 'Otterbein University'

Database: authors
Question: Provide the name of the author who is affiliated with the organization named 'ABB Electrical Machines'.
Evidence: 'ABB Electrical Machines' is an affiliation
SQL: SELECT Name FROM Author WHERE Affiliation = 'ABB Electrical Machines'

Database: retail_complains
Question: How long was Kendall Allen's complaint about her credit card?
Evidence: how long refers to ser_time; credit card refers to Product = 'Credit Card';
SQL: SELECT T3.ser_time FROM events AS T1 INNER JOIN client AS T2 ON T1.Client_ID = T2.client_id INNER JOIN callcenterlogs AS T3 ON T1.`Complaint ID` = T3.`Complaint ID` WHERE T2.first = 'Kendall' AND T2.last = 'Allen' AND T2.sex = 'Female' AND T1.Product = 'Credit card'

Database: olympics
Question: How many gold medals were given to the winners in the Ice Hockey Men's Ice Hockey event?
Evidence: gold medals given to the winners refer to competitor_id where medal_name = 'Gold'; Ice Hockey Men's Ice Hockey refers to event_name = 'Ice Hockey Men''s Ice Hockey';
SQL: SELECT COUNT(T2.competitor_id) FROM event AS T1 INNER JOIN competitor_event AS T2 ON T1.id = T2.event_id WHERE T1.event_name LIKE 'Ice Hockey Men%s Ice Hockey' AND T2.medal_id = 1

Database: movies_4
Question: List 10 crews alongside their jobs who worked on the movie 'Mad Max: Fury Road.'
Evidence: crews refers to person_name; movie 'Mad Max: Fury Road' refers to title = 'Mad Max: Fury Road'
SQL: SELECT T3.person_name FROM movie AS T1 INNER JOIN movie_crew AS T2 ON T1.movie_id = T2.movie_id INNER JOIN person AS T3 ON T2.person_id = T3.person_id WHERE T1.title = 'Mad Max: Fury Road' LIMIT 10

Database: movie_3
Question: Which film is rented for the most times by the customers? Please give its title.
Evidence: film refers to title; film rented the most times refers to title where Max(Count(rental_id))
SQL: SELECT T.title FROM ( SELECT T1.title, COUNT(T3.rental_id) AS num FROM film AS T1 INNER JOIN inventory AS T2 ON T1.film_id = T2.film_id INNER JOIN rental AS T3 ON T2.inventory_id = T3.inventory_id GROUP BY T1.title ) AS T ORDER BY T.num DESC LIMIT 1

Database: law_episode
Question: Describe what happened in the episode of award no.296.
Evidence: description of what happened refers to summary; award no.296 refers to award_id = '296'
SQL: SELECT T1.summary FROM Episode AS T1 INNER JOIN Award AS T2 ON T1.episode_id = T2.episode_id WHERE T2.award_id = 296

Database: food_inspection
Question: List down the eateries' IDs with structural inspection type in February 2016.
Evidence: eateries' IDs refer to business_id; structural inspection type refers to inspections WHERE type = 'Structural Inspection'; in February 2016 refers to year(date) = 2016 and month(date) = 2;
SQL: SELECT business_id FROM inspections WHERE type = 'Structural Inspection' AND `date` LIKE '2016-02%'

Database: cs_semester
Question: Among the professors with more than average teaching ability, list the full name and email address of the professors who advise two or more students.
Evidence: more than average teaching ability refers to teachingability > AVG(teachingability); full_name of the professor = first_name, last_name; email address of the professor refers to email; advises two or more students refers to COUNT(student_id) > = 2;

SQL: SELECT T2.first_name, T2.last_name, T2.email FROM RA AS T1 INNER JOIN prof AS T2 ON T1.prof_id = T2.prof_id WHERE T2.teachingability > ( SELECT AVG(teachingability) FROM prof ) GROUP BY T2.prof_id HAVING COUNT(T1.student_id) >= 2