Consider the following Schemas- Movies (title, year, length, genre, studioName, producerCert) starsIn (movieTitle, movieYear, starName, salary)…
Consider the following Schemas-
Movies (title, year, length, genre, studioName, producerCert)
starsIn (movieTitle, movieYear, starName, salary)
MovieStar (name, address, gender, birthdate)
MovieExec (name, address, producerCert, netWorth)
Studio (name, address)Write SQL queries for the following:
(a) Find the address of a studio named MGM
(b) Find the number of movies that was not produced by "MGM"
(c) Which stars appeared in movies produced by MGM in 2019?
From the BPSC Sub-Assistant Maintenance Engineer December 2021 – Written exam, question 8 of 8.