Consider the following database:
MOVIE(id,title,yr) ACTOR(id,name) CASTING(movieid,actorid) Identify the SQL command which will return the titles of all 1959 Marilyn Monroe films.
Option 1. The following SQL...SELECT title FROM movie,casting,actorWHERE movieid = movie.id<> AND name = 'Marilyn Monroe' ;Option 2. The following SQL...SELECT title FROM movie,actorWHERE name = 'Marilyn Monroe'AND yr = 1959 ;
Option 3. The following SQL...SELECT title FROM movie,casting,actorWHERE movieid = movie.idAND actor.id = actoridAND name = 'Marilyn Monroe'AND yr = 1959 ;
Option 4. The following SQL...SELECT title FROM movie,casting,actorWHERE movieid = movie.idAND actor.id = actoridAND movie.yr = casting.yrAND name = 'Marilyn Monroe'AND yr = 1959 ;Select one:
a. Option 1
b. Option 2
c. Option 3 d. Option 4