WRITE QUERIES IN SQL
Posted: Fri Jul 01, 2022 5:46 am
WRITE QUERIES IN SQL
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.
- Write Queries In Sql 1 (22.43 KiB) Viewed 23 times
- Write Queries In Sql 2 (19.37 KiB) Viewed 23 times
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.