Database: college_completion
Question: Give the web site address for the school in "PA" state with the highest latitude.
Evidence: web site address refers to site; PA refers to state_abbr = 'PA'; highest latitude refers to MAX(lat_y);
SQL: SELECT DISTINCT T1.site FROM institution_details AS T1 INNER JOIN state_sector_grads AS T2 ON T2.state = T1.state WHERE T2.state_abbr = 'PA' AND T1.lat_y = ( SELECT MAX(T1.lat_y) FROM institution_details AS T1 INNER JOIN state_sector_grads AS T2 ON T2.state = T1.state WHERE T2.state_abbr = 'PA' )

Database: movielens
Question: How many female actresses appeared in the movie 2312852, what country was it in, and what was it's running time?
Evidence: female actresses mean that a_gender = 'F'
SQL: SELECT SUM(IIF(T1.a_gender = 'F', 1, 0)) , T3.country, T3.runningtime FROM actors AS T1 INNER JOIN movies2actors AS T2 ON T1.actorid = T2.actorid INNER JOIN movies AS T3 ON T2.movieid = T3.movieid WHERE T2.movieid = 2312852 GROUP BY T3.country, T3.runningtime

Database: video_games
Question: How many games were published by Acclaim Entertainment?
Evidence: published by Acclaim Entertainment refers to publisher_name = 'Acclaim Entertainment'
SQL: SELECT COUNT(DISTINCT T1.game_id) FROM game_publisher AS T1 INNER JOIN publisher AS T2 ON T1.publisher_id = T2.id WHERE T2.publisher_name = 'Acclaim Entertainment'

Database: movielens
Question: What is the ID of audiences that gave the most rating of 5?
Evidence: The audience and users are the same meaning
SQL: SELECT userid FROM u2base WHERE rating = 5 GROUP BY userid ORDER BY COUNT(movieid) DESC LIMIT 1

Database: cookbook
Question: How many baking product ingredients are there in the No-Bake Chocolate Cheesecake?
Evidence: baking product is a category; No-Bake Chocolate Cheesecake refers to title;
SQL: SELECT COUNT(*) FROM Recipe AS T1 INNER JOIN Quantity AS T2 ON T1.recipe_id = T2.recipe_id INNER JOIN Ingredient AS T3 ON T3.ingredient_id = T2.ingredient_id WHERE T3.category = 'baking products' AND T1.title = 'No-Bake Chocolate Cheesecake'

Database: movies_4
Question: List 10 movie titles that were produced in France.
Evidence: France refers to country_name = 'France'
SQL: SELECT T1.title FROM movie AS T1 INNER JOIN production_COUNTry AS T2 ON T1.movie_id = T2.movie_id INNER JOIN COUNTry AS T3 ON T2.COUNTry_id = T3.COUNTry_id WHERE T3.COUNTry_name = 'France' LIMIT 10

Database: authors
Question: What is the average number of papers published in the World Computer Congress each year?
Evidence: published in the World Computer Congress refers to FullName = 'World Computer Congress'; average refers to DIVIDE(COUNT(FullName = 'World Computer Congress'), COUNT(Id))
SQL: SELECT CAST(SUM(CASE WHEN T2.FullName = 'International Congress Series' THEN 1 ELSE 0 END) AS REAL) / COUNT(T1.Id) AS Div1, T1.Year FROM Paper AS T1 INNER JOIN Journal AS T2 ON T1.JournalId = T2.Id GROUP BY T1.YEAR HAVING Div1 != 0

Database: cookbook
Question: What is the title of the recipe that is most likely to gain weight?
Evidence: most likely to gain weight refers to MAX(total_fat)
SQL: SELECT T1.title FROM Recipe AS T1 INNER JOIN Nutrition AS T2 ON T1.recipe_id = T2.recipe_id ORDER BY T2.total_fat DESC LIMIT 1

Database: world
Question: Write down the name of the largest population country.
Evidence: largest population refers to MAX(Population);
SQL: SELECT Name FROM Country ORDER BY Population DESC LIMIT 1

Database: european_football_1
Question: What's the name of the football division in the Netherlands?
Evidence: Netherlands is the name of country;
SQL: SELECT name FROM divisions WHERE country = 'Netherlands'

Database: movie_3
Question: How many customers paid over the amount of 10 on August 2005?
Evidence: over the amount of 10 refers to amount > 10; paid on August 2005 refers to payment_date like '2005_08%'; customer refers to customer_id
SQL: SELECT COUNT(customer_id) FROM payment WHERE SUBSTR(payment_date, 1, 7) LIKE '2005-08'

