皮皮学，免费搜题
登录
搜题
【单选题】
已知影片评论数据库包括如下表结构：Movie ( mID, title, year, director )影片表，属性包括影片编号，影片名，发行年份以及导演。Reviewer ( rID, name )评论者表，属性包括评论者编号，评论者姓名。Rating ( rID, mID, stars, ratingDate )评论表，属性包括评论者编号，影片编号，评分（1-5），评论日期。基于该数据库完成以下SQL题目。下面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 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
手机使用
分享
复制链接
新浪微博
分享QQ
微信扫一扫
反馈参考答案：
举一反三
【简答题】A.John will tell Susan whether he surely needs her help on Friday. B.Susan will take Johns cousin to the music festival on their campus. C.They will have a further discussion according to the weather ...
【单选题】The manager of the restaurant has made it clear that a cook will be immediately fired if he is found ______ in the kitchen.
A.
smoke
B.
smoked
C.
smoking
D.
to smoke
【单选题】有一牛采食大量紫花苜蓿草,采食后不久发病,发病后腹部急剧膨胀,左肷部显著突出,触压有弹性,叩诊呈鼓音,听诊瘤胃蠕动音减弱甚至消失。呼吸困难,表现前肢张开,张口伸舌,黏膜发绀,心悸,脉增数,后期因心力衰竭窒息而死。本病发生原因的是( )。
A.
偷食红薯、桃等块状食物
B.
采食多量易发酵饲料
C.
长期饲喂单一饲料
D.
长期饲喂粉状饲料
E.
含有金属异物的饲料
相关题目：
参考解析：
知识点：
题目纠错 0
发布
