CREATE TABLE Rating (rID VARCHAR2, stars VARCHAR2)

find the ids of reviewers who did not give 4 star.
SELECT rID FROM Rating EXCEPT SELECT rID FROM Rating WHERE stars = 4
SELECT "rID" FROM "Rating" EXCEPT SELECT "rID" FROM "Rating" WHERE "stars" = 4