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’);