Database: shakespeare
Question: Give the abbreviation name for the character "Earl of Westmoreland".
Evidence: abbreviation name refers to Abbrev; character "Earl of Westmoreland" refers to CharName = 'Earl of Westmoreland'
SQL: SELECT DISTINCT Abbrev FROM characters WHERE CharName = 'Earl of Westmoreland'

Database: movie_platform
Question: What are the names of the movie that was rated by the user between 1/1/2013 to 12/31/2013 by the user who created the list "100 Greatest Living American Filmmakers"? Calculate for the average rating score of those movies in 2013.
Evidence: Between 1/1/2013 to 12/31/2013 refer to rating_timestamp_utc; 100 Greatest Living American Filmmakers refer to list_title; average rating score refer to DIVIDE( ADD(rating_score where rating_timestamp_utc = '1/1/2013-12/31/2013'), COUNT(rating_timestamp_utc = '1/1/2013-12/31/2013'))
SQL: SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id INNER JOIN lists AS T3 ON T3.user_id = T1.user_id WHERE T1.rating_timestamp_utc BETWEEN '2013-01-01' AND '2013-12-31' AND T3.list_title = '100 Greatest Living American Filmmakers'

Database: address
Question: List all the zip codes in the county of New Castle in Delaware.
Evidence: "NEW CASTLE" is the county; 'Delaware' is the name of state
SQL: SELECT DISTINCT T2.zip_code FROM state AS T1 INNER JOIN country AS T2 ON T1.abbreviation = T2.state WHERE T2.county = 'NEW CASTLE' AND T1.name = 'Delaware'

Database: movie_platform
Question: What is the name of the movie that was rated recently by user 57756708?
Evidence: user 57756708 refers to user_id = 57756708; rated recently refers to MAX(rating_timestamp_utc)
SQL: SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T1.user_id = 57756708 ORDER BY T1.rating_timestamp_utc DESC LIMIT 1

Database: university
Question: Give the name and score of the university ID 124.
Evidence: name of university refers to university_name;
SQL: SELECT T2.university_name, T1.score FROM university_ranking_year AS T1 INNER JOIN university AS T2 ON T1.university_id = T2.id WHERE T2.id = 124

Database: chicago_crime
Question: Among all the crimes that had happened in Central Chicago, how many of them were cases of domestic violence?
Evidence: Central Chicago refers to district_name = 'Central'; case of domestic violence refers to domestic = 'TRUE'
SQL: SELECT COUNT(*) FROM Crime AS T1 INNER JOIN District AS T2 ON T1.district_no = T2.district_no WHERE T2.district_name = 'Central' AND T1.domestic = 'TRUE'

Database: app_store
Question: Name the Apps with a sentiment objectivity of 0.3 and include their number of installs.
Evidence: FALSE;
SQL: SELECT DISTINCT T1.App, T1.Installs FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T2.Sentiment_Polarity = 0.3

Database: movie_platform
Question: What is the URL to the user profile image on Mubi of the user who gave the movie id of 1103 a 5 ratinng score on 4/19/2020?
Evidence: URL to the user profile image on Mubi  refers to user_avatar_image_url;  4/19/2020 refers to rating_date_utc
SQL: SELECT T2.user_avatar_image_url FROM ratings AS T1 INNER JOIN ratings_users AS T2 ON T1.user_id = T2.user_id WHERE T2.user_id = 1103 AND rating_score = 5 AND T2.rating_date_utc = '2020-04-19'

Database: retail_world
Question: What is the most widely used shipping company in the United States of America?
Evidence: most widely used refers to max(count(ShipVia)); shipping company refers to CompanyName; in the United States of America refers to ShipCountry = 'USA'
SQL: SELECT T2.CompanyName FROM Orders AS T1 INNER JOIN Shippers AS T2 ON T1.ShipVia = T2.ShipperID WHERE T1.ShipCountry = 'USA' GROUP BY T2.CompanyName ORDER BY COUNT(T2.CompanyName) DESC LIMIT 1

Database: world
Question: What are the official languages used in Greece?
Evidence: official language refers to IsOfficial = 'T'; Greece is a name of country;
SQL: SELECT T1.Language FROM CountryLanguage AS T1 INNER JOIN Country AS T2 ON T1.CountryCode = T2.Code WHERE T1.IsOfficial = 'T' AND T2.name = 'Greece'

