下面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
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
举一反三
- 下列语句为查询给导演” Spielberg”执导电影评过分的reviewer信息，下列空白处应该填写（ ）SELECT * from Reviewer where rID ____ (SELECT rID from Rating,MovieWHERE Movie.mID = Rating.mIDAND Movie.director = “Spielberg” ) A: EXISTS B: NOT EXISTS C: ANY D: IN
- 下列语句为查询给导演” Spielberg”执导电影评过分的reviewer信息，下列空白处应该填写——SELECT * from Reviewer where rID ____ (SELECT rID from Rating,MovieWHERE Movie.mID = Rating.mIDAND Movie.director = “Spielberg” ) A: EXISTS B: NOT EXISTS C: ANY D: IN
- 下列语句为列出rID为’00001’和rID为’00002’的reviewer所评分过的不同电影ID，空白处应该填写——SELECT mID FROM Rating WHERE rID = ‘00001’____SELECT mID FROM Rating WHERE rID = ‘00002’ A: EXCEPT B: UNION C: INTERSECT D: DIVID
- 下列语句为列出rID为’00001’和rID为’00002’的reviewer所评分过的不同电影ID，空白处应该填写（ ）SELECT mID FROM Rating WHERE rID = ‘00001’____SELECT mID FROM Rating WHERE rID = ‘00002’ A: EXCEPT B: UNION C: INTERSECT D: DIVID
- 若要查询评论了所有电影的评论者name,则下列空白处需要依次填入——。SELECT name FROM Reviewer WHERE rID (SELECT * FROM Movie WHERE mID (SELECT mID FROM RatingWHERE Reviewer.rID=Rating.rID and Movie.mID=Rating.mID)) A: NOT IN, NOT IN B: NOT EXISTS, NOT EXISTS C: NOT IN, NOT EXISTS D: NOT EXISTS, NOT IN