can anyone please tell me hwt i am getting wrong.

W-- 5. List the details of the movies that have been directed by Anthony Minghella and in which Nicole Kidman has had a role. Sequence by movie title. GSELECT DISTINCT movie.* FROM movie INNER JOIN [role] ON movie. munumb =[ role ].munumb INNER JOIN director ON movie.dirnumb=director. dirnumb InNER JOIN actor ON [ role] ]. actnumb = actor. actnumb WHERE director. dirname = 'Anthony Mighella' AND actor.actname = 'Nicole Kidman' GROUP BY mvtitle; Messages Hag 0120, LeveI 16, State 1, Line 32 Coluen 'novio-munuab' is invalid in the gelect list becauge it in not contaiped in either an eggregete function of the cacob BY clatine. 7. List the movie types that have had between 2 and 6 movies made between 1995 and 2010 SELECT = FROM movie WHERE yearmade BETWEEN 1995 AND 2010 GROUP BY mvtype HAVING CHin1(*) BETWEEN 2 AND 6 Messages Keg a120, Lave1 16, State 1, Ltine 40 Completien tinut 20230304720:45+03,770371705:00