Database: chicago_crime
Question: What is the total number of crimes that happened in Bridgeport with beat less than 1000?
Evidence: Bridgeport refers to community_area_name = 'Bridgeport'; with beat less than 1000 refers to beat < 1000; total number = count(beat) where community_area_name = 'Bridgeport' and beat < 1000
SQL: SELECT SUM(CASE WHEN T2.beat < 1000 THEN 1 ELSE 0 END) FROM Community_Area AS T1 INNER JOIN Crime AS T2 ON T2.community_area_no = T1.community_area_no WHERE T1.community_area_name = 'Bridgeport'

Database: retail_world
Question: How many orders were shipped via Federal Shipping?
Evidence: 'Federal Shipping' is a CompanyName; orders refers to OrderID
SQL: SELECT COUNT(T1.OrderID) FROM Orders AS T1 INNER JOIN Shippers AS T2 ON T1.ShipVia = T2.ShipperID WHERE T2.CompanyName = 'Federal Shipping' AND T1.ShipVia = 3

Database: movie_3
Question: In films with rental rate of 4.99, list down the inventory ID of the films starred by Lucille Dee.
Evidence: 'Lucille Dee' is a full name of an actor; full name refers to first_name, last_name
SQL: SELECT T4.inventory_id 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 INNER JOIN inventory AS T4 ON T3.film_id = T4.film_id WHERE T1.first_name = 'Lucille' AND T1.last_name = 'Dee' AND T3.rental_rate = 4.99

Database: professional_basketball
Question: What is the full name of the team with the fastest growth in winning rate in the 'ABA' league from 1972 to 1973?
Evidence: "ABA" is the lgID; from 1972 to 1973 refers to year = 1972 and year = 1973; team with the fastest growth in winning rate = Max(Subtract(Divide(won where year = 1973, Sum(won, lost)),Divide(won where year = 1972, Sum(won, lost))))
SQL: SELECT T1.name FROM teams AS T1 INNER JOIN ( SELECT * FROM teams WHERE lgID = 'ABA' AND year = 1972 ) AS T2 ON T1.tmID = T2.tmID WHERE T1.lgID = 'ABA' AND T1.year = 1973 ORDER BY (CAST(T1.won AS REAL) / (T1.won + T1.lost) - (CAST(T2.won AS REAL) / (T2.won + T2.lost))) DESC LIMIT 1

Database: app_store
Question: What is the average sentiment polarity score of the Cooking Fever app? Indicate the age group that the app is targeted at.
Evidence: average sentiment polarity score = AVG(Sentiment_Polarity); age group the app is target at refers to Content Rating;
SQL: SELECT AVG(T2.Sentiment_Polarity), T1."Content Rating" FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Cooking Fever'

Database: food_inspection_2
Question: What is the precise location of the establishment with the highest number of failed inspections?
Evidence: precise location refers to latitude, longitude; the highest number of failed inspections refers to max(count(results where results = 'Fail'))
SQL: SELECT T1.latitude, T1.longitude FROM establishment AS T1 INNER JOIN ( SELECT license_no FROM inspection WHERE results = 'Fail' GROUP BY license_no ORDER BY COUNT(results) DESC LIMIT 1 ) AS T2 ON T1.license_no = T2.license_no

Database: food_inspection_2
Question: How many inspections failed in 2014?
Evidence: failed refers to results = 'Fail'; in 2014 refers to inspection_date like '2014%'
SQL: SELECT COUNT(inspection_id) FROM inspection WHERE strftime('%Y', inspection_date) = '2014' AND results = 'Fail'

Database: public_review_platform
Question: How many businesses of Yelp are in Scottsdale?
Evidence: Scottsdale refers to city = 'Scottsdale';
SQL: SELECT COUNT(business_id) FROM Business WHERE city LIKE 'Scottsdale'

Database: image_and_language
Question: How many object classes are there in the database?
Evidence: object classes refers to OBJ_CLASS
SQL: SELECT COUNT(OBJ_CLASS_ID) FROM OBJ_CLASSES

Database: shakespeare
Question: How many paragraphs are there in "Ay, surely, mere the truth: I know his lady."?
Evidence: "Ay, surely, mere the truth: I know his lady." refers to PlainText = 'Ay, surely, mere the truth: I know his lady.'
SQL: SELECT ParagraphNum FROM paragraphs WHERE PlainText = 'Ay, surely, mere the truth: I know his lady.'

