Database: professional_basketball
Question: Which winning team in the final round of the postseason series games against the LAL won more than 60 games in the NBA league during the year 1996?
Evidence: final round of post season refers to round = 'CSF'; won against LAL refers to tmIDLoser = 'LAL'; in the NBA league refers to lgID = 'NBA'; won more than 60 games refers to won > 60
SQL: SELECT DISTINCT T2.tmID FROM series_post AS T1 INNER JOIN teams AS T2 ON T1.tmIDWinner = T2.tmID WHERE T2.won > 60 AND T1.year = 1996 AND T1.round = 'CSF' AND T1.tmIDLoser = 'LAL'

Database: public_review_platform
Question: What are the categories that business number 15 belongs to?
Evidence: business number refers to business_id;
SQL: SELECT T2.category_name FROM Business_Categories AS T1 INNER JOIN Categories AS T2 ON T1.category_id = T2.category_id WHERE T1.business_id = 15

Database: law_episode
Question: Which role did Joseph Blair play in the show?
SQL: SELECT T1.role FROM Credit AS T1 INNER JOIN Person AS T2 ON T2.person_id = T1.person_id WHERE T2.name = 'Joseph Blair'

Database: synthea
Question: Provide the name of the patient who had a claim on 1947/9/11.
Evidence: name of the patient implies full name and refers to first, last; on 1947/9/11 refers to BILLABLEPERIOD = '1947-09-11';
SQL: SELECT T1.first, T1.last FROM patients AS T1 INNER JOIN claims AS T2 ON T1.patient = T2.PATIENT WHERE T2.billableperiod = '1947-09-11'

Database: book_publishing_company
Question: Among all employees, who have job level greater than 200. State the employee name and job description.
Evidence: job level greater than 200 refers to job_lvl>200; job description refers to job_desc
SQL: SELECT T1.fname, T1.lname, T2.job_desc FROM employee AS T1 INNER JOIN jobs AS T2 ON T1.job_id = T2.job_id WHERE T1.job_lvl > 200

Database: public_review_platform
Question: How many businesses have a romantic ambiance?
Evidence: romantic ambiance refers to attribute_name = 'ambience_romantic' 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 T2.attribute_value = 'true' AND T1.attribute_name = 'ambience_romantic'

Database: coinmarketcap
Question: Name the coin under the token category that gives the highest max profit.
Evidence: the highest max profit refers to max(subtract(high, low))
SQL: SELECT T1.name FROM coins AS T1 INNER JOIN historical AS T2 ON T1.id = T2.coin_id WHERE T1.category = 'token' ORDER BY T2.high - T2.low DESC LIMIT 1

Database: student_loan
Question: How many students are enrolled in smc during month 1?
Evidence: smc refers to school = 'smc';
SQL: SELECT COUNT(name) FROM enrolled WHERE school = 'smc' AND month = 1

Database: authors
Question: What is the title of the paper that was written by Cheng Huang and affiliated with Microsoft?
Evidence: paper that was written by Cheng Huang refers to Name = 'Cheng Huang'; affiliated with Microsoft refers to Affiliation LIKE 'Microsoft %'
SQL: SELECT T1.Title FROM Paper AS T1 INNER JOIN PaperAuthor AS T2 ON T1.Id = T2.PaperId WHERE T2.Name = 'Cheng Huang' AND T2.Affiliation = 'Microsoft'

Database: ice_hockey_draft
Question: Among the players that weigh more than 90 kg, how many of them have a position of defense?
Evidence: weigh more than 90 kg refers to weight_in_kg > 90; position of defense refers to position_info = 'D' ;
SQL: SELECT COUNT(T1.ELITEID) FROM PlayerInfo AS T1 INNER JOIN weight_info AS T2 ON T1.weight = T2.weight_id WHERE T2.weight_in_kg > 90 AND T1.position_info = 'D'

Database: cookbook
Question: How much Vitamin A is in Sherry beef?
Evidence: Sherry beef refers to title = 'Sherried Beef'
SQL: SELECT T2.vitamin_a FROM Recipe AS T1 INNER JOIN Nutrition AS T2 ON T1.recipe_id = T2.recipe_id WHERE T1.title = 'Sherried Beef'

Database: world
Question: List all the languages used in Europe.
Evidence: Europe refers to Continent = 'Europe';
SQL: SELECT T2.Language FROM Country AS T1 INNER JOIN CountryLanguage AS T2 ON T1.Code = T2.CountryCode WHERE T1.Continent = 'Europe'

