ORA-00936: missing expression for a '='
The "less than or equal" operator is <=, not >=. I.e., in the condition for M.RunTime, you should have M.RunTime <= 90 instead of M.RunTime =< 90.
You have three typos:
OR (M.RatingCode = 'G' AND M.RunTime = < 90 AND M.TMDB_Score > 6.1)The = < should be <=.
and in:
OR M.RatingCode = 'MA' AND M.RunTime BETWEEN >=185 AND M.TMDB_Score > 6.1)You need to remove the BETWEEN.
and:
OR M.RatingCode = 'MA' AND M.RunTime BETWEEN >=185 AND M.TMDB_Score > 6.1)Is missing the opening ( after the OR.