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

Database: authors
Question: How many papers whose authors include Thomas Wiegand were published in 1995?
Evidence: published in 1995 refers to Year = 1995; 'Thomas Wiegand' is the name of author
SQL: SELECT COUNT(T2.Title) FROM PaperAuthor AS T1 INNER JOIN Paper AS T2 ON T1.PaperId = T2.Id WHERE T1.Name = 'Thomas Wiegand' AND T2.Year = 1995

Database: movies_4
Question: Which movie has the keyword 'extremis?'
Evidence: Which movie refers to title; keyword 'extremis' refers to keyword_name = 'extremis'
SQL: SELECT T1.title FROM movie AS T1 INNER JOIN movie_keywords AS T2 ON T1.movie_id = T2.movie_id INNER JOIN keyword AS T3 ON T2.keyword_id = T3.keyword_id WHERE T3.keyword_name = 'extremis'

Database: food_inspection_2
Question: Provide the inspection ID of the inspection with the comment "MUST CLEAN AND BETTER ORGANIZE HALLWAY AREA" and sanitary operating requirement code of 7-38-030, 015, 010 (A), 005 (A).
Evidence: comment "MUST CLEAN AND BETTER ORGANIZE HALLWAY AREA" refers to inspector_comment = 'MUST CLEAN AND BETTER ORGANIZE HALLWAY AREA'; sanitary operating requirement code of 7-38-030, 015, 010 (A), 005 (A) refers to code = '7-38-030, 015, 010 (A), 005 (A)'
SQL: SELECT T2.inspection_id FROM inspection_point AS T1 INNER JOIN violation AS T2 ON T1.point_id = T2.point_id WHERE T2.inspector_comment = 'MUST CLEAN AND BETTER ORGANIZE HALLWAY AREA' AND T1.code = '7-38-030, 015, 010 (A), 005 (A)'

Database: movie_3
Question: Identify the number of movies that starred Nick Stallone.
SQL: SELECT COUNT(T1.film_id) FROM film_actor AS T1 INNER JOIN actor AS T2 ON T1.actor_id = T2.actor_id AND T2.first_name = 'NICK' AND T2.last_name = 'STALLONE'

Database: language_corpus
Question: Name the longest Catalan language Wikipedia page title and state the number of different words in this page.
Evidence: longest title refers to max(length(title))
SQL: SELECT title, words FROM pages WHERE title = ( SELECT MAX(LENGTH(title)) FROM pages )

Database: public_review_platform
Question: Please name one attribute that business number 2 does not have.
Evidence: business number refers to business_id; business_id = 2; does not have refers to attribute_value = 'none';
SQL: SELECT T1.attribute_name FROM Attributes AS T1 INNER JOIN Business_Attributes AS T2 ON T1.attribute_id = T2.attribute_id WHERE T2.attribute_value LIKE 'none' LIMIT 1

Database: donor
Question: State the number of public magnet schools in New York Manhattan.
Evidence: public magnet school refers to school_magnet = 't'; in New York Manhattan refers to school_country = 'New York(Manhattan)';
SQL: SELECT COUNT(schoolid) FROM projects WHERE school_county = 'New York (Manhattan)' AND school_magnet = 't'

Database: european_football_1
Question: Of the matches in all seasons of the Bundesliga division, how many of them ended with a tie?
Evidence: Bundesliga is the name of division; tie refers to FTR = 'D', where D stands for draft;
SQL: SELECT COUNT(T1.Div) FROM matchs AS T1 INNER JOIN divisions AS T2 ON T1.Div = T2.division WHERE T2.name = 'Bundesliga' AND T1.FTR = 'D'

Database: movie_3
Question: Who are the actors starred in the film "Bound Cheaper"?
Evidence: actor refers to first_name, last_name; film "Bound Cheaper" refers to title = 'BOUND CHEAPER'
SQL: SELECT T1.first_name, T1.last_name FROM actor AS T1 INNER JOIN film_actor AS T2 ON T1.actor_id = T2.actor_id INNER JOIN film AS T3 ON T2.film_id = T3.film_id WHERE T3.title = 'BOUND CHEAPER'

