Using the NBA schema that you have already created answer the questions that fol

Question

Using the NBA schema that you have already created answer the questions that follow: team team ID tname rank INTEGER VARCHAR(15) INTEGER VARCHAR(20) championships INTEGER team player_arena player player ID pname position draft year INTEGER retire year INTEGER education VARCHAR(30) team ID INTEGER player ID INTEGER arena ID INTEGER points INTEGER INTEGER VARCHAR(30) VARCHAR(20) arena arena ID INTEGER aname VARCHAR(20) city VARCHAR(20) The team table has a team id primary kev The player table has a player id primary key . The arena table has an arena id primary kev I he team play arena table has a (team id, pl layer id, arena id) composite primar v The teamplay arena table has a team id foreign key column that references the team table The team play arena table has a player id foreign key column that references the player table The teamplav arena table has a arena id foreign key column that references the arena table Write and run the following queries. Do not show duplicates (50 points) 5. Print the names of the teams that played in all arenas

Explanation / Answer

5. answer:

select t.tname from team t inner join team_player_arena a
on t.team_id=a.team_id
inner join arena e
on a.arena_id=e.arena_id;

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.