Database: professional_basketball
Question: How many times between 1975 and 1980 did the player abdulka01 play for LAL?
Evidence: between 1975 and 1980 refers to year between 1975 and 1980; player abdulka01 refers to playerID = 'abdulka01'; play for LAL refers to tmID = 'LAL'
SQL: SELECT COUNT(DISTINCT T2.year) FROM players AS T1 INNER JOIN players_teams AS T2 ON T1.playerID = T2.playerID WHERE T2.tmID = 'LAL' AND T2.year BETWEEN 1975 AND 1980 AND T1.playerID = 'abdulka01'

Database: movie_platform
Question: How many movies directed by Felipe Cazals was realeased on 1976?
Evidence: directed by Felipe Cazals refers to director_name = 'Felipe Cazals' ; realeased on 1976 refers to movie_release_year = 1976
SQL: SELECT COUNT(movie_id) FROM movies WHERE movie_release_year = 1976 AND director_name LIKE 'Felipe Cazals'

Database: cs_semester
Question: List the student's first and last name that got a C in the course named "Applied Deep Learning".
Evidence: student's first name refers to f_name; student's last name refers to l_name; got a C refers to grade = 'C';
SQL: SELECT T1.f_name, T1.l_name 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.name = 'Applied Deep Learning ' AND T2.grade = 'C'

Database: professional_basketball
Question: How many turnovers per game did the assist champion had in the 2003 NBA season?
Evidence: turnovers per game = avg(turnovers); 2003 refers to year = 2003; NBA refers to lgID = 'NBA'
SQL: SELECT AVG(T2.turnovers) FROM players AS T1 INNER JOIN players_teams AS T2 ON T1.playerID = T2.playerID WHERE T2.year = 2003 GROUP BY T1.playerID, T2.assists ORDER BY T2.assists DESC LIMIT 1

Database: movies_4
Question: How many films released between 1/2/1990 and 12/30/2000 starred Uma Thurman?
Evidence: released between 1/2/1990 and 12/30/2000 refers to release_date BETWEEN '1990-01-02' AND '2000-12-30'; film has the same meaning as movie; starred Uma Thurman refers to person_name = 'Uma Thurman'
SQL: SELECT COUNT(T1.movie_id) FROM movie AS T1 INNER JOIN movie_cast AS T2 ON T1.movie_id = T2.movie_id INNER JOIN person AS T3 ON T2.person_id = T3.person_id WHERE T3.person_name = 'Uma Thurman' AND T1.release_date BETWEEN '1990-01-01' AND '2000-12-31'

Database: language_corpus
Question: What is the total pages of Wikipedia in Catalan language?
Evidence: total pages refers to sum(pages); Catalan language refers to lang = 'ca'
SQL: SELECT pages FROM langs WHERE lang = 'ca'

Database: address
Question: Count the number of postal points in the district represented by Kirkpatrick Ann.
Evidence: postal points refer to zip_code;
SQL: SELECT COUNT(T2.zip_code) FROM congress AS T1 INNER JOIN zip_congress AS T2 ON T1.cognress_rep_id = T2.district WHERE T1.first_name = 'Kirkpatrick' AND T1.last_name = 'Ann'

Database: movie_3
Question: What is the full name of the actor who starred in most movies?
Evidence: full name refers to first_name, last_name; actor who starred in the most movies refers to actor_id where Max(Count(film_id))
SQL: SELECT T.first_name, T.last_name FROM ( SELECT T2.first_name, T2.last_name, COUNT(T1.film_id) AS num FROM film_actor AS T1 INNER JOIN actor AS T2 ON T1.actor_id = T2.actor_id GROUP BY T2.first_name, T2.last_name ) AS T ORDER BY T.num DESC LIMIT 1

Database: student_loan
Question: How many unemployed students filed for bankruptcy?
Evidence: unemployed students who filed for bankruptcy refers to unemployed.name who are IN filed_for_bankrupcy.name;
SQL: SELECT COUNT(T1.name) FROM unemployed AS T1 INNER JOIN filed_for_bankrupcy AS T2 ON T2.name = T1.name

Database: world_development_indicators
Question: Name 5 country codes of country with highest value and state the region of these countries.
Evidence: with highest value refers to MAX(Value);
SQL: SELECT DISTINCT T1.CountryCode, T1.Region FROM Country AS T1 INNER JOIN Indicators AS T2 ON T1.CountryCode = T2.CountryCode ORDER BY T2.Value DESC LIMIT 5

