Write the SQL for the following:

Table:

Schema:

6. Find the coaches (first name, last name, and cid) who have coached in every league. 7. Find everyone who was a coach and player in the same season, but for different teams. List their first name, last name, the season, and both teams every time this happened. Order the results from oldest to most recent. 8. Find all players who scored more points than Michael Jordan. Print their first name, last name, and 9. Find the second most successful coach (first name and last name) in the database, where success is 10. Find the 3 schools that sent the most players to the NBA draft. Print the name of each school and how many more points they scored than Michael. measured as seaon.vin / (season.in season loss) acros all of the seasons they coached how many players they sent, in decreasing order . 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 6. Find the coaches (first name, last name, and cid) who have coached in every league. 7. Find everyone who was a coach and player in the same season, but for different teams. List their first name, last name, the season, and both teams every time this happened. Order the results from oldest to most recent. 8. Find all players who scored more points than Michael Jordan. Print their first name, last name, and 9. Find the second most successful coach (first name and last name) in the database, where success is 10. Find the 3 schools that sent the most players to the NBA draft. Print the name of each school and how many more points they scored than Michael. measured as seaon.vin / (season.in season loss) acros all of the seasons they coached how many players they sent, in decreasing order . 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