ผู้วิจารณ์ที่ให้คะแนน 3 ดาวและ 4 ดาวชื่ออะไร?ไม่จำเป็นต้องใช้ตารางทั้งหมด
What are the names of reviewers who had rated 3 star and 4 star?It is not neccessary to use all the tables.
 Reviewer:  (name [ VARCHAR ] rID [ VARCHAR) ]
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