Database: movie_platform
Question: Please list all the links to the ratings on the movie "A Way of Life" with a critic.
Evidence: A Way of Life' refers to movie_title; with a critic refers to critic is not null, links to the ratings refers to rating_url;
SQL: SELECT T1.rating_url 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.critic IS NOT NULL

Database: human_resources
Question: Give the full address of the office of the highest paid manager.
Evidence: the highest paid refers to MAX(salary); manager is a position title
SQL: SELECT T2.address FROM employee AS T1  INNER JOIN location AS T2  ON T1.locationID = T2.locationID INNER JOIN position AS T3  ON T3.positionID = T1.positionID WHERE T3.positiontitle = 'Manager' ORDER BY T1.salary DESC LIMIT 1

Database: movie_3
Question: Among the times Mary Smith had rented a movie, how many of them happened in June, 2005?
Evidence: in June 2005 refers to year(payment_date) = 2005 and month(payment_date) = 6
SQL: SELECT COUNT(T1.customer_id) FROM payment AS T1 INNER JOIN customer AS T2 ON T1.customer_id = T2.customer_id WHERE T2.first_name = 'MARY' AND T2.last_name = 'SMITH' AND STRFTIME('%Y',T1.payment_date) = '2005' AND STRFTIME('%Y', T1.payment_date) = '6'

Database: soccer_2016
Question: What is the role of SC Ganguly?
Evidence: SC Ganguly refers to Player_Name = 'SC Ganguly'; role refers to Role_Desc
SQL: SELECT T3.Role_Desc FROM Player AS T1 INNER JOIN Player_Match AS T2 ON T1.Player_Id = T2.Player_Id INNER JOIN Rolee AS T3 ON T2.Role_Id = T3.Role_Id WHERE T1.Player_Name = 'SC Ganguly' GROUP BY T3.Role_Desc

Database: books
Question: Provide the full address of Ursola Purdy.
Evidence: full address refers to street_number, street_name, city, country_name
SQL: SELECT T3.street_number, T3.street_name, T3.city FROM customer AS T1 INNER JOIN customer_address AS T2 ON T1.customer_id = T2.customer_id INNER JOIN address AS T3 ON T3.address_id = T2.address_id INNER JOIN country AS T4 ON T4.country_id = T3.country_id WHERE T1.first_name = 'Ursola' AND T1.last_name = 'Purdy'

Database: movielens
Question: How many female actors have been played a role in any of French or USA movies?
Evidence: French and USA are two countries; Female actors mean that a_gender = 'F'
SQL: SELECT COUNT(T2.actorid) FROM movies AS T1 INNER JOIN movies2actors AS T2 ON T1.movieid = T2.movieid WHERE T1.country IN ('France', 'USA')

Database: food_inspection
Question: Give the name of the business which met all the required standards during the unscheduled routine inspection on 2016/9/28.
Evidence: met all the required standards refers to score = 100; unscheduled routine inspection on 2016/9/28 refers to type = 'Routine - Unscheduled' where date = '2016-09-28';
SQL: SELECT T2.name FROM inspections AS T1 INNER JOIN businesses AS T2 ON T1.business_id = T2.business_id WHERE T1.score = 100 AND T1.`date` = '2016-09-28' AND T1.type = 'Routine - Unscheduled'

Database: university
Question: In Argentina, how many universities are there?
Evidence: In Argentina refers to country_name = 'Argentina';
SQL: SELECT COUNT(*) FROM university AS T1 INNER JOIN country AS T2 ON T1.country_id = T2.id WHERE T2.country_name = 'Argentina'

Database: synthea
Question: Among the patients that died, what is the condition of the oldest patient?
Evidence: if deathdate is not null, it means this patient died; condition refers to DESCRIPTION from conditions; the oldest patient refers to MAX(SUBTRACT(strftime('%Y', deathdate), strftime('%Y', birthdate)));
SQL: SELECT T1.DESCRIPTION FROM conditions AS T1 INNER JOIN patients AS T2 ON T1.PATIENT = T2.patient WHERE T2.deathdate IS NOT NULL ORDER BY strftime('%Y', T2.deathdate) - strftime('%Y', T2.birthdate) DESC LIMIT 1

Database: authors
Question: List the short name and home page URL of all the international conferences on artificial intelligence.
Evidence: all the international conferences on artificial intelligence refers to FullName LIKE 'International Conference on Artificial Intelligence%'
SQL: SELECT ShortName, HomePage FROM Conference WHERE FullName LIKE 'International Conference on Artificial Intelligence%'

