Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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 TStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started