-1) A view called V_DVDMovieSTATS that will show the category, maximum, minimum, average and a count of...
Question:
-1) A view called V_DVDMovieSTATS that will show the category, maximum, minimum, average and a count of DVDMovies awards --for each movie category --2) A view called V_CastingSTATS which will have for each actor by actor name, id, the total number of nominations, awards, a count -- of the movies that they have appeared in and those movie received --3) A view called V_ActorSTATS that will show a count of lead actor roles -- for each actor, by actor actor name and id. --Then using these views write the following queries --4) List the details for the actor that has had the highest number of lead roles sorted by actor name descending --5) List the actor details for the actor whose movies combined have the lowest overall number of awards --6) List the movie details for any movie that has below the average number of awards for movies in its category --7) List the details of any member renting a movie in the category with the highest number of movies. Show each member details only once in descending member name order.
Discovering Advanced Algebra An Investigative Approach
ISBN: 978-1559539845
1st edition
Authors: Jerald Murdock, Ellen Kamischke, Eric Kamischke