You cannot select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

7 lines
229 B
SQL

/*29. Write a query in SQL to find the names of all reviewers who have ratings with a NULL value.*/
SELECT DISTINCT rev_name
FROM reviewer
WHERE rev_id IN (
SELECT rev_id
FROM rating
WHERE rev_stars IS NULL);