Database: professional_basketball
Question: What is the full name of the team that the 'NBA Coach of the Year' 1992 winner coached?
Evidence: "NBA Coach of the Year" is the award; in 1992 refers to year = 1992;
SQL: SELECT name FROM teams AS T1 INNER JOIN coaches AS T2 ON T1.tmID = T2.tmID AND T1.year = T2.year INNER JOIN awards_coaches AS T3 ON T2.coachID = T3.coachID AND T2.year = T3.year WHERE T3.year = 1992 AND award = 'NBA Coach of the Year'

Database: coinmarketcap
Question: How many times was Bytecoin traded in June 2013?
Evidence: in June 2013 refers to year(date) = 2013 AND month(date) = 6
SQL: SELECT COUNT(T2.coin_id) FROM coins AS T1 INNER JOIN historical AS T2 ON T1.id = T2.coin_id WHERE T1.name = 'Bytecoin' AND STRFTIME('%Y-%m', T2.date) = '2013-06'

Database: donor
Question: Of the projects whose resources are provided by the vendor Lakeshore Learning Materials, the school of which project has the highest cost of labor fulfillment? Please give its school ID.
Evidence: Lakeshore Learning Materials is vendor_name; highest cost of labor fulfillment refers to Max(fulfillment_labor_materials);
SQL: SELECT T2.schoolid FROM resources AS T1 INNER JOIN projects AS T2 ON T1.projectid = T2.projectid WHERE T1.vendor_name = 'Lakeshore Learning Materials' ORDER BY T2.fulfillment_labor_materials DESC LIMIT 1

Database: movielens
Question: How many actors have acted in both US or UK films?
Evidence: US and UK are 2 countries
SQL: SELECT COUNT(T1.actorid) FROM movies2actors AS T1 INNER JOIN movies AS T2 ON T1.movieid = T2.movieid WHERE T2.country = 'USA' OR T2.country = 'UK'

Database: cs_semester
Question: Describe the names and credits of the least difficult courses.
Evidence: diff refers to difficulty; the least difficult courses refer to MIN(diff);
SQL: SELECT name, credit FROM course WHERE diff = ( SELECT MIN(diff) FROM course )

Database: professional_basketball
Question: List out all the coach ID who have served more than 2 different teams.
Evidence: more than 2 different teams refers to count(tmID) > 2
SQL: SELECT coachID FROM coaches GROUP BY coachID HAVING COUNT(DISTINCT tmID) > 2

Database: sales_in_weather
Question: Which items from store 1 have the highest units sold during rainy day?
Evidence: store 1 refers to store_nbr = 1; highest unit sold refers to Max(units); during rainy day refers to codesum like '%'||'RA'||'%'; item refers to item_nbr
SQL: SELECT T2.item_nbr FROM weather AS T1 INNER JOIN sales_in_weather AS T2 ON T1.`date` = T2.`date` INNER JOIN relation AS T3 ON T2.store_nbr = T3.store_nbr AND T1.station_nbr = T3.station_nbr WHERE T2.store_nbr = 1 AND T1.codesum LIKE '%' OR 'RA' OR '%' GROUP BY T2.item_nbr ORDER BY T2.units DESC LIMIT 1

Database: simpson_episodes
Question: Among the episodes which have star score greater than 5, how many episodes have air date in 2008?
Evidence: star score greater than 5 refers to stars > 5; have air date in 2008 refers to air_date LIKE '2008%'
SQL: SELECT COUNT(DISTINCT T2.episode_id) FROM Episode AS T1 INNER JOIN Vote AS T2 ON T2.episode_id = T1.episode_id WHERE strftime('%Y', T1.air_date) = '2008' AND T2.stars > 5;

Database: public_review_platform
Question: Please list the business IDs of all the Yelp_Businesses that are good for kids.
Evidence: good for kids refers to attribute_name = 'Good for Kids' and attribute_value = 'true'

SQL: SELECT 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 'Good for Kids' AND T2.attribute_value LIKE 'TRUE'

Database: student_loan
Question: What percentage of students who enlisted in the navy make up the number of students enrolled in OCC?
Evidence: in the navy refers to organ = 'navy'; enrolled in OCC refers to school = 'occ'
SQL: SELECT CAST(SUM(IIF(T1.school = 'occ', 1.0, 0)) AS REAL) * 100 / COUNT(T1.name) FROM enrolled AS T1 INNER JOIN enlist AS T2 ON T1.`name` = T2.`name` WHERE T2.organ = 'navy'

