Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please Write the answer for below queries using ERD table. --1. List the details for those movies that are made between 1999 and 2023 --
Please Write the answer for below queries using ERD table.
--1. 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 actor movie mvnumb: INTEGER NOT NULL director mvtitle: CHAR (30) NOT NULL dimumb: INTEGER NOT NULL yeamade: INTEGER NOT NULL dimame: CHAR(20) NOT NULL yearbom: INTEGER NOT NULL mvtype: CHAR(10) NOT NULL yeardied:INTEGER NULL noms: INTEGER NOT NULL awrds: INTEGER NOT NULL dimumb: INTEGER NOT NULL (FK)Step 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