‍下面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

下列语句为列出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

下列语句为查询给导演” 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,Movie‌‌WHERE Movie.mID = Rating.mID‌‌AND 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

It's important for you to ____your bad habits. A: do rid of B: doing rid of C: get rid of D: getting rid of

What is the range for star rating of hotels?

The printer doesn’t work. Don’t you think it’s about time we ______. it A: will get rid of B: get rid of C: have got rid of D: got rid of

What is a fair rating system according to the speaker?