Consider the following ER Diagram modelling Movies, Directors, Actors, and Roles Table Directors Director_ID PK # # D_F_Name T I D_L_Name T D_Rank # PK # # T Table Movies Movie_ID Title Year Director ID Category Review M_Rank FK # T Memo Table Actors Actor_ID PK # F_Name T L_Name T A_Rank # Table Roles Role_ID Character Comment R Rank *Actor_ID Movie_ID PK # T Memo # FK FK # You are preparing some SQL queries against this database. Specifically, you want a list of movie titles and the first and last name of the movie director where the movie has been ranked at 9 or better and the director ranked as 7 or better. You are going to draft your SQL by hand to put into Access later. A. SELECT Title. D_F_Name. D_L_Name, D_Rank, M_Rank FROM Movies, Directors O WHERE M_Rank >=9 AND D_Rank >=7 B. SELECT Movies. Titie, Directors.D_F_Name, Directors.D_L_Name FROM Movies, Directors WHERE Movies. M_Rank >=9 AND Directors.D_Rank >=7 C. SELECT Movies. Title Directors.D_F_Name, Directors.D_L_Name, Movies. M_Rank, Directors.D_Rank FROM Movies, Directors WHERE Movies. M_Rank >= AND Directors.D_Rank >=7 D. SELECT Movies. Title, Directors.D_F_Name, Directors.D_L_Name FROM Movies WHERE Movies.M_Rank >=9 AND Directors.D_Rank>=7