-
已知影片评论数据库包括如下表结构:Movie ( mID, title, year, director )影片表,属性包括影片编号,影片名,发行年份以及导演,其中mID是主键。Reviewer ( rID, name )评论者表,属性包括评论者编号,评论者姓名,其中rID是主键。Rating ( rID, mID, stars, ratingDate )评论表,属性包括评论者编号,影片编号,评分(1-5),评论日期,其中(rID, mID, ratingDate)是主键。要找出所有名字第二个字母为“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%’
-
要找出对同一部电影评论次数在3次及以上的评论者姓名,下列语句不能实现该功能的是选项: A:select name from reviewer,rating where reviewer.rid=rating.rid group by reviewer.rid having count(stars)>=3; B:select name from reviewer A where (select count(stars) from rating B where A.rid=B.rid group by rid)>=3; C:select name from reviewer where (select count(stars) from rating where reviewer.rid=rating.rid)>=3; D:select name from reviewer,rating where reviewer.rid=rating.rid and count(stars)>=3 group by reviewer.rid
-
要找出对同一部电影评论次数在3次及以上的评论者姓名,下列语句不能实现该功能的是( )选项: A:select name from reviewer,rating where reviewer.rid=rating.rid group by reviewer.rid having count(stars)>=3; B:select name from reviewer A where (select count(stars) from rating B where A.rid=B.rid group by rid)>=3; C:select name from reviewer where (select count(stars) from rating where reviewer.rid=rating.rid)>=3; D: select name from review,rating where reviewer.rid=rating.rid and count(stars)>=3 group by reviewer.rid
-
要找出对同一部电影评论次数在3次及以上的评论者姓名,下列语句不能实现该功能的是——选项: A:select name from reviewer,rating where reviewer.rid=rating.rid group by reviewer.rid having count(stars)>=3; B:select name from reviewer A where (select count(stars) from rating B where A.rid=B.rid group by rid)>=3; C:select name from reviewer where (select count(stars) from rating where reviewer.rid=rating.rid)>=3; D:select name from review,rating where reviewer.rid=rating.rid and count(stars)>=3 group by reviewer.rid
-
要找出对同一部电影评论次数在3次及以上的评论者姓名,下列语句不能实现该功能的是 选项: A、select name from reviewer,rating where reviewer.rid=rating.rid group by reviewer.rid having count(stars)>=3 B、select name from reviewer A where (select count(stars) from rating B where A.rid=B.rid group by rid)>=3 C、select name from reviewer where (select count(stars) from rating where reviewer.rid=rating.rid)>=3 D、select name from reviewer,rating where reviewer.rid=rating.rid and count(stars)>=3 group by reviewer.rid
-
要找出对同一部电影评论次数在3次及以上的评论者姓名,下列语句不能实现该功能的是—— 选项: A、select name from reviewer,rating where reviewer.rid=rating.rid group by reviewer.rid having count(stars)>=3 B、select name from reviewer A where (select count(stars) from rating B where A.rid=B.rid group by rid)>=3 C、select name from reviewer where (select count(stars) from rating where reviewer.rid=rating.rid)>=3 D、select name from review,rating where reviewer.rid=rating.rid and count(stars)>=3 group by reviewer.rid
-
要找出对同一部电影评论次数在3次及以上的评论者姓名,下列语句不能实现该功能的是—— 选项: A、select name from reviewer,rating where reviewer.rid=rating.rid group by reviewer.rid having count(stars)>=3 B、select name from reviewer A where (select count(stars) from rating B where A.rid=B.rid group by rid)>=3 C、select name from reviewer where (select count(stars) from rating where reviewer.rid=rating.rid)>=3 D、select name from review,rating where reviewer.rid=rating.rid and count(stars)>=3 group by reviewer.rid
-
要找出对同一部电影评论次数在3次及以上的评论者姓名,下列语句不能实现该功能的是
A: select name from reviewer,rating where reviewer.rid=rating.rid group by reviewer.rid having count(stars)>=3
B: select name from reviewer A where (select count(stars) from rating B where A.rid=B.rid group by rid)>=3
C: select name from reviewer where (select count(stars) from rating where reviewer.rid=rating.rid)>=3
D: select name from reviewer,rating where reviewer.rid=rating.rid and count(stars)>=3 group by reviewer.rid
-
要找出对同一部电影评论次数在3次及以上的评论者姓名,下列语句不能实现该功能的是——
A: select name from reviewer,rating where reviewer.rid=rating.rid group by reviewer.rid having count(stars)>=3
B: select name from reviewer A where (select count(stars) from rating B where A.rid=B.rid group by rid)>=3
C: select name from reviewer where (select count(stars) from rating where reviewer.rid=rating.rid)>=3
D: select name from review,rating where reviewer.rid=rating.rid and count(stars)>=3 group by reviewer.rid
-
要找出对同一部电影评论次数在3次及以上的评论者姓名,下列语句不能实现该功能的是——
A: select name from reviewer,rating where reviewer.rid=rating.rid group by reviewer.rid having count(stars)>=3
B: select name from reviewer A where (select count(stars) from rating B where A.rid=B.rid group by rid)>=3
C: select name from reviewer where (select count(stars) from rating where reviewer.rid=rating.rid)>=3
D: select name from review,rating where reviewer.rid=rating.rid and count(stars)>=3 group by reviewer.rid