w3resource
SQL exercises

SQL exercises on movie Database: Find the name of all reviewers who have rated their ratings with a NULL value

SQL movie Database: Join Exercise-1 with Solution

1. Write a query in SQL to find the name of all reviewers who have rated their ratings with a NULL value.

Sample table: reviewer


Sample table: rating


Sample Solution:

SELECT rev_name
FROM reviewer
INNER JOIN rating USING(rev_id)
WHERE rev_stars IS NULL;

Sample Output:

            rev_name
--------------------------------
 Neal Wruck
 Scott LeBrun
(2 rows)

Practice Online


Movie database model

Query Visualization:

Duration:

Query visualization of Find the name of all reviewers who have rated their ratings with a NULL value - Duration

Rows:

Query visualization of Find the name of all reviewers who have rated their ratings with a NULL value - Rows

Cost:

Query visualization of Find the name of all reviewers who have rated their ratings with a NULL value - Cost

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

Previous: SQL JOINS Exercises on movie Database
Next: Write a query in SQL to list the first and last names of all the actors who were cast in the movie 'Annie Hall', and the roles they played in that production.

What is the difficulty level of this exercise?