Question: Use a correlated subquery in each problem. Use the following EER diagram as a reference: director id INT dir_firstName VARCHAR(30) +1- dir_lastName VARCHAR(30) Indexes

Use a correlated subquery in each problem. Use the following EER diagram as a reference: director id INT Show the most recently released movie for each director. Include only movies released in the XXI century.

Use a correlated subquery in each problem. Use the following EER diagram as a reference: director id INT dir_firstName VARCHAR(30) +1- dir_lastName VARCHAR(30) Indexes movie id INT mov_title VARCHAR (35) mov_year INT mov_time INT mov_lang VARCHAR (15) mov_dt_rel DATE mov_rel_country VARCHAR(5) gen_id INT dir_id INT Indexes genre id INT gen_title VARCHAR(10) Indexes H rating rev_id INT mov_id INT rev_rating DECIM Indexes PRIMARY fk_mov_rating reviewer id INT rev_name VARCH Indexes Show the most recently released movie for each director. Include only movies released in the XXI century. Order by year descending and movie title ascending. Display movie title and release year (Use the same column names displayed in the image below). Movie Movie Avatar Aliens The Hurt Locker Back to the Future Trainspotting Selma Avatar Slumdog Millionaire The Hurt Locker The Prestige Beyond the Sea American Splendor Donnie Darko Spirited Away Show movies below the average duration for each director. Show only movies in English language. Order by duration descending. Display movie title, duration, language, and genre (Use the same column names displayed in the image below). Released 2014 2009 2008 2008 2006 2004 2003 2001 2001 Duration 162 137 131 116 94 Language Released Genre English 2009 English 1986 English 2008 English 1985 English 1996 Adventure Action Thriller Mystery Drama

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

I see that youve shared images containing an Enhanced EntityRelationship EER diagram of a movie database as well as directions for SQL queries youd li... View full answer

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!

Shaw Company has the following account balances: Receivables $ 1 0 0 , 0 0 0 Inventory 1 5 0 , 0 0 0 Land 1 0 0 , 0 0 0 Building net 2 5 0 , 0 0 0 Liabilities 1 0 0 , 0 0 0 Common stock 1 0 0 , 0 0 0...

The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...

The following transactions for Kramer Corporation occurred during December of the current year. Follow the step-by-step instructions to enter the transactions, process the adjusting entries, and...

These are queries that use the full Red Cat Database as shown in Figure 3.1. To do these queries you cannot use the SimplifiedSales database. You must use the full Red Cat tables of Customer, Sale,...

SQL I5 3351003 - 2022 Sumr 5.35 Correlated subqueries 3 These are queries That use the full Red Cat Database as shown in Figure 3.1. To do these queries you cannot use The SimpliedSales database. You...

CS246 Lab 3: Joins and Sub-queries Objectives The objectives of Lab 3 are to: . Create and execute queries involving CROSS, NATURAL, INNER, OUTER, and SELF joins Create and execute queries involving...

I need these 6 queries completed . Thank you. /* Query 1 . Write a SELECT statement that returns the same result set as the SELECT statement below, but dont use a join. Instead, use a subquery in a...

The Customer _ Order table, which stores data about customer orders, contains the folowing data: Customer _ Order Prompt 2 Questions ( There are 8 questions for Prompt 2 ) . Write a query to retrieve...

1. What is the total value of products purchased by customer 144? Name the column TotalValue. (Hint: use joins) 2. Give a list of Manufacturer names and IDs for manufacturers which only provide...

Need some Oracle SQL assistance, please, Write a select statement that returns the same result set as the following SELECT statement but doesnt use a JOIN. Instead, use a SUBQUERY in a where clause...

Tempe Inc. is considering four mutually exclusive public projects. The capital investment requirements, annual operating & maintenance (O&M) costs, and salvage values of these projects are given...

Answer the following questions. a. Office Supplies has assets equal to $137,000 and liabilities equal to $110,000 at year-end. What is the total equity for Office Supplies at year-end? b. At the...

For a reporting entity that has participated in related party transactions that are material, disclosure in the GAAP-based financial statements should include A. The nature of the relationship and...

According to the National Funeral Directors Association (NFDA), the nation's 19,000 funeral homes collected an average of $7,180 per full-service funeral in 2014 (www.nfda.org). A random sample of 36...

In 2011, Heart Corporation had year-end assets of $1,200,000, sales of $1,650,000,net income of $140,000, net cash flows from operating activities of $195,000, dividends of $60,000, purchases of...

Refer to the data provided in Exercise 10-9. In Exercise 10-9 Mahn Corporation produces high-quality leather belts. The company uses a standard cost system and has set the following standards for...

Your firm successfully issued new debt last year, but the debt carries covenants. Specifically, you can only pay dividends out of earnings made after the debt issue and you must maintain a minimum...

Apollo Company manufactures a single product that sells for $168 per unit and whose total variable costs are $126 per unit. The companys annual fixed costs are $630,000. (1) Use this information to...

why is 1/x defines in interval [1,3] but not in [-1,1]

Great Lakes Insurance would like to implement a relational database for both its in-house and outside agents. The outside agents will use notebook computers to keep track of customers and policy...

Within which clauses of an SQL statement can a derived table be defined?

Explain what can be done with primary keys to eliminate key ripple effects as a database evolves.

Show two of the three forces acting on an object in equilibrium. Redraw the diagram, showing all three forces. Label the third force 1. Figure Ex 5.17 2. Figure Ex 5.18 3. Figure Ex 5.18

Explain how the data in Figures 36.2 through 36.5 (increasing real spending per pupil, decreasing class sizes, decreasing SATs, and increasing graduation rates) can be occurring at the same time?

A single force with x-component F x acts on a 2.0 kg object as it moves along the x-axis. A graph of F x versus t is shown in FIGURE P5.31. Draw an acceleration graph (ax versus t) for this object....