Computers and Technology
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 1b. Option 2c. Option 3 d. Option 4