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.
|
/*6. Write a query in SQL to find the name of all reviewers who have rated 7 or more stars to their rating. */
|
|
SELECT reviewer.rev_name
|
|
FROM reviewer, rating
|
|
WHERE rating.rev_id = reviewer.rev_id
|
|
AND rating.rev_stars>=7
|
|
AND reviewer.rev_name IS NOT NULL; |