Database: books
Question: Which year has the most customer orders?
Evidence: year with the most customer orders refers to Max(count(order_id))
SQL: SELECT strftime('%Y', order_date) FROM cust_order GROUP BY strftime('%Y', order_date) ORDER BY COUNT(strftime('%Y', order_date)) DESC LIMIT 1

Database: food_inspection_2
Question: What is the inspection ID of the inspection with critical point level, $500 fine, and inspector comment "CDI ON 5-17-10"?
Evidence: critical point level refers to point_level = 'Critical'; $500 fine refers to fine = 500; inspector comment "CDI ON 5-17-10" refers to inspector_comment = 'CDI ON 5-17-10'
SQL: SELECT T2.inspection_id FROM inspection_point AS T1 INNER JOIN violation AS T2 ON T1.point_id = T2.point_id WHERE T2.fine = 500 AND T1.point_level = 'Critical' AND T2.inspector_comment = 'CDI ON 5-17-10'

Database: synthea
Question: Please list all the medication that are prescribed to Elly Koss.
Evidence: medication that are prescribed refers to DESCRIPTION from medications;
SQL: SELECT DISTINCT T2.description FROM patients AS T1 INNER JOIN medications AS T2 ON T1.patient = T2.PATIENT WHERE T1.first = 'Elly' AND T1.last = 'Koss'

Database: legislator
Question: How many legislators have an Instagram account?
Evidence: have an Instagram account refers to instagram is NOT null and instagram <>''
SQL: SELECT COUNT(*) FROM `social-media` WHERE instagram IS NOT NULL AND instagram <> ''

Database: retail_world
Question: What is the full name of the Vice President of Sales. Give me the URL of his/her photo.
Evidence: "Vice Present of Sales" refers to Title = 'Vice President, Sales'; full name refers to FirstName, LastName; url of photo refers to PhotoPath
SQL: SELECT FirstName, LastName FROM Employees WHERE Title = 'Vice President, Sales'

Database: retail_world
Question: Describe Sales Representative names who were hired in 1992 and compare the number of orders among them.
Evidence: Sales Representative refers to Title = 'Sales Representative'；were hired in 1992 refers to HireDate = '1992'
SQL: SELECT T1.FirstName, T1.LastName, COUNT(T2.OrderID) FROM Employees AS T1 INNER JOIN Orders AS T2 ON T1.EmployeeID = T2.EmployeeID WHERE T1.Title = 'Sales Representative' AND STRFTIME('%Y', T1.HireDate) = '1992' GROUP BY T1.EmployeeID, T1.FirstName, T1.LastName

Database: cs_semester
Question: Among students that gave satisfaction of value 4 for the course named "Statistical Learning", how many of them have a gpa of 3.8?
Evidence: satisfaction refers to sat;

sat = 4; gpa = 3.8 
SQL: SELECT COUNT(T1.student_id) FROM student AS T1 INNER JOIN registration AS T2 ON T1.student_id = T2.student_id INNER JOIN course AS T3 ON T2.course_id = T3.course_id WHERE T3.name = 'Statistical learning' AND T2.sat = 4 AND T1.gpa = 3.8

Database: law_episode
Question: How many 6-star votes did episode 12 get? Please include the air date and rating.
Evidence: 6-star vote refers to stars = 6
SQL: SELECT T2.air_date, T2.rating FROM Vote AS T1 INNER JOIN Episode AS T2 ON T2.episode_id = T1.episode_id WHERE T1.stars = 6 AND T2.episode = 12

Database: retail_complains
Question: Among all the clients from the New York city, how many of them have filed a complaint on the issue of Deposits and withdrawals?
SQL: SELECT COUNT(T2.Issue) FROM client AS T1 INNER JOIN events AS T2 ON T1.client_id = T2.Client_ID WHERE T2.Issue = 'Deposits and withdrawals' AND T1.city = 'New York City'

Database: retail_world
Question: How many companies do ship Northwind's orders?
Evidence: companies refers to ShipperID
SQL: SELECT COUNT(ShipperID) FROM Shippers

Database: chicago_crime
Question: What is the ward ID of the most crowded ward?
Evidence: most crowded ward refers to Max(Population)
SQL: SELECT ward_no FROM Ward ORDER BY Population DESC LIMIT 1