The Online Movies DataBase (OMDB) is as follows:
MovieInfo (mvID, title, rating, year, length, studio)
Director(directorID, firstname, lastname)
Member(username, email, password)
Actor(actorID, firstname, lastname, gender, birthplace)
Cast(mvID*, actorID*)
Direct(mvID*, directorID*)
Genre(mvID*, genre)
Ranking(username*, mvID*, score, voteDate)
a) Find the movies whose studio information is not available or whose genre
information is not available. List the movid and title of these movies. You must
use the NOT EXISTS operator. You must not use any SET operator (e.g. UNION,
MINUS)
Select mvID, title from MovieInfo WHERE NOT EXISTS( SELECT * FROM GENRE
WHERE GENRE.mvID = MoiveInfo.mvID) OR MovieInfo.studio is Null;