Show me the name of all the reviewers.
select name from reviewer
What about the rating star they had given?
select t2.name, t1.stars from rating as t1 join reviewer as t2 on t1.rid = t2.rid
Show me the 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