Question
3. Create a new view that shows the same information as #1 EXCEPT it should show the average rating of each movie. Use the
3. Create a new view that shows the same information as #1 EXCEPT it should show the average rating of each movie. Use the view from #1 in the FROM clause. Name the average rating column AvgRating. - 901 Vertigo 902 The Innocents 903 Lawrence of Arabia 904 The Deer Hunter 905 Amadeus 906 Blade Runner 907 Eyes Wide Shut 908 The Usual Suspects 909 Chinatown 910 Boogie Nights 911 Annie Hall Director First Name Alfred Jack David Michael Milos Ridley Stanley Bryan Roman Paul Woody 912 Princess Mononoke Hayao 913 The Shawshank... Frank 914 American Beauty Sam Director Last Name Hitchcock Clayton Lean Cimino Forman Scott Kubrick Singer Polanski Thomas Anderson Allen Miyazaki Darabont Mendes genve AgRating Mystery 1958 7.21250 1961 7.12500 Horror Adventure 1962 7.87273 1978 7.08333 1984 6.85000 1982 6.87273 1999 7.00000 1995 7.05455 War Drama Thriller Mystery Crime Mystery 1974 6.22727 Drama 1997 6.76667 Comedy 1977 6.63333 Animation 1997 6.59167 Crime 1994 6.50909 Romance 1999 7.11429
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started