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.
10 lines
393 B
SQL
10 lines
393 B
SQL
/*35. Write a query in SQL to return the reviewer name, movie title, and number of stars for those movies which rating is
|
|
the lowest one. */
|
|
SELECT reviewer.rev_name, movie.mov_title, rating.rev_stars
|
|
FROM reviewer, movie, rating
|
|
WHERE rating.rev_stars = (
|
|
SELECT MIN(rating.rev_stars)
|
|
FROM rating
|
|
)
|
|
AND rating.rev_id = reviewer.rev_id
|
|
AND rating.mov_id = movie.mov_id; |