Write the SQL for the following:

Table:

Schema:

2. Find all players who played on a Boston team and a Denver team (possibly in different seasons). List their first names and ilkids. 3. Find everyone who was a coach and a player on the same team in the same season. List their first . Find the average height (in centimeters) of each team in the 2001 season. Print the team name, the 5. Find the coaches (first name, last name, and cid) who coached the largest number of players in 1999. name, last name, the team, and the year for every time this happened. coach name, and the average height, and return your results in order of increasing height. . coaches season: table describing the performance of coaches in one season 2. teams: table with basic information about NBA teams 3. players: table with basic information about NBA players player rs: table with detailed information about how players performed in a given regular season 5. playerrs.career: table summarizing pl 6. draft: table with information about the NBA draft ayers regular season performance across their careers COACHES SEASON cid yr_orderfirstname lastname season_ win season_loss playoff win playoff loss tid TEAMS tid location league name PLAYERS ilkid firstname lastname position first season last seasonh feet h inches weight college birthday PLAYER RS ilkid reb PLAYER RS CAREER ilkid firstname lastnametid stl league pts fta dreb ftm minutes oreb asts blk turnoverP gm firstname lastname league blk minutes pts dreb reb asts turnover p DRAF draft year draft round selection tid firstname lastname ilkid draft from league 2. Find all players who played on a Boston team and a Denver team (possibly in different seasons). List their first names and ilkids. 3. Find everyone who was a coach and a player on the same team in the same season. List their first . Find the average height (in centimeters) of each team in the 2001 season. Print the team name, the 5. Find the coaches (first name, last name, and cid) who coached the largest number of players in 1999. name, last name, the team, and the year for every time this happened. coach name, and the average height, and return your results in order of increasing height. . coaches season: table describing the performance of coaches in one season 2. teams: table with basic information about NBA teams 3. players: table with basic information about NBA players player rs: table with detailed information about how players performed in a given regular season 5. playerrs.career: table summarizing pl 6. draft: table with information about the NBA draft ayers regular season performance across their careers COACHES SEASON cid yr_orderfirstname lastname season_ win season_loss playoff win playoff loss tid TEAMS tid location league name PLAYERS ilkid firstname lastname position first season last seasonh feet h inches weight college birthday PLAYER RS ilkid reb PLAYER RS CAREER ilkid firstname lastnametid stl league pts fta dreb ftm minutes oreb asts blk turnoverP gm firstname lastname league blk minutes pts dreb reb asts turnover p DRAF draft year draft round selection tid firstname lastname ilkid draft from league