Menu
support@nursinghomework.org
+1 714-215-3097

(Solved) : Write Sql Queries Database Contains Following Six Tables Goal Project Write 10 Select Quer Q35587884

Write some SQL queries. The database contains the following sixtables:

1. coaches_season: table describing the performance of coaches in one season 2. teams: table with basic information about NBA
COACHES SEASON cid order firstname lastname season win season loss playoff win playoff loss tid TEAMS tid location PLAYERS il
Your goal for this project will be to write 10SELECT queries to answer the 10 questions below. Note thatyou should use the cid, ilkid, and tid fields to identify coaches,players, and teams, as there may be coaches, players, and teamsthat share the same name.

6. Find the coaches (first name, last name, and cid) who havecoached in every league.

7. Find everyone who was a coach and player in the same season, butfor different teams. List their first name, last name, the season,and both teams every time this happened. Order the results fromoldest 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 theyscored than Michael.

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

10. Find the 3 schools that sent the most players to the NBAdraft. Print the name of each school and how many players theysent, 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 Show transcribed image text 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

Leave a Reply

Your email address will not be published. Required fields are marked *