You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
|
/*33. Write a query in SQL to find the names of all reviewers who rated the movie American Beauty. */
|
|
SELECT DISTINCT reviewer.rev_name
|
|
FROM reviewer, rating, movie
|
|
WHERE reviewer.rev_id = rating.rev_id
|
|
AND movie.mov_id = rating.mov_id
|
|
AND movie.mov_title = 'American Beauty'; |