Use a correlated subquery in each problem. Use the following EER diagram as a reference: director...

 

Transcribed Image Text:

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

Answer rating: 100% (QA)

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 the full answer