Write Queries In Sql 1 (22.43 KiB) Viewed 21 times
Write Queries In Sql 2 (19.37 KiB) Viewed 21 times
PART I- Consider the following relational database schema: Movie(title, year, length, inColor, studioName, producerC) Stars In (movie Title, movie Year, starName) address, gender, birthdate) address, cert#, netWorth) MovieStar(name, MovieExec(name, Studio(name, address, cert#, netWorth)
9- (10 points) Find sum of the movies length each studio is produced. 10- (10 points) Create a list of each producer name and the total length of film produced. 11- (10 points) Query the total film length for only those producers who made at least one film prior to 1930.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!