Database: movie
Question: Give the name of the No.1 character in the credit list from the highest rating thriller movie.
Evidence: No.1 character in the credit list refers to creditOrder = '1'; highest rating refers to max(rating); thriller movie refers to Genre = 'Thriller'
SQL: SELECT T2.`Character Name` FROM movie AS T1 INNER JOIN characters AS T2 ON T1.MovieID = T2.MovieID WHERE T2.creditOrder = '1' AND T1.Genre = 'Thriller' ORDER BY T1.Rating DESC LIMIT 1

Database: olympics
Question: Which region does the NOC code "COL" stand for?
Evidence: region refers to region_name; NOC code "COL" refers to noc = 'COL';
SQL: SELECT region_name FROM noc_region WHERE noc = 'COL'

Database: codebase_comments
Question: Please give the url of the repository whose files are contained in solution ID 9?
SQL: SELECT T1.Url FROM Repo AS T1 INNER JOIN Solution AS T2 ON T1.Id = T2.RepoId WHERE T2.Id = 9

Database: car_retails
Question: How many employees who are living in Australia and have the credit limit under 200000? State their email address and countries where they are working.
Evidence: Australia is a country; creditLimit < 20000;
SQL: SELECT T2.email, T3.country FROM customers AS T1 INNER JOIN employees AS T2 ON T1.salesRepEmployeeNumber = T2.employeeNumber INNER JOIN offices AS T3 ON T2.officeCode = T3.officeCode WHERE T3.country = 'Australia' AND T1.creditLimit < 200000 AND T2.jobTitle = 'Sales Rep'

Database: movie_3
Question: In store ID 2, how many of the films are R rating?

Evidence: R rating refers to rating = 'R'
SQL: SELECT COUNT(T1.film_id) FROM film AS T1 INNER JOIN inventory AS T2 ON T1.film_id = T2.film_id WHERE T2.store_id = 2 AND T1.rating = 'R'

Database: olympics
Question: Which city was the host of 1936 Winter Olympic Games?
Evidence: Which city refers to city_name; 1936 Winter Olympic refers to games_name = '1936 Winter';
SQL: SELECT T2.city_name FROM games_city AS T1 INNER JOIN city AS T2 ON T1.city_id = T2.id INNER JOIN games AS T3 ON T1.games_id = T3.id WHERE T3.games_name = '1936 Winter'

Database: retails
Question: What is the name of the customer whose order was delivered the longest?
Evidence: name of the customer refers to c_name; delivered the longest refers to max(subtract(l_receiptdate, l_commitdate))
SQL: SELECT T3.c_name FROM orders AS T1 INNER JOIN lineitem AS T2 ON T1.o_orderkey = T2.l_orderkey INNER JOIN customer AS T3 ON T1.o_custkey = T3.c_custkey ORDER BY (JULIANDAY(T2.l_receiptdate) - JULIANDAY(T2.l_commitdate)) DESC LIMIT 1

Database: world_development_indicators
Question: List out the country name of lower earning countries
Evidence: lower earning countries refer to IncomeGroup = 'Low income';
SQL: SELECT DISTINCT T2.CountryName FROM Country AS T1 INNER JOIN Indicators AS T2 ON T1.CountryCode = T2.CountryCode WHERE T1.IncomeGroup = 'Low income'

Database: food_inspection
Question: List the eateries' names and addresses which had reinspection on 2nd February, 2015.
Evidence: eateries which had reinspection on 2nd February, 2015 refer to business_id where date = '2015-02-02' and type = 'Reinspection/Followup';
SQL: SELECT T2.name, T2.address FROM inspections AS T1 INNER JOIN businesses AS T2 ON T1.business_id = T2.business_id WHERE T1.`date` = '2015-02-02' AND T1.type = 'Reinspection/Followup'

Database: codebase_comments
Question: How much is the processed time of the method whose tokenized name is "about box1 dispose"? Indicate the language of the method.
Evidence: language refers to Lang;
SQL: SELECT DISTINCT T1.ProcessedTime, T2.Lang FROM Solution AS T1 INNER JOIN Method AS T2 ON T1.Id = T2.SolutionId WHERE T2.NameTokenized = 'about box1 dispose'

Database: food_inspection
Question: Give the business ID and risk category of the business owned by San Francisco Madeleine, Inc.
Evidence: business owned by San Francisco Madeleine, Inc. refers to business_id where owner_name = 'San Francisco Madeleine, Inc.';
SQL: SELECT DISTINCT T2.business_id, T1.risk_category FROM violations AS T1 INNER JOIN businesses AS T2 ON T1.business_id = T2.business_id WHERE T2.owner_name = 'San Francisco Madeleine, Inc.'

