List the details for those movies that are made between 1999 and 2023 — and their title contains either ‘matrix’,

List the details for those movies that are made between 1999 and 2023 — and their title contains either ‘matrix’,

Question:

 List the details for those movies that are made between 1999 and 2023
— and their title contains either ‘matrix’, or ‘nice’ 
— 2. List the actor number for each actor and the total amount of movie fees
— they have received for all their roles combined.  
— Only show actors where the total fees are less than $600,000 
— 3. List details for the directors that have ever directed ‘Comedy’ type movies.
— Show each director only once and sequence alphabetically by name. 
— 4. List the actor number for the actors that have had at least 2 roles in 2002. 
— 5. List the details of the movies that have been directed by Anthony Minghella
— and in which Nicole Kidman has had a role. Sequence by movie title. 
— 6. Count the number of different actors that have had roles
— in ‘Comedy’ movies made after 1990. 
— 7. List the movie types that have had between 2 and 6 movies made between 1995 and 2010 
— 8. Show the number of roles in 2002 for each actor along with the actor number
— whose total fees in that year exceeded $50,000 

Expert Answer:

Answer rating: 100% (QA)

I ll provide SQL queries for each of your requirements Keep in mind that you ll need access to a database with relevant tables e g Movies Actors Direc
View the full answer