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

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

## SQL movie Database: Basic Exercise-6 with Solution

6. Write a query in SQL to find the name of all reviewers who have rated 7 or more stars to their rating.

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
Brandt Sponseller
Righty Sock
Jack Malvern
Flagrant Baronessa
Victor Woeltjen
Simon Wright
Mike Salvati
Sasha Goldshtein
Righty Sock
Krug Stillo
Hannah Steele
Brandt Sponseller
Righty Sock
Jack Malvern
Flagrant Baronessa
Victor Woeltjen
Simon Wright
Mike Salvati
Sasha Goldshtein
Righty Sock
Krug Stillo
Hannah Steele
Brandt Sponseller
Righty Sock
Jack Malvern
Flagrant Baronessa
Victor Woeltjen
Simon Wright
Mike Salvati
Sasha Goldshtein
Righty Sock
Krug Stillo
Hannah Steele
Brandt Sponseller
Righty Sock
Jack Malvern
Flagrant Baronessa
Victor Woeltjen
Simon Wright
Mike Salvati
Sasha Goldshtein
Righty Sock
Krug Stillo
Hannah Steele
Brandt Sponseller
Righty Sock
Jack Malvern
Flagrant Baronessa
Victor Woeltjen
Simon Wright
Mike Salvati
Sasha Goldshtein
Righty Sock
Krug Stillo
Hannah Steele
Brandt Sponseller
Righty Sock
Jack Malvern
Flagrant Baronessa
Victor Woeltjen
Simon Wright
Mike Salvati
Sasha Goldshtein
Righty Sock
Krug Stillo
Hannah Steele
Brandt Sponseller
(84 rows)
```

## Query Visualization:

Duration:

Rows:

Cost:

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

What is the difficulty level of this exercise?

﻿

New Content: Composer: Dependency manager for PHP, R Programming