Answered step by step
Verified Expert Solution
Link Copied!

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. image text in transcribedimage text in transcribed

--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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Visual C# And Databases

Authors: Philip Conrod, Lou Tylee

16th Edition

1951077083, 978-1951077082

More Books

Students also viewed these Databases questions

Question

What is meant by Career Planning and development ?

Answered: 1 week ago

Question

What are Fringe Benefits ? List out some.

Answered: 1 week ago

Question

Describe Table Structures in RDMSs.

Answered: 1 week ago