﻿ SQL exercises on movie Database: Find the reviewer name, movie title, and stars for those movies which reviewed by a reviewer and must be rated - w3resource

# SQL exercises on movie Database: Find the reviewer name, movie title, and stars for those movies which reviewed by a reviewer and must be rated

## SQL movie Database: Subquery Exercise-9 with Solution

9. Write a query in SQL to return the reviewer name, movie title, and stars for those movies which reviewed by a reviewer and must be rated. Sort the result by reviewer name, movie title, and number of stars.

Sample table : reviewer

Sample table : rating

Sample table : movie

Sample Solution:

``````SELECT rev_name, mov_title, rev_stars
FROM reviewer, rating, movie
WHERE reviewer.rev_id=rating.rev_id
AND movie.mov_id=rating.mov_id
AND reviewer.rev_name IS NOT NULL
AND rating.rev_stars IS NOT NULL
ORDER BY rev_name, mov_title, rev_stars;
``````

Sample Output:

```            rev_name            |                     mov_title                      | rev_stars
--------------------------------+----------------------------------------------------+-----------
Brandt Sponseller              | Aliens                                             |      8.40
Flagrant Baronessa             | Lawrence of Arabia                                 |      8.30
Hannah Steele                  | Donnie Darko                                       |      8.10
Jack Malvern                   | The Innocents                                      |      7.90
Josh Cates                     | Good Will Hunting                                  |      4.00
Krug Stillo                    | Braveheart                                         |      7.70
Mike Salvati                   | Annie Hall                                         |      8.10
Paul Monks                     | Boogie Nights                                      |      3.00
Richard Adams                  | Beyond the Sea                                     |      6.70
Righty Sock                    | Titanic                                            |      7.70
Righty Sock                    | Vertigo                                            |      8.40
Sasha Goldshtein               | American Beauty                                    |      7.00
Simon Wright                   | The Usual Suspects                                 |      8.60
Victor Woeltjen                | Avatar                                             |      7.30
Vincent Cadena                 | Slumdog Millionaire                                |      8.00
(15 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