Write some SQL queries. The database contains the following six tables:

Your goal for this project will be to write 10 SELECT queries to answer the 10 questions below. Note that you should use the cid, ilkid, and tid fields to identify coaches, players, and teams, as there may be coaches, players, and teams that share the same name.

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 how many more points they scored than Michael.

9. Find the second most successful coach (first name and last name) in the database, where success is measured as season_win / (season_win + season_loss) across all of the seasons they coached.

10. Find the 3 schools that sent the most players to the NBA draft. Print the name of each school and how many players they sent, in decreasing order.

1. 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 4. player-rs: table with detailed information about how players performed in a given regular season 5. playerrs.career: table summarizing players' regular season performance across their careers 6. draft: table with information about the NBA draft COACHES SEASON cid order firstname lastname season win season loss playoff win playoff loss tid TEAMS tid location PLAYERS ilkid firstname lastname oson first season last season h feet h inches weight college birthday PLAYER RS ilkid firstname lastname tid stl minutes pts leaguegp ga asts blk turnoverpf gm PLAYER RS CAREER ilkid firstname lastname league gp turnoverp minutes ts asts blk ga fta ftm im DRAFT year draft round sclection tid firstname lastname ilkid draft from league 1. 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 4. player-rs: table with detailed information about how players performed in a given regular season 5. playerrs.career: table summarizing players' regular season performance across their careers 6. draft: table with information about the NBA draft COACHES SEASON cid order firstname lastname season win season loss playoff win playoff loss tid TEAMS tid location PLAYERS ilkid firstname lastname oson first season last season h feet h inches weight college birthday PLAYER RS ilkid firstname lastname tid stl minutes pts leaguegp ga asts blk turnoverpf gm PLAYER RS CAREER ilkid firstname lastname league gp turnoverp minutes ts asts blk ga fta ftm im DRAFT year draft round sclection tid firstname lastname ilkid draft from league