Database: public_review_platform
Question: For all the Yelp businesses that allow customers bring their own beer, what percentage of them are in "Phoenix"?
Evidence: bring their own beer refers to attribute_name = 'BYOB' AND attribute_value = 'TRUE'; Phoenix refers to city = 'Phoenix'; percentage = MULTIPLY(DIVIDE(SUM(city = 'Phoenix'), COUNT(business_id)), 1.0)
SQL: SELECT CAST(SUM(CASE WHEN T3.city LIKE 'Phoenix' THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(T2.business_id) AS "percentage" FROM Attributes AS T1 INNER JOIN Business_Attributes AS T2 ON T1.attribute_id = T2.attribute_id INNER JOIN Business AS T3 ON T2.business_id = T3.business_id WHERE T1.attribute_name LIKE 'BYOB' AND T2.attribute_value LIKE 'TRUE'

Database: beer_factory
Question: Find and list the full name and email of the customers who used American Express cards in Sac State Union.
Evidence: full name = First, Last; American Express cards refers to CreditCardType = 'American Express'; Sac State Union refers to LocationName = 'Sac State Union';
SQL: SELECT DISTINCT T1.First, T1.Last, T1.Email FROM customers AS T1 INNER JOIN `transaction` AS T2 ON T1.CustomerID = T2.CustomerID INNER JOIN location AS T3 ON T2.LocationID = T3.LocationID WHERE T3.LocationName = 'Sac State Union' AND T2.CreditCardType = 'American Express'

Database: law_episode
Question: List down the titles of the top 3 episodes, from highest to lowest, in terms of their weighted stars.
Evidence: weighted stars = divide(sum(stars, percent), 100)
SQL: SELECT T2.title FROM Vote AS T1 INNER JOIN Episode AS T2 ON T2.episode_id = T1.episode_id WHERE T1.stars BETWEEN 1 AND 10 GROUP BY T2.title ORDER BY CAST(SUM(T1.stars * T1.percent) AS REAL) / 100 DESC LIMIT 3

Database: language_corpus
Question: State the word ID for "periodograma".
Evidence: word ID refers to wid; periodograma refers to word = 'periodograma'
SQL: SELECT wid FROM words WHERE word = 'periodograma'

Database: soccer_2016
Question: How many cities are located in South Africa?
Evidence: South Africa refers to Country_Name = 'South Africa'
SQL: SELECT SUM(CASE WHEN T2.Country_Name = 'South Africa' THEN 1 ELSE 0 END) FROM City AS T1 INNER JOIN Country AS T2 ON T2.Country_Id = T1.Country_id

Database: public_review_platform
Question: List down the business ID with a high review count in Tempe.
Evidence: Tempe is a city; high review count refers to review_count = 'High'
SQL: SELECT business_id FROM Business WHERE review_count = 'High' AND city = 'Tempe'

Database: ice_hockey_draft
Question: Identify the players who weigh 120 kg.
Evidence: players refers to PlayerName; weigh 120 kg refers to weight_in_kg = 120;
SQL: SELECT T2.PlayerName FROM weight_info AS T1 INNER JOIN PlayerInfo AS T2 ON T1.weight_id = T2.weight WHERE T1.weight_in_kg = 120

Database: soccer_2016
Question: What are the names of players who participated in season year 2008?
Evidence: season year 2008 refers to Season_Year = 2008
SQL: SELECT T1.Player_Name FROM Player AS T1 INNER JOIN Match AS T2 ON T1.Player_Id = T2.Man_of_the_Match INNER JOIN Player_Match AS T3 ON T3.Player_Id = T1.Player_Id INNER JOIN Season AS T4 ON T2.Season_Id = T4.Season_Id WHERE T4.Season_Year = 2008 GROUP BY T1.Player_Name

Database: superstore
Question: List the products ordered by customers in Coachella.
Evidence: in Coachella refers to City = 'Coachella'; products refers to "Product Name"
SQL: SELECT DISTINCT T3.`Product Name` FROM west_superstore AS T1 INNER JOIN people AS T2 ON T1.`Customer ID` = T2.`Customer ID` INNER JOIN product AS T3 ON T3.`Product ID` = T1.`Product ID` WHERE T2.City = 'Coachella'