Database: retail_world
Question: Among the products that are no longer in continuous production, how many of them have their supplier in the USA?
Evidence: no longer continuous refers to Discontinued = 1; USA refers to Country = 'USA';
SQL: SELECT COUNT(T1.Discontinued) FROM Products AS T1 INNER JOIN Suppliers AS T2 ON T1.SupplierID = T2.SupplierID WHERE T2.Country = 'USA' AND T1.Discontinued = 1

Database: chicago_crime
Question: In which ward of more than 55,000 inhabitants are there more crimes of intimidation with extortion?
Evidence: more than 55000 inhabitants refers to Population > 55000; 'INTIMIDATION' is the primary_description; 'EXTORTION' refers to secondary_description; more crime refers to Count(ward_no)
SQL: SELECT T3.ward_no FROM IUCR AS T1 INNER JOIN Crime AS T2 ON T2.iucr_no = T1.iucr_no INNER JOIN Ward AS T3 ON T3.ward_no = T2.ward_no WHERE T1.primary_description = 'INTIMIDATION' AND T1.secondary_description = 'EXTORTION' AND T3.Population > 55000 GROUP BY T3.ward_no ORDER BY COUNT(T3.ward_no) DESC LIMIT 1

Database: language_corpus
Question: List all the Catalan language wikipedia page title with less than 10 number of different words in these pages.
Evidence: less than 10 number of different words refers to words < 10
SQL: SELECT title FROM pages WHERE words < 10

Database: olympics
Question: State the name of the city that held game id 3.
Evidence: name of city refers to city_name
SQL: SELECT T2.city_name FROM games_city AS T1 INNER JOIN city AS T2 ON T1.city_id = T2.id WHERE T1.games_id = 3

Database: public_review_platform
Question: Among the active businesses in Arizona, how many businesses work after 12PM?
Evidence: active businesses in Arizona refer to business_id where state = 'Arizona' and active = 'true'; work after 12PM refer to opening_time > '12PM';
SQL: SELECT COUNT(DISTINCT T2.business_id) FROM Business_Hours AS T1 INNER JOIN Business AS T2 ON T1.business_id = T2.business_id INNER JOIN Business_Categories AS T3 ON T2.business_id = T3.business_id INNER JOIN Categories AS T4 ON T3.category_id = T4.category_id WHERE T2.active = 'true' AND T2.state = 'AZ' AND T1.opening_time > '12PM'

Database: olympics
Question: How many athletes are from Australia?
Evidence: from Australia refer region_name = 'Australia';
SQL: SELECT COUNT(T2.person_id) FROM noc_region AS T1 INNER JOIN person_region AS T2 ON T1.id = T2.region_id WHERE T1.region_name = 'Australia'

Database: simpson_episodes
Question: How many episodes have the star score greater than 8?
Evidence: star score greater than 8 refers to stars > 8
SQL: SELECT COUNT(DISTINCT episode_id) FROM Vote WHERE stars > 8;

Database: donor
Question: Calculate the total amount of donations made in 2011 for an honoree with payment via campaign page.
Evidence: total amount refers to sum(donation_total); 2011 refers to donation_timestamp LIKE'2011%'; honoree refers to for_honoree = 't'; via campaign page refers to via_giving_page = 't'
SQL: SELECT SUM(donation_total) FROM donations WHERE donation_timestamp LIKE '2011%' AND via_giving_page = 't' AND for_honoree = 't'

Database: talkingdata
Question: What is the age of the oldest active user that participated in the event held on 5/6/2016 at coordinates 121, 31?
Evidence: oldest user refers to MAX(age); active user refers to is_active = 1; on 5/6/2016 refers to timestamp LIKE '2016-05-06%'; coordinates 121, 31 refers to longitude = 121 AND latitude = 31;
SQL: SELECT T3.age FROM app_events AS T1 INNER JOIN events_relevant AS T2 ON T1.event_id = T2.event_id INNER JOIN gender_age AS T3 ON T2.device_id = T3.device_id WHERE T1.is_active = 1 AND T2.longitude = 121 AND T2.latitude = 31 AND SUBSTR(T2.timestamp, 1, 10) = '2016-05-06' ORDER BY T3.age DESC LIMIT 1

