Question: Problem Set . Given the following database that stores Hollywood movie information Movies (title, year, length, genre, studioName, ProducerName) StarsIn (movieTitle,starName, pay) MovieStar (name, address,

Problem Set . Given the following database that stores Hollywood movie information Movies (title, year, length, genre, studioName, ProducerName) StarsIn (movieTitle,starName, pay) MovieStar (name, address, gender, birthdate) MovieExecutive name, address, certificate_num, networth) where the underlined attributes are the primary keys. The following foreign keys also exist: Starsln.starName-MovieStar.name Starsln.movieTitle Movies.title Movies.ProducerName->MovieExecutive.name Write the following queries in SQL 3. Print the names of actors who starred in both an MGM (studio name) movie and a Universal (studio name) movie; 4. What is the average length of movies produced by Kevin Costner
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
