下面SQL语句中不正确的一项是
A、select name from reviewer,rating where reviewer.rid=rating.rid group by reviewer.rid
B、select name from reviewer,rating where reviewer.rid=rating.rid having count(stars)>=3
C、select name from reviewer,rating group by reviewer.rid having count(stars)>=3
D、select name from reviewer,rating group by reviewer.rid where count(stars)>=3