From the following tables, write a SQL query to find the movies, which have reviewed by any reviewer body except by 'Paul Monks'
- برمجة سي كيو ال sql
- 2021-09-03
- mhanasmh00489829403
الأجوبة
SELECT movie.mov_title
FROM movie
WHERE movie.mov_id IN(
SELECT mov_id
FROM rating
WHERE rev_id NOT IN (
SELECT rev_id
FROM reviewer
WHERE rev_name='Paul Monks'));Sample Output:
mov_title ---------------------------------------------------- Avatar Lawrence of Arabia Donnie Darko Aliens Vertigo The Innocents Slumdog Millionaire Annie Hall Good Will Hunting American Beauty Titanic Beyond the Sea Trainspotting Princess Mononoke The Usual Suspects Blade Runner Braveheart Chinatown (18 rows)
أسئلة مشابهة
القوائم الدراسية التي ينتمي لها السؤال