CREATE TABLE Reviewer (name VARCHAR2, rID VARCHAR2)
CREATE TABLE Rating (rID VARCHAR2, stars VARCHAR2)

What are the names of reviewers who had rated 3 star and 4 star?
SELECT T2.name FROM Rating AS T1 JOIN Reviewer AS T2 ON T1.rID = T2.rID WHERE T1.stars = 3 INTERSECT SELECT T2.name FROM Rating AS T1 JOIN Reviewer AS T2 ON T1.rID = T2.rID WHERE T1.stars = 4
SELECT "T2"."name" FROM "Rating" "T1" JOIN "Reviewer" "T2" ON "T1"."rID" = "T2"."rID" WHERE "T1"."stars" = 3 INTERSECT SELECT "T2"."name" FROM "Rating" "T1" JOIN "Reviewer" "T2" ON "T1"."rID" = "T2"."rID" WHERE "T1"."stars" = 4