--Homework Assignment 9

--Using the Movie 2 Database write the SQL queries to satisfy the following. Submit this file with your SQL anwsers via D2L

--1a List the DVD No and title for each movie that has at least 4 DVD Copies.

--1b List the DVD No and title for each movie that has at least 4 rented DVD Copies.

--2 List the details for the Comedy DVD Movies whose number of awards is the highest for a Comedy

--3 List the details of all members who are renting a Horror or a Comedy movie --(Use a nested approach)

--4 Repeat query 3 above but use a join. Only show each member's details once

--5. List the movie title and year of release of the movie that is a direct prequel to 'Water World 2' --Use a nested approach

--6 Repeat query 5 above but use a join. --7. List the title and category of the movies that are sequels to movies with a "2" anywhere in the title

--8 List the details for all actors that have a lead role in a movie. Only show an actor's details once

--9 List the movie details for movies whose direct sequels have more than 1 actor appearing in them

--10 List the actor details for any actor that has never appeared in a Comedy movie.