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
SELECT rev_name FROM reviewer INNER JOIN rating USING(rev_id) WHERE rev_stars IS NULL;
rev_name -------------------------------- Neal Wruck Scott LeBrun (2 rows)
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?