Database: movie_platform
Question: How many ratings on the movie "A Way of Life" are made after the year 2011?
Evidence: A Way of Life' is movie_title; rating after the year 2011 refers to rating_timestamp_utc > '2011';
SQL: SELECT COUNT(T1.rating_id) FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T2.movie_title = 'A Way of Life' AND T1.rating_timestamp_utc >= '2012-01-01'

Database: world_development_indicators
Question: How many countries using the 1993 System of National Accounts methodology?
Evidence: use the 1993 System of National Accounts methodology refers to SystemOfNationalAccounts = '1993 System of National Accounts methodology.'
SQL: SELECT COUNT(CountryCode) FROM Country WHERE SystemOfNationalAccounts = 'Country uses the 1993 System of National Accounts methodology.'

Database: shakespeare
Question: Please give the title of the work of Shakespeare that has the most characters.
Evidence: most characters refers to max(count(character_id))
SQL: SELECT T.Title FROM ( SELECT T1.Title, COUNT(T3.character_id) AS num FROM works T1 INNER JOIN chapters T2 ON T1.id = T2.work_id INNER JOIN paragraphs T3 ON T2.id = T3.chapter_id INNER JOIN characters T4 ON T3.character_id = T4.id GROUP BY T3.character_id, T1.Title ) T ORDER BY T.num DESC LIMIT 1

Database: donor
Question: What is the total donation amount made for projects whose main subject area are Literacy & Language?
Evidence: main subject area refers to primary_focus_area = 'Literacy & Language'; total donation amount refers to Sum(dollar_amount);
SQL: SELECT SUM(T2.dollar_amount) FROM projects AS T1 INNER JOIN donations AS T2 ON T1.projectid = T2.projectid WHERE T1.primary_focus_area = 'Literacy & Language'

Database: student_loan
Question: Name 5 students with due payments that are enlisted alongside which organization they were enlisted.
Evidence: with due payments refers to bool = 'pos'; organization refers to organ
SQL: SELECT T2.organ, T1.name FROM no_payment_due AS T1 INNER JOIN enlist AS T2 ON T1.`name` = T2.`name` WHERE T1.bool = 'pos' LIMIT 5

Database: cars
Question: What is the acceleration of the most expensive car?
Evidence: the most expensive refers to max(price)
SQL: SELECT T1.acceleration FROM data AS T1 INNER JOIN price AS T2 ON T1.ID = T2.ID ORDER BY T2.price DESC LIMIT 1

Database: software_company
Question: List down the number of inhabitants of customers with a widowed marital status and false response .
Evidence: number of inhabitants refers to INHABITANTS_K; RESPONSE = 'false';
SQL: SELECT COUNT(T1.ID) FROM Customers AS T1 INNER JOIN Mailings1_2 AS T2 ON T1.ID = T2.REFID INNER JOIN Demog AS T3 ON T1.GEOID = T3.GEOID WHERE T1.MARITAL_STATUS = 'Widowed' AND T2.RESPONSE = 'true'

Database: public_review_platform
Question: Please list the businesses names whose length of user review is long with business id from 1 to 20.
Evidence: businesses names refers to business_id; length of user review is long refers to review_length = 'Long'; business_id BETWEEN 1 AND 20;
SQL: SELECT T4.category_name FROM Reviews 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 T1.review_length LIKE 'Long' AND T3.category_id BETWEEN 1 AND 20 GROUP BY T4.category_name

Database: books
Question: How many customers are from Australia?
Evidence: "Australia" is the country_name;
SQL: SELECT COUNT(*) FROM customer_address AS T1 INNER JOIN address AS T2 ON T2.address_id = T1.address_id INNER JOIN country AS T3 ON T3.country_id = T2.country_id WHERE T3.country_name = 'Australia'

Database: ice_hockey_draft
Question: What is the average weight in pounds of all the players with the highest prospects for the draft?
Evidence: average = AVG(weight_in_lbs); weight in pounds refers to weight_in_lbs; players refers to PlayerName; highest prospects for the draft refers to MAX(CSS_rank);
SQL: SELECT CAST(SUM(T2.weight_in_lbs) AS REAL) / COUNT(T1.ELITEID) FROM PlayerInfo AS T1 INNER JOIN weight_info AS T2 ON T1.weight = T2.weight_id WHERE T1.CSS_rank = ( SELECT MAX(CSS_rank) FROM PlayerInfo )

