Question: POSSIBLE HELPER BELOW: - MAY OR MAY NOT NEED B) Write and run the following queries (50 points) 1. Print the player_ids and names of

 POSSIBLE HELPER BELOW: - MAY OR MAY NOT NEED B) Write

POSSIBLE HELPER BELOW: - MAY OR MAY NOT NEED

and run the following queries (50 points) 1. Print the player_ids and

names of players of Point guards drafted after the year 2000 2.

Print the name and city of arenas that hosted a team from

LA. Do this query in two ways (i) as a flat select

B) Write and run the following queries (50 points) 1. Print the player_ids and names of players of Point guards drafted after the year 2000 2. Print the name and city of arenas that hosted a team from LA. Do this query in two ways (i) as a flat select (ii) completely nested, i.e., using sub queries so as to avoid all JOIN clauses Print the names of arenas that hosted a team from Charlotte and hosted a Shooting guard 3. 4. Print the names of players who have the letters 'on' in their name 5. Print the names of arenas that hosted a team from Charlotte but did not host a Shooting guard 6. Print the player_id and average points scored of players who scored an average of points that is greater than the average of points scored in arena 1 7. Print the arena name & city of arenas that did not host the Bulls team 8. Print the names of all retired players 9. Print the names of arena cities that hosted a player whose name begins with a T

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!