Database: menu
Question: Which dish has the longest history?
Evidence: longest history refers to MAX(SUBTRACT(last_appeared, first_appeared));
SQL: SELECT name FROM Dish ORDER BY last_appeared - Dish.first_appeared DESC LIMIT 1

Database: retails
Question: Name the part which is most profitable.
Evidence: profit can be calculated as SUBTRACT(MULTIPLY(l_extendedprice, (SUBTRACT(1, l_discount)), MULTIPLY(ps_supplycost, l_quantity))); part which is most profitable refers to p_name where MAX(profit);
SQL: SELECT T.p_name FROM ( SELECT T3.p_name , T2.l_extendedprice * (1 - T2.l_discount) - T1.ps_supplycost * T2.l_quantity AS num FROM partsupp AS T1 INNER JOIN lineitem AS T2 ON T1.ps_suppkey = T2.l_suppkey INNER JOIN part AS T3 ON T1.ps_partkey = T3.p_partkey ) AS T ORDER BY T.num DESC LIMIT 1

Database: ice_hockey_draft
Question: Name the Chilliwack Chiefs players who have scored 100 points or more in the NHL.
Evidence: name of the player refers to PlayerName; Chilliwack Chiefs refers to TEAM = 'Chilliwack Chiefs'; scored 100 points or more in the NHL refers to P > 100;
SQL: SELECT T2.PlayerName FROM SeasonStatus AS T1 INNER JOIN PlayerInfo AS T2 ON T1.ELITEID = T2.ELITEID WHERE T1.TEAM = 'Chilliwack Chiefs' AND T1.P >= 100

Database: university
Question: What is the name of the university that had the highest number of international students for 6 consecutive years?
Evidence: had the highest number of international students refers to max(pct_international_students); for 6 consecutive years refers to count(SUBTRACT(year, rm)) > = 6; name of university refers to university_name;
SQL: SELECT T2.university_name FROM university_year AS T1 INNER JOIN university AS T2 ON T1.university_id = T2.id ORDER BY T1.pct_international_students DESC LIMIT 1

Database: music_platform_2
Question: The 'More Stupider: A 90-Day Fiance Podcast' belongs to which category and what is the average rating of the podcast?
Evidence: More Stupider: A 90-Day Fiance Podcast' is the title of podcast; average rating = Divide (Sum(rating), Count(rating))
SQL: SELECT AVG(T3.rating) FROM categories AS T1 INNER JOIN podcasts AS T2 ON T2.podcast_id = T1.podcast_id INNER JOIN reviews AS T3 ON T3.podcast_id = T2.podcast_id WHERE T2.title = 'More Stupider: A 90-Day Fiance Podcast'

Database: university
Question: How many universities are there in the United States of America?
Evidence: in the United States of America refers to country_name = 'United States of America';
SQL: SELECT COUNT(*) FROM university AS T1 INNER JOIN country AS T2 ON T1.country_id = T2.id WHERE T2.country_name = 'United States of America'

Database: music_platform_2
Question: List the authors who created review for podcast titled 'Pop Rocket' in 2016 with rating less than 5.
Evidence: Pop Rocket' is the title of podcast; in 2016 refers to created_at like'2016%'; rating less than 5 refers to rating < 5; author refers to author_id
SQL: SELECT T2.author_id FROM podcasts AS T1 INNER JOIN reviews AS T2 ON T2.podcast_id = T1.podcast_id WHERE T1.title = 'Pop Rocket' AND T2.created_at LIKE '2016-%' AND T2.rating < 5

Database: cs_semester
Question: Describe the full names and graduated universities of the professors who advised Olia Rabier.
Evidence: full names of the professors = first_name, last_name; graduated universities of the professors refers to graduate_from;
SQL: SELECT T1.first_name, T1.last_name, T1.graduate_from FROM prof AS T1 INNER JOIN RA AS T2 ON T1.prof_id = T2.prof_id INNER JOIN student AS T3 ON T2.student_id = T3.student_id WHERE T3.f_name = 'Olia' AND T3.l_name = 'Rabier'

Database: public_review_platform
Question: How many Yelp_Business falls under the category of "Shopping"?
Evidence: category of "Shopping" refers to category_name = 'Shopping'
SQL: SELECT COUNT(T1.category_id) FROM Categories AS T1 INNER JOIN Business_Categories AS T2 ON T1.category_id = T2.category_id WHERE T1.category_name LIKE 'Shopping'