Database: professional_basketball
Question: For the players who played the most PBLA games, who was graduated from Central Missouri State college?
Evidence: the most PBLA games refers to max(games_played); Central Missouri State college refers to college = 'Central Missouri State'
SQL: SELECT T1.firstName, T1.middleName, T1.lastName FROM players AS T1 INNER JOIN players_teams AS T2 ON T1.playerID = T2.playerID WHERE T2.lgID = 'PBLA' AND T2.GP = 10 AND T1.college = 'Central Missouri State' GROUP BY T1.firstName, T1.middleName, T1.lastName ORDER BY COUNT(T2.id) DESC LIMIT 1

Database: social_media
Question: List down the text of tweets posted by unknown gender users.
Evidence: unknown gender user refers to Gender = 'Unknown'
SQL: SELECT T1.text FROM twitter AS T1 INNER JOIN user AS T2 ON T1.UserID = T2.UserID WHERE T2.Gender = 'Unknown'

Database: movies_4
Question: What is the name of the director of photography of the movie "Pirates of the Caribbean: At World's End"?
Evidence: name of the director of photography refers to person_name where job = 'Director of Photography'; "Pirates of the Caribbean: At World's End" refers to title = 'Pirates of the Caribbean: At World''s End'
SQL: SELECT T3.person_name FROM movie AS T1 INNER JOIN movie_crew AS T2 ON T1.movie_id = T2.movie_id INNER JOIN person AS T3 ON T2.person_id = T3.person_id WHERE T1.title LIKE 'Pirates of the Caribbean: At World%s End' AND T2.job = 'Director of Photography'

Database: superstore
Question: Provide the order ID of Frank Olsen of the South region.
Evidence: Frank Olsen' is the "Customer Name"; Region = 'South'
SQL: SELECT T1.`Order ID` FROM south_superstore AS T1 INNER JOIN people AS T2 ON T1.`Customer ID` = T2.`Customer ID` WHERE T2.Region = 'South' AND T2.`Customer Name` = 'Frank Olsen'

Database: cs_semester
Question: What is the capability on research of the student named Alvera McQuillin?
Evidence: capability on research refers to capability;
SQL: SELECT T2.capability FROM student AS T1 INNER JOIN RA AS T2 ON T1.student_id = T2.student_id WHERE T1.f_name = 'Alvera' AND T1.l_name = 'McQuillin'

Database: shakespeare
Question: List the character names and descriptions of chapter ID 18710.
Evidence: character names refers to CharName
SQL: SELECT DISTINCT T1.CharName, T1.Description FROM characters AS T1 INNER JOIN paragraphs AS T2 ON T1.id = T2.character_id WHERE T2.Chapter_id = 18710

Database: airline
Question: How many flights on average does American Airlines Inc. operate every day in August, 2018?
Evidence: flights on average = DIVIDE(COUNT(Code), 31); American Airlines Inc. refers to Description = 'American Airlines Inc.: AA'; every day in August, 2018 refers to FL_DATE like '2018/8%';
SQL: SELECT CAST( SUM(CASE WHEN T2.FL_DATE LIKE '2018/8%' THEN 1 ELSE 0 END) AS REAL) / 31 FROM Airports AS T1 INNER JOIN Airlines AS T2 ON T1.Code = T2.ORIGIN INNER JOIN `Air Carriers` AS T3 ON T2.OP_CARRIER_AIRLINE_ID = T3.Code WHERE T3.Description = 'American Airlines Inc.: AA'

Database: student_loan
Question: How many disabled male students joined an organization?
Evidence: organization refers to organ; disabled male students refers to disabled.name who are IN male.name;
SQL: SELECT COUNT(T1.name) FROM disabled AS T1 LEFT JOIN male AS T2 ON T2.name = T1.name INNER JOIN enlist AS T3 ON T3.name = T2.name