Database: address
Question: Provide the zip codes and the congress representatives' names of the postal points which are affiliated with Readers Digest.
Evidence: representative's full names refer to first_name, last_name; postal points affiliated with Readers Digest refer to zip_code where organization = 'Readers Digest';
SQL: SELECT T1.zip_code, T3.first_name, T3.last_name FROM zip_data AS T1 INNER JOIN zip_congress AS T2 ON T1.zip_code = T2.zip_code INNER JOIN congress AS T3 ON T2.district = T3.cognress_rep_id WHERE T1.organization = 'Readers Digest'

Database: cs_semester
Question: Among the students with a capability below 3, what is the difference of undergraduate students from research postgraduate students?
Evidence: capability < 3; difference = subtract(count(type = 'UG')), (count(type = 'RPG')); undergraduate students refers to type = 'UG'; research postgraduate students refers to type = 'RPG';
SQL: SELECT SUM(CASE WHEN T2.type = 'UG' THEN 1 ELSE 0 END) - SUM(CASE WHEN T2.type = 'RPG' THEN 1 ELSE 0 END) FROM RA AS T1 INNER JOIN student AS T2 ON T1.student_id = T2.student_id WHERE T1.capability < 3

Database: retails
Question: How many customers are in the automobile market segment?
Evidence: automobile market segment refers to c_mktsegment = 'AUTOMOBILE';
SQL: SELECT COUNT(c_custkey) FROM customer WHERE c_mktsegment = 'AUTOMOBILE'

Database: cs_semester
Question: What is the average GPA of the students with the highest research capability and high salary? List the full names of the students.
Evidence: the highest research capability refers to capability = 5; high salary refers to salary = 'high'; prof_id refers to professor’s ID; GPA is an abbreviated name of Grade Point Average where average GPA refers to AVG(gpa);
SQL: SELECT AVG(T2.gpa), T2.f_name, T2.l_name FROM RA AS T1 INNER JOIN student AS T2 ON T1.student_id = T2.student_id WHERE T1.salary = 'high' AND T1.capability = 5 GROUP BY T2.student_id

Database: books
Question: What are the names of all the publishers who have published at least 30 books?
Evidence: published at least 30 books refers to Count(book_id) > = 30
SQL: SELECT T2.publisher_name FROM book AS T1 INNER JOIN publisher AS T2 ON T1.publisher_id = T2.publisher_id GROUP BY T2.publisher_name HAVING COUNT(T2.publisher_name) >= 30

Database: language_corpus
Question: Please list any three Wikipedia pages that are written in Catalan, together with their titles and revision page numbers.
Evidence: in Catalan means in Catalan-language and refers to lid = 1; revision page numbers refer to revision;
SQL: SELECT title, revision FROM pages WHERE lid = 1 LIMIT 3

Database: food_inspection_2
Question: How many restaurants with the highest risk level still passed the inspection?
Evidence: restaurant refers to facility_type = 'Restaurant'; the highest risk level refers to max(risk_level); pass the inspection refers to results = 'Pass'
SQL: SELECT COUNT(DISTINCT T1.license_no) FROM establishment AS T1 INNER JOIN inspection AS T2 ON T1.license_no = T2.license_no WHERE T1.risk_level = 3 AND T2.results = 'Pass' AND T1.facility_type = 'Restaurant'

Database: movie_3
Question: Of the movies in which Reese Kilmer acted, what percentage are action movies?
Evidence: 'Reese Kilmer' is a full name of an actor; 'action' is the name of the category; calculation = DIVIDE(COUNT('action'), COUNT(category_id)) * 100
SQL: SELECT CAST(SUM(IIF(T4.name = 'Action', 1, 0)) AS REAL) * 100 / COUNT(T1.actor_id) FROM actor AS T1 INNER JOIN film_actor AS T2 ON T1.actor_id = T2.actor_id INNER JOIN film_category AS T3 ON T2.film_id = T3.film_id INNER JOIN category AS T4 ON T3.category_id = T4.category_id WHERE T1.first_name = 'Reese' AND T1.last_name = 'Kilmer'