From the following tables, write a SQL query to find the highest-rated ‘Mystery Movies’. Return the title, year, and rating
- برمجة سي كيو ال sql
- 2021-09-03
- mhanasmh00489829403
الأجوبة
SELECT mov_title, mov_year, rev_stars
FROM movie
NATURAL JOIN movie_genres
NATURAL JOIN genres
NATURAL JOIN rating
WHERE gen_title = 'Mystery' AND rev_stars >= ALL (
SELECT rev_stars
FROM rating
NATURAL JOIN movie_genres
NATURAL JOIN genres
WHERE gen_title = 'Mystery');
Sample Output:
mov_title | mov_year | rev_stars ----------------------------------------------------+----------+----------- Vertigo | 1958 | 8.40 (1 row)
أسئلة مشابهة
القوائم الدراسية التي ينتمي لها السؤال