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

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Universities often rely on a high school students grade point average (GPA) and scores on the SAT or ACT for the college admission decisions. Consider the data for 120 applicants on college admission...

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...

Define the contextual-equivalence relation ` M =ctx M0 : for pairs of PCF terms M, M0 , PCF types , and PCF type environments . [3 marks] (ii) For PCF terms M and N with respective typings ` M : and...

/* bsdump.c * * Reads the boot sector of an MSDOS floppy disk */ #include #include #include #include #define SIZE 32 /* size of the read buffer */ //define PRINT_HEX // un-comment this to print the...

0107451 Laboratory 5: The FAT-12 File System Department of Communications and Computer Engineering Tafila Technical University 1 Submission Turn in your well-formatted and commented source code and a...

please help using SQL plus or SQL developer STOCK \ table [ [ STOCK _ ID , STOCK _ TYPE,STOCK _ MODEL _ , MANUFACTURER ] , [ 1 2 3 4 5 , Desktop,Proline K 1 0 0 , Acer ] , [ 5 4 3 2 1 , Laptop, J 5 5...

STOCK \ table [ [ STOCK _ ID , STOCK _ TYPE,STOCK _ MODEL,MANUFACTURER ] , [ 1 2 3 4 5 , Desktop,Proline K 1 0 0 , Acer ] , [ 5 4 3 2 1 , Laptop,J 5 5 , Mecer ] , [ 7 8 9 4 5 , Server,HP 9 0 0 0 ,...

please help using SQL plus or SQL Developer EMPLOYEE \ table [ [ EmplD , First _ Name,Surname,Contact _ Num,Email,Address ] , [ 1 0 1 , Cameron,Willis, 0 8 4 3 5 6 9 8 5 1 , cw@isat.co . za , 1 1...

Write the queries to answer the following questions. Every column MUST have a column heading. ( 1 mark ) What is the ward name (name_2) and councillor for each Ward in Edmonton? You can use the...

Cross-Reference The rules providing accounting guidance on subsequent events were originally listed in FASB Statement No. 165. Where is this information located in the Codification? List all the...

How will a fraud risk surrounding revenue recognition impact the nature, timing, and extent* of testing accounts receivable? Provide examples of impacts on the audit plan. Which procedures would you...

QUESTION 7 of 2 0 : What does value - based pricing in sports ticketing primarily hinge upon? a ) setting prices solely based on production costs and desired profit margins b ) matching competitors'...

Using company Web sites, develop a profile (types of supply chain software offered, annual sales, and recent news) of the following organizations: a. SAP ( http://www.sap.com ) b. Manhattan...

Ronelda has accumulated $49,248.55 in her RRSP. If she makes no further contributions and her RRSP continues to earn 4.5% compounded monthly, for how long a period of deferral must she wait before...

The block of weight W is given an initial velocity v 1 = 20 ft/sec up the 20 incline at point A. Calculate the velocity v 2 with which the block passes A as it slides back down. U2 V1 = 20 ft/sec W...

In the light box of Fig. 33.6, let event A be the emission of the light flash and event B its return to the source. Assign suitable space and time coordinates to these events in the frame in which...

Use the Lorentz transformations to show that if two events are separated in space and time so that a light signal leaving one event cannot reach the other, then there is an observer for whom the two...

MA.3.2. What does where to compete refer to in the context of market attractiveness? Group of answer choices The specific strategies a company uses to gain a competitive advantage. The local...

Consider the geometry-software diagram at right. You have seen that in a unit circle, the length AB has the same value as cos Î¸. The lengths AF, GI, AD, AI, and CF correspond to other...

When a beam of light passes through a polarized lens, its intensity is cut in half, or I1 = 0.5I0. To further reduce the intensity, you can place another polarized lens in front of it. The intensity...

For each partial sum equation, identify the first term, the ratio, and the number of terms. a. b. c. d. - 40 + 40(2.5)6 = 9725.625 1.0.48 19.9869 1-0.4 -0.4 75(1-1215) wS402.633 40-0.46117 1-0.8 , "...

1. In coaching the applicant to request a higher salary, did the project manager work against the interests of the client organization by which he or she is employed? Why or why not? 2. Could the...

Some employers chose to disclose their reasoning to applicants rejected for poor credit. Says one hiring manager, If a credit check comes back poor, the potential employee has a week to dispute and...

1. One researcher argues that pack behavior comes about because it has benefits. What is the upside of such behavior? 2. Shiller argues that herd behavior can go both ways: It explains the housing...