Database: chicago_crime
Question: Please list the case numbers of all the incidents with the generic description of "BATTERY" in the IUCR classification.
Evidence: general description refers to primary_description; 'BATTERY' is the primary_description
SQL: SELECT T2.case_number FROM IUCR AS T1 INNER JOIN Crime AS T2 ON T1.iucr_no = T2.iucr_no WHERE T1.primary_description = 'BATTERY'

Database: world_development_indicators
Question: In the countries for which the latest trade data are from 2013, what was the GDP growth in 2014? List them in the ascending order of GDP.
Evidence: IndicatorName = 'GDP growth (annual %)'; Year = 2014;
SQL: SELECT DISTINCT T1.CountryCode, T2.Value FROM Country AS T1 INNER JOIN Indicators AS T2 ON T1.CountryCode = T2.CountryCode WHERE T1.LatestTradeData = 2013 AND T2.IndicatorName LIKE 'GDP growth (annual %)' AND T2.year = 2014 AND T2.Value > 0 ORDER BY T2.Value ASC

Database: college_completion
Question: In the state of Connecticut, what is the name of the instution with the highest percent rank for freshman retention percentage within the sector?
Evidence: name of the institution refers to chronname;  highest percent rank for freshman retention percentage within the sector refers to MAX(retain_percentile);
SQL: SELECT chronname FROM institution_details WHERE state = 'Connecticut' AND retain_percentile = ( SELECT MAX(retain_percentile) FROM institution_details WHERE state = 'Connecticut' )

Database: social_media
Question: State the number of tweets from Michigan on Thursdays.
Evidence: "Michigan" is the State; 'Thursday' is the Weekday; number of tweets refers to Count(TweetID)
SQL: SELECT COUNT(T1.TweetID) FROM twitter AS T1 INNER JOIN location AS T2 ON T2.LocationID = T1.LocationID WHERE T1.Weekday = 'Thursday' AND T2.State = 'Michigan'

Database: retail_world
Question: How many of the orders are shipped to France?
Evidence: shipped to France refers to ShipCountry = 'France';
SQL: SELECT COUNT(ShipCountry) FROM Orders WHERE ShipCountry = 'France'

Database: food_inspection_2
Question: Calculate the total amount of fine under the food equipment and utensil category.
Evidence: under the food equipment and utensil category refers to category = 'Food Equipment and Utensil'
SQL: SELECT SUM(T2.fine) FROM inspection_point AS T1 INNER JOIN violation AS T2 ON T1.point_id = T2.point_id WHERE T1.category = 'Food Equipment and Utensil'

Database: college_completion
Question: What is the average percentage of students graduating within 100 percent of normal/expected time for Central Alabama Community College?
Evidence: average = DIVIDE(SUM(grad_100_rate), (SUM(grad_100), SUM(grad_150))); percentage of students graduating within 100 percent of normal/expected time refers to grade_100_rate; Central Alabama Community College refers to chronname = 'Central Alabama Community College';
SQL: SELECT AVG(T2.grad_100_rate) FROM institution_details AS T1 INNER JOIN institution_grads AS T2 ON T2.unitid = T1.unitid WHERE T1.chronname = 'Central Alabama Community College'

Database: shakespeare
Question: In "A Lover's Complaint", what is the description of Act 1, Scene 1?
Evidence: "A Lover's Complaint" refers to Title = 'A Lover''s Complaint'
SQL: SELECT T2.Description FROM works AS T1 INNER JOIN chapters AS T2 ON T1.id = T2.work_id WHERE T2.Act = 1 AND T2.Scene = 1 AND T1.Title = 'A Lover''s Complaint'

Database: retail_world
Question: What is the quantity of Ikura ordered in order no. 10273?
Evidence: Ikura refers to ProductName = 'Ikura'; order no. refers to OrderID;
SQL: SELECT T2.Quantity FROM Products AS T1 INNER JOIN `Order Details` AS T2 ON T1.ProductID = T2.ProductID WHERE T2.OrderID = 10273 AND T1.ProductName = 'Ikura'