Question: Put your SQL statement under the following lines: 2. Find all the players who played in a Boston team and a Denver team (this does

Put your SQL statement under the following lines:

2. Find all the players who played in a Boston team and a Denver team (this does not have to happen in the same season). List their first names only. 3. Find those who happened to be a coach and a player in the same team in the same season. List their first names, last names, the team where this happened, and the year(s) when this happened.

schema

create table teams (tid varchar(30), location varchar(30), name varchar(30),league varchar(30), primary key (tid, league)); create table coaches_season (cid varchar(30), year int, yr_order int,firstname varchar(30), lastname varchar(30), season_win int, season_loss int,playoff_win int, playoff_loss int, tid varchar(30), primary key (cid, year,yr_order)); create table draft (draft_year int, draft_round int, selection int, tidvarchar(30), firstname varchar(30), lastname varchar(30), ilkid varchar(30),draft_from varchar(100), league varchar(30)); create table players (ilkid varchar(30), firstname varchar(30), lastnamevarchar(30), position varchar(1), first_season int, last_season int, h_feet int,h_inches real, weight real, college varchar(100), birthday varchar(30), primarykey (ilkid)); create table player_rs_career (ilkid varchar(30), firstname varchar(30),lastname varchar(30), league varchar(10), gp int, minutes int, pts int, drebint, oreb int, reb int, asts int, stl int, blk int, turnover int, pf int, fgaint, fgm int, fta int, ftm int, tpa int, tpm int); create table player_rs (ilkid varchar(30), year int, firstname varchar(30),lastname varchar(30), tid varchar(30), league varchar(10), gp int, minutes int,pts int, dreb int, oreb int, reb int, asts int, stl int, blk int, turnover int,pf int, fga int, fgm int, fta int, ftm int, tpa int, tpm int, primary key(ilkid,year, tid));

coaches_season, each tuple of which describes the performance of one coach in one season;

teams, each tuple of which gives the basic information of a team;

players, each tuple of which gives the basic information of one player;

player_rs, each tuple of which gives the detailed performance of one player in one regular season;

player_rs_career, each tuple of which gives the detailed regular-season performance of one player in his career;

draft, each tuple of which shows the information of an NBA draft.

Answer in psql please thanks

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!