Database: public_review_platform
Question: Give the number of "dogs allowed" Yelp businesses.
Evidence: number of Yelp businesses refers to business_id; dogs allowed refers to attribute_name = 'Dogs Allowed' AND attribute_value = 'true';
SQL: SELECT COUNT(T2.business_id) FROM Attributes AS T1 INNER JOIN Business_Attributes AS T2 ON T1.attribute_id = T2.attribute_id WHERE T1.attribute_name LIKE 'Dogs Allowed' AND T2.attribute_value LIKE 'TRUE'

Database: car_retails
Question: For the order has the most product ordered, name the customer who placed the order.
Evidence: The largest order in terms of total price refers to MAX(SUM(MULTIPLY(quantityOrdered, priceEach)).
SQL: SELECT T2.firstName, T2.lastName FROM offices AS T1 INNER JOIN employees AS T2 ON T1.officeCode = T2.officeCode WHERE T2.employeeNumber = ( SELECT MAX(employeeNumber) FROM employees )

Database: talkingdata
Question: List at least 3 categories with the lowest number of users.
Evidence: lowest number of users refers to MIN(COUNT(label_id));
SQL: SELECT T1.category FROM label_categories AS T1 INNER JOIN app_labels AS T2 ON T1.label_id = T2.label_id ORDER BY T2.label_id LIMIT 3

Database: synthea
Question: Tell me the reason for Lavelle Vandervort's encounter on 11/20/2013?
Evidence: reason for encounter refers to encounters.REASONDESCRIPTION; on 11/20/2013 refers to encounters.DATE = '2013-11-20';
SQL: SELECT T2.REASONDESCRIPTION FROM patients AS T1 INNER JOIN encounters AS T2 ON T1.patient = T2.PATIENT WHERE T2.DATE = '2013-11-20' AND T1.first = 'Lavelle' AND T1.last = 'Vandervort'

Database: cars
Question: What is the horsepower and model year of the car named Subaru Dl?
Evidence: the car named Subaru Dl refers to car_name = 'subaru dl'
SQL: SELECT T1.horsepower, T2.model_year FROM data AS T1 INNER JOIN production AS T2 ON T1.ID = T2.ID WHERE T1.car_name = 'subaru dl'

Database: synthea
Question: Describe the care plans received by the patient with secondary malignant neoplasm of the colon.
Evidence: care plans refer to DESCRIPTION from careplans; secondary malignant neoplasm of the colon refers to conditions where DESCRIPTION = 'Secondary malignant neoplasm of colon';
SQL: SELECT DISTINCT T1.DESCRIPTION FROM careplans AS T1 INNER JOIN conditions AS T2 ON T1.patient = T2.PATIENT WHERE T2.DESCRIPTION = 'Secondary malignant neoplasm of colon'

Database: student_loan
Question: What is the percentage of unemployed students who have been absent for 5 months from school?
Evidence: percentage refers to DIVIDE(COUNT(month > 5), COUNT(month))
SQL: SELECT CAST(SUM(IIF(T1.month > 5, 1, 0)) AS REAL) * 100 / COUNT(T1.month) FROM longest_absense_from_school AS T1 INNER JOIN unemployed AS T2 ON T1.name = T2.name

Database: citeseer
Question: List all paper ID and its class type with more than 20 cited words.
Evidence: class type refers to class_label; count(word_cited_id)>20
SQL: SELECT DISTINCT T1.paper_id, T1.class_label FROM paper AS T1 INNER JOIN content AS T2 ON T1.paper_id = T2.paper_id GROUP BY T2.paper_id, T1.class_label HAVING COUNT(T2.word_cited_id) > 20

Database: movies_4
Question: Write the titles of horror films with a vote average of more than 7.
Evidence: horror films refers to genre_name = 'Horror'; vote average of more than 7 refers to vote_average > 7
SQL: SELECT T1.title FROM movie AS T1 INNER JOIN movie_genres AS T2 ON T1.movie_id = T2.movie_id INNER JOIN genre AS T3 ON T2.genre_id = T3.genre_id WHERE T3.genre_name = 'Horror' AND vote_average > 7

Database: image_and_language
Question: How many object samples in image no.908 are in the class of tip?
Evidence: object samples in the class of "tip" refer to OBJ_CLASS_ID where OBJ_CLASS = 'tip'; image no.5 refers to IMG_ID = 5;
SQL: SELECT SUM(CASE WHEN T2.OBJ_CLASS = 'tip' THEN 1 ELSE 0 END) FROM IMG_OBJ AS T1 INNER JOIN OBJ_CLASSES AS T2 ON T1.OBJ_CLASS_ID = T2.OBJ_CLASS_ID WHERE T1.IMG_ID = 908