若要查询评论了所有电影的评论者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
A: NOT IN, NOT IN
B: NOT EXISTS, NOT EXISTS
C: NOT IN, NOT EXISTS
D: NOT EXISTS, NOT 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
- 下列语句为查询给导演” 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
- 下面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