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

(Solved) : Write Sql Queries Database Contains Following Six Tables Allowed Reference Tables Sql Quer Q35619093

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

7e993627c1105afa75db59d122aadaea.png
Not allowed to reference any other tables in your SQLqueries.

Schema:
COACHES SEASON cid ear r order firstname lastname season_win season_loss playoff_win playoff_loss tid TEAMS tid location name

Your goal for this project will be to write 5SELECT queries to answer the 5 questions below. Note thatyou should use the cid, ilkid, andtid fields to identify coaches, players, andteams, as there may be coaches, players, and teams that share thesame 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 p

We were unable to transcribe this imageCOACHES SEASON cid ear r order firstname lastname season_win season_loss playoff_win playoff_loss tid TEAMS tid location name league PLAYERS ilkid firstname lastname position first season last season h feet h inches weight college birthday PLAYER RS ilkid re PLAYER RS CAREER lastnametid blk league pts oreb firstname stl ear minutes asts turnoverp ga ftm im firstname lastname league blk ilkid minutes pts dreb oreb reb asts turnoverp ga pm DRAFI draft vear 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 season-win / (season-win + seasonב。ss) across all of the seasons they coached. how many players they sent, in decreasing order Show transcribed image text
COACHES SEASON cid ear r order firstname lastname season_win season_loss playoff_win playoff_loss tid TEAMS tid location name league PLAYERS ilkid firstname lastname position first season last season h feet h inches weight college birthday PLAYER RS ilkid re PLAYER RS CAREER lastnametid blk league pts oreb firstname stl ear minutes asts turnoverp ga ftm im firstname lastname league blk ilkid minutes pts dreb oreb reb asts turnoverp ga pm DRAFI draft vear 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 season-win / (season-win + seasonב。ss) across all of the seasons they coached. how many players they sent, in decreasing order

Leave a Reply

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