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

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

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
You are not allowed to reference any other tables in theSQL queries.
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.

I. Find all oaches who have coachel exnly on t ist their firslast ns, and cids 2. Find all players who played on a Boston tea

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 I. Find all oaches who have coachel exnly on t ist their firslast ns, 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 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
I. Find all oaches who have coachel exnly on t ist their firslast ns, 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 *