SQL exercises on movie Database: Find the name of all reviewers who have rated 7 or more stars to their rating

Last update on May 30 2022 07:11:59 (UTC/GMT +8 hours)

SQL movie Database: Basic Exercise-6 with Solution

6. From the following tables, write a SQL query to find all reviewers who have rated 7 or more stars to their rating. Return reviewer name.

Sample table: reviewer

Sample table: rating

Sample Solution:

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;

Sample Output:

            rev_name
--------------------------------
Righty Sock
Jack Malvern
Flagrant Baronessa
Victor Woeltjen
Simon Wright
Mike Salvati
Sasha Goldshtein
Righty Sock
Krug Stillo
Hannah Steele
Vincent Cadena
Brandt Sponseller

Relational Algebra Expression:

Relational Algebra Tree:

Practice Online

Query Visualization:

Duration:

Rows:

Cost:

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: From the following tables, write a SQL query to find the name of all reviewers and movies together in a single list.
Next: From the following tables, write a SQL query to find the movies without any rating. Return movie title.

SQL: Tips of the Day

SQL Server SELECT into existing table.

INSERT INTO dbo.TABLETWO SELECT col1, col2 FROM dbo.TABLEONE WHERE col3 LIKE @search_key

This assumes there's only two columns in dbo.TABLETWO - you need to specify the columns otherwise:

INSERT INTO dbo.TABLETWO (col1, col2) SELECT col1, col2 FROM dbo.TABLEONE WHERE col3 LIKE @search_key

Database: SQL Server

Ref: https://bit.ly/3y6tpA3