Database: movie_3
Question: List the titles of the films starred by Elvis Marx.
Evidence: 'Elvis Marx' is a full name of a film; full name refers to first_name, last_name
SQL: SELECT T3.title FROM actor AS T1 INNER JOIN film_actor AS T2 ON T1.actor_id = T2.actor_id INNER JOIN film AS T3 ON T2.film_id = T3.film_id WHERE T3.length BETWEEN 110 AND 150 AND T1.first_name = 'Russell' AND T1.last_name = 'Close'

Database: retails
Question: How many of the items are instructed to be delivered in person?
Evidence: instructed to be delivered in person refers to l_shipinstruct = 'DELIVER IN PERSON'
SQL: SELECT COUNT(l_linenumber) FROM lineitem WHERE l_shipinstruct = 'DELIVER IN PERSON'

Database: legislator
Question: What is the username of the current official Facebook presence of the oldest current legislator?
Evidence: username of the official Facebook refers to facebook; the oldest refers to MAX(birthday_bio)
SQL: SELECT T2.facebook FROM current AS T1 INNER JOIN `social-media` AS T2 ON T2.bioguide = T1.bioguide_id ORDER BY T1.birthday_bio LIMIT 1

Database: car_retails
Question: For the productline where the product No.S18_2949 was produced, what's the text description for that product line?
SQL: SELECT t1.textDescription FROM productlines AS t1 INNER JOIN products AS t2 ON t1.productLine = t2.productLine WHERE t2.productCode = 'S18_2949'

Database: app_store
Question: What is the total Sentiment polarity score of the most expensive app?
Evidence: total sentiment polarity score = sum(Sentiment_Polarity); most expensive app refers to MAX(Price);
SQL: SELECT SUM(T2.Sentiment_Polarity) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Price = ( SELECT MAX(Price) FROM playstore )

Database: cookbook
Question: How many dairy recipes can serve more than 10 people?
Evidence: dairy recipes refers to category = 'dairy'; serve more than 10 people refers to servings > 10
SQL: SELECT COUNT(*) FROM Recipe AS T1 INNER JOIN Quantity AS T2 ON T1.recipe_id = T2.recipe_id INNER JOIN Ingredient AS T3 ON T3.ingredient_id = T2.ingredient_id WHERE T3.category = 'dairy' AND T1.servings > 10

Database: world_development_indicators
Question: From 1960 to 1965, which country has the lowest value of indicator belongs to Health: Population: Structure?
Evidence: From 1960 to 1965 refers to Year between '1960' and '1965'; the lowest value implies MIN(Value); country refers to CountryName;
SQL: SELECT CountryName FROM Indicators WHERE Value = ( SELECT MIN(T1.Value) FROM Indicators AS T1 INNER JOIN Series AS T2 ON T1.IndicatorName = T2.IndicatorName WHERE T1.Year >= 1960 AND T1.Year < 1966 AND T2.Topic = 'Health: Population: Structure' )

Database: retails
Question: Among the parts supplied by Supplier#000000018, provide parts names which had supply costs above 900.
Evidence: Supplier#000000018 is the name of supplier which refers to s_name; supply costs above 900 refer to ps_supplycost > 900;
SQL: SELECT T2.p_name FROM partsupp AS T1 INNER JOIN part AS T2 ON T1.ps_partkey = T2.p_partkey INNER JOIN supplier AS T3 ON T1.ps_suppkey = T3.s_suppkey WHERE T1.ps_supplycost > 900 AND T3.s_name = 'Supplier#000000018'

Database: language_corpus
Question: List down the page id of titles start with alphabet "b".
Evidence: start with alphabet "b" refers to title LIKE 'b%'
SQL: SELECT pid FROM pages WHERE title LIKE 'b%'

Database: world_development_indicators
Question: How many countries have notes on the indicator Stocks traded, turnover ratio of domestic shares?
Evidence: indicator Stocks traded, turnover ratio of domestic shares refers to IndicatorName = 'Stocks traded, turnover ratio of domestic shares (%)'
SQL: SELECT COUNT(T1.Countrycode)  FROM CountryNotes AS T1 INNER JOIN Series AS T2 ON T1.Seriescode = T2.SeriesCode WHERE T2.IndicatorName = 'Stocks traded, turnover ratio of domestic shares (%)'