Database: movielens
Question: How many female actors acted in the movies of year 4?
Evidence: 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 INNER JOIN actors AS T3 ON T2.actorid = T3.actorid WHERE T3.a_gender = 'F' AND T1.year = 4

Database: chicago_crime
Question: Among the crimes located in the community area with the highest population, what is the percentage of domestic violence?
Evidence: the highest population refers to max(population); domestic violence refers to domestic = 'TRUE'; percentage = divide(count(domestic = 'TRUE'), count(domestic)) where population = max(population) * 100%
SQL: SELECT CAST(COUNT(CASE WHEN T2.domestic = 'TRUE' THEN T2.domestic END) AS REAL) * 100 / COUNT(T2.domestic) FROM Community_Area AS T1 INNER JOIN Crime AS T2 ON T2.community_area_no = T1.community_area_no GROUP BY T1.community_area_no HAVING COUNT(T1.population) ORDER BY COUNT(T1.population) DESC LIMIT 1

Database: donor
Question: For project titled 'Toot Your Flute!', what is the main subject of the project materials intended for? Name the other projects with the similar focus.
Evidence: main subject refers to primary_focus_subject
SQL: SELECT T2.primary_focus_subject FROM essays AS T1 INNER JOIN projects AS T2 ON T1.projectid = T2.projectid WHERE T1.title = 'Toot Your Flute!'

Database: movie_3
Question: Please list the top ten movies with the most price per day in descending order of price per day.
Evidence: movies with the most price per day refers to MAX(rental_rate)
SQL: SELECT title FROM film ORDER BY rental_rate / rental_duration DESC LIMIT 10

Database: ice_hockey_draft
Question: Who has played the most game plays in the 2000-2001 season of the International league?
Evidence: played the most game plays refers to MAX(GP); 2000-2001 season refers to SEASON = '2000-2001'; International league refers to LEAGUE = 'International';
SQL: SELECT DISTINCT T2.PlayerName FROM SeasonStatus AS T1 INNER JOIN PlayerInfo AS T2 ON T1.ELITEID = T2.ELITEID WHERE T1.SEASON = '2000-2001' AND T1.LEAGUE = 'International' ORDER BY T1.GP DESC LIMIT 1

Database: movies_4
Question: Please list the names of the production company of the movie "Four Rooms".
Evidence: names of the production company refers to movie_company; movie "Four Rooms" refers to title = 'Four Rooms'
SQL: SELECT T1.company_name FROM production_company AS T1 INNER JOIN movie_company AS T2 ON T1.company_id = T2.company_id INNER JOIN movie AS T3 ON T2.movie_id = T3.movie_id WHERE T3.title = 'Four Rooms'

Database: airline
Question: What is the tail number of a Compass Airline's plane that flew the most number of flights from LAX to ABQ?
Evidence: tail number refers to TAIL_NUM; Compass Airline refers to Description = 'Compass Airlines: CP'; flew the most number of lights from LAX TO ABQ refers to MAX(COUNT(OP_CARRIER_AIRLINE_ID WHERE ORIGIN = 'LAX' and DEST = 'ABQ')); from LAX refers to ORIGIN = 'LAX'; to ABQ refers to DEST = 'ABQ';
SQL: SELECT T2.OP_CARRIER_AIRLINE_ID FROM `Air Carriers` AS T1 INNER JOIN Airlines AS T2 ON T1.Code = T2.OP_CARRIER_AIRLINE_ID WHERE T1.Description = 'Compass Airlines: CP' AND T2.ORIGIN = 'LAX' AND T2.DEST = 'ABQ' GROUP BY T2.OP_CARRIER_AIRLINE_ID ORDER BY COUNT(T2.OP_CARRIER_AIRLINE_ID) DESC LIMIT 1

Database: restaurant
Question: Indicate the street numbers where Aux Delices Vietnamese Restaurant are located.
Evidence: street numbers refers to street_num; Aux Delices Vietnamese Restaurant refers to label = 'aux delices vietnamese restaurant'
SQL: SELECT DISTINCT T1.street_num FROM location AS T1 INNER JOIN generalinfo AS T2 ON T1.id_restaurant = T2.id_restaurant WHERE T2.label = 'aux delices vietnamese restaurant'