Database: talkingdata
Question: How many people over the age of 50 do not have HTC One M8 Eye phones?
Evidence: over the age of 50 refers to age > 50; do not have HTC One M8 Eye phones refers to phone_brand ! = 'HTC' AND device_model ! = 'One M8 Eye';
SQL: SELECT COUNT(T1.device_id) FROM gender_age AS T1 INNER JOIN phone_brand_device_model2 AS T2 ON T1.device_id = T2.device_id WHERE T1.age > 50 AND T2.device_model != 'One M8 Eye' AND T2.phone_brand != 'HTC'

Database: simpson_episodes
Question: In episode with the highest votes, list the category of awards it is nominated for.
Evidence: highest votes refers to max(votes); nominated refers to result = 'Nominee'
SQL: SELECT T1.award_category FROM Award AS T1 INNER JOIN Episode AS T2 ON T1.episode_id = T2.episode_id WHERE T1.result = 'Nominee' ORDER BY T2.votes DESC LIMIT 1;

Database: cs_semester
Question: Among the students with less than four intelligence, list the full name and phone number of students with a greater than 3 GPA.
Evidence: intelligence < 4; full name = f_name, l_name; gpa > 3;
SQL: SELECT f_name, l_name, phone_number FROM student WHERE gpa > 3 AND intelligence < 4

Database: movie_3
Question: Which category does the film Working Microcosmos belong to?
Evidence: "WORKING MICROCOSMOS" is the title of film; category refers to name
SQL: SELECT T3.name FROM film AS T1 INNER JOIN film_category AS T2 ON T1.film_id = T2.film_id INNER JOIN category AS T3 ON T2.category_id = T3.category_id WHERE T1.title = 'WORKING MICROCOSMOS'

Database: genes
Question: How many different genes do we have if we add those located in the plasma and in the nucleus?
SQL: SELECT COUNT(GeneID) FROM Classification WHERE Localization IN ('plasma', 'nucleus')

Database: airline
Question: List the air carrier description and code of the flight with the shortest arrival time.
Evidence: shortest arrival time refers to MIN(ARR_TIME);
SQL: SELECT T1.Description, T1.Code FROM `Air Carriers` AS T1 INNER JOIN Airlines AS T2 ON T1.Code = T2.OP_CARRIER_AIRLINE_ID ORDER BY T2.ARR_TIME ASC LIMIT 1

Database: restaurant
Question: List all of the restaurants on Park St.
Evidence: restaurant refers to label; Park St refers to street_name = 'park st'
SQL: SELECT T2.label FROM location AS T1 INNER JOIN generalinfo AS T2 ON T1.id_restaurant = T2.id_restaurant WHERE T1.street_name = 'park st'

Database: language_corpus
Question: Show all the title of pages and number of occurences for each page where the word 'quipu' appears.
Evidence: word 'quipu' appears refers to word = 'quipu'
SQL: SELECT T1.title, T2.occurrences FROM pages AS T1 INNER JOIN pages_words AS T2 ON T1.pid = T2.pid INNER JOIN words AS T3 ON T2.wid = T3.wid WHERE T3.word = 'quipu'

Database: world
Question: How many percent of countries in North America use English?
Evidence: percentage = MULTIPLY(DIVIDE(COUNT(Language = 'English' WHERE Continent = 'North America'), COUNT(Language WHERE Continent = 'North America')), 1.0); North America refers to Continent = 'North America'; use English refers to Language = 'English';
SQL: SELECT CAST(SUM(IIF(T2.Language = 'English', 1, 0)) AS REAL) * 100 / COUNT(T1.Code) FROM Country AS T1 INNER JOIN CountryLanguage AS T2 ON T1.Code = T2.CountryCode

Database: donor
Question: List the title of all projects located in Chicago along with the ID of the donor.
Evidence: in Chicago refers to school_city = 'Chicago'; ID of the donor refers to donor_acctid
SQL: SELECT T1.title, T3.donor_acctid FROM essays AS T1 INNER JOIN projects AS T2 ON T1.projectid = T2.projectid INNER JOIN donations AS T3 ON T2.projectid = T3.projectid WHERE T2.school_city LIKE 'Chicago'

Database: retail_complains
Question: Lists the last name of all clients who made a PS-type complaint and were served by TOVA.
Evidence: PS-type complaint refers to type = 'PS'; served by refers to server;


SQL: SELECT t1.last FROM client AS T1 INNER JOIN callcenterlogs AS T2 ON T1.client_id = T2.`rand client` WHERE T2.type = 'PS' AND T2.server = 'TOVA'