Database: retails
Question: In the parts shipped by rail, how many are of medium priority?
Evidence: parts shipped by rail refer to l_partkey where l_shipmode = 'RAIL'; medium priority refers to o_orderpriority = '3-MEDIUM';
SQL: SELECT COUNT(T2.l_partkey) FROM orders AS T1 INNER JOIN lineitem AS T2 ON T1.o_orderkey = T2.l_orderkey WHERE T2.l_shipmode = 'RAIL' AND T1.o_orderpriority = '3-MEDIUM'

Database: food_inspection_2
Question: Calculate the average inspections per year done by Jessica Anthony from 2010 to 2017.
Evidence: from 2010 to 2017 refers to inspection_date > '2010-01-01' AND T2.inspection_id < '2017-12-31'; average inspections per year = divide(count(inspection_id where inspection_date > '2010-01-01' AND T2.inspection_id < '2017-12-31'), 8)
SQL: SELECT CAST(COUNT(CASE WHEN T1.first_name = 'Jessica' AND T1.last_name = 'Anthony' THEN T2.inspection_id ELSE 0 END) AS REAL) / 8 FROM employee AS T1 INNER JOIN inspection AS T2 ON T1.employee_id = T2.employee_id WHERE strftime('%Y', T2.inspection_date) BETWEEN '2010' AND '2017'

Database: address
Question: Which city has the most bad aliases?
Evidence: the most bad aliases refer to MAX(COUNT(bad_alias));
SQL: SELECT T2.city FROM avoid AS T1 INNER JOIN zip_data AS T2 ON T1.zip_code = T2.zip_code GROUP BY T1.bad_alias ORDER BY COUNT(T1.zip_code) DESC LIMIT 1

Database: disney
Question: How many horror movies are there?
Evidence: Horror refers to genre = 'Horror';
SQL: SELECT COUNT(movie_title) FROM `movies_total_gross` WHERE genre = 'Horror'

Database: language_corpus
Question: Among the wikipedia pages on Catalan with more than 300 different words, how many of them have a revision ID of over 28330000?
Evidence: lid = 1 means it's Catalan language; more than 300 different words refers to words > 300; revision ID of over 28330000 refers to revision > 28330000
SQL: SELECT COUNT(lid) FROM pages WHERE lid = 1 AND words > 300 AND revision > 28330000

Database: car_retails
Question: How many French customers shipped 2 orders which have been cancelled?
Evidence: French is a nationality of country = 'France'; cancelled orders refers to status = 'Cancelled';
SQL: SELECT COUNT(T2.country) FROM orders AS T1 INNER JOIN customers AS T2 ON T1.customerNumber = T2.customerNumber WHERE T1.status = 'Shipped' AND T2.country = 'France' GROUP BY T2.customerNumber HAVING COUNT(T1.status) = 2

Database: world
Question: What is the language of the smallest population country?
Evidence: smallest population refers to MIN(Population);
SQL: SELECT T2.Language FROM Country AS T1 INNER JOIN CountryLanguage AS T2 ON T1.Code = T2.CountryCode ORDER BY T1.Population ASC LIMIT 1

Database: video_games
Question: List the games available on Wii.
Evidence: games available refers to game_name; Wii refers to platform_name = 'Wii';
SQL: SELECT T4.game_name FROM platform AS T1 INNER JOIN game_platform AS T2 ON T1.id = T2.platform_id INNER JOIN game_publisher AS T3 ON T2.game_publisher_id = T3.id INNER JOIN game AS T4 ON T3.game_id = T4.id WHERE T1.platform_name = 'Wii'

Database: movie_3
Question: What is the inventory ID of Karen Jackson?
SQL: SELECT T2.inventory_id FROM customer AS T1 INNER JOIN rental AS T2 ON T1.customer_id = T2.customer_id WHERE T1.first_name = 'KAREN' AND T1.last_name = 'JACKSON'

Database: donor
Question: Did the project 'I Can't See It...Can You Help Me???' get the tip for the donation?
Evidence: I Can't See It...Can You Help Me???' is the title;
SQL: SELECT T2.donation_included_optional_support FROM essays AS T1 INNER JOIN donations AS T2 ON T1.projectid = T2.projectid WHERE T1.title LIKE 'I Can''t See It...Can You Help Me???'