下列语句为查询给导演” 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
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
- 若要查询评论了所有电影的评论者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
- 下列语句为列出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
- 要找出所有名字第二个字母为“a”的导演的电影信息，SQL语句为 A: SELECT * FROM Movie WHERE director LIKE ‘_a_’; B: SELECT * FROM Movie WHERE director LIKE ‘%a%’; C: SELECT * FROM Movie WHERE director LIKE ‘%a_’; D: SELECT * FROM Movie WHERE director LIKE ‘_a%’;