( 4 points ) Consider the following schemas ( exactly as HIV/3 ) . Department ( D- code , D- Name , Chair - 5.5 n) Faculty ( S'sn, F - Name , D-...

please help me this question with explanations. ddd

# 3. ( 4 points ) Consider the following schemas ( exactly as HIV/3 ) .Department ( D- code , D- Name , Chair - 5.5 n)Faculty ( S'sn, F - Name , D- Code, Rank)Course ( D-code , C- no , Title , Units )Student ( Son, S- Name , Major, Status )Prereq ( D- code , C- no , P- code , P- no)Enrollment ( Class - no . Student - Son )Class ( Class - no , D-code, C- no, Instructor - 5.5/2 )Transcript ( Student - Son, D- Code, C-no, Grade)Given the following SQL query ,SELECT C. titleFrom COULEE [Where IS. I Code . C. C NO) not in( SELECT CL . D Code , .C NOFrom Class , Faculty Dwhere . Instructor San = P. Gan andFrank_ ' Associate PROFESSOR! !$Circle the sentence that describes most exactly the above SQL query . Assume cach course musthave at least one offering , called a class , taught by a possibly different professor .. Find the title of every course whose classes are taught by at least one Associate Professor .b . Find the title of every course whose classes are taught only by Associate Professors .. Find the title of every course whose classes are not taught by any Associate Professors .d . Find the title of every course such that every Associate professor teaches a class of it .C . None of the above .