From the following tables, write a SQL query to find those reviewers who rated more than one movie. Group the result set on reviewer’s name, movie title. Return reviewer’s name, movie title
- برمجة سي كيو ال sql
- 2021-09-03
- mhanasmh00489829403
الأجوبة
SELECT rev_name, mov_title
FROM reviewer, movie, rating, rating r2
WHERE rating.mov_id=movie.mov_id
AND reviewer.rev_id=rating.rev_ID
AND rating.rev_id = r2.rev_id
GROUP BY rev_name, mov_title HAVING count(*) > 1;
Sample Output:
rev_name | mov_title --------------------------------+---------------------------------------------------- Righty Sock | Titanic Righty Sock | Vertigo (2 rows)
أسئلة مشابهة
القوائم الدراسية التي ينتمي لها السؤال