Solution without a join


#1

select reviewer_name from reviewers ,ratings where (ratings.reviewer_id=reviewers.reviewer_id and ratings.reviewer_stars is NULL)


#2

Essentially that’s a kind of JOIN, even though if this is not written in a query.


#3

yeah, it is implicit join


#4

select distinct reviewer_name as reviewer_name from reviewers where reviewer_id in(Select reviewer_id from ratings where reviewer_stars IS NULL);