Write a SQL Query to find the name of all reviewers who have rated their ratings with a NULL value.
Output Schema:
reviewer_name
NOTE: Output column name has to match the given output schema.
Example Output:
reviewer_name
MaxPlank
NeilsBohr
Schrodinger
Schema Design:

Solutions:
SELECT reviewer_name
FROM reviewers
INNER JOIN ratings on reviewers.reviewer_id=ratings.reviewer_id
WHERE reviewer_stars IS NULL;
select movie_title,
ReplyDeletemovie_year,
concat (director_first_name, director_last_name)director_name,
concat(actor_first_name, actor_last_name)actors_name,
role
from directors d
right join movies_directors md
on d.director_id=md.director_id
right join movies m
on m.movie_id=md.movie_id
right join movies_cast mc
on mc.movie_id=m.movie_id
right join actors a
on a.actor_id=mc.actor_id
order by m.movie_time asc
limit 1
;