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

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

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 10SELECT queries to answer the 10 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.
1. Find all coaches who have coached exactly one team. List their first names, last names, and cids 2. Find all players who 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 1. Find all coaches who have coached exactly one team. List their first names, last names, and cids 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 4. 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. 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
1. Find all coaches who have coached exactly one team. List their first names, last names, and cids 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 4. 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.

Leave a Reply

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