8. Assume there is a rating_history table with a column call…

8. Assume there is a rating_history table with a column called rating_type that indicates if a movie’s rating is from a regular review, a critic’s review, or an audience award. What question does this correlated query answer? Begin your answer with “This query answers the question: which movies…” SELECT mov_titleFROM movie mWHERE NOT EXISTS (SELECT rh.mov_title                  FROM rating_history rh                  WHERE rh.mov_id = m.id                  AND rh.rating_type = ‘audience award’);