用看的、听的学真题
study by eyes and ears.
2021年05月数据库系统工程师考试上午真题【基础知识】（第45题）
收藏
【45】某电影院某日电影入座情况如下表所示。为调整场次，要统计2021年2月21日到场人数总数大于100的电影，可满足要求的SQL语句是（45）。
-
ASELECT film,sum(attendance) FROM movie WHERE pdate='20210221' HAVING sumattendance)>100
-
BSELECT film,sum(attendance) FROM movie WHERE pdate='20210221' AND attendance >100 GROUP BY film
-
CSELECT film,sum(attenedance) FROM movie WHERE pdate='20210221' GROUP BY film HAVING sum(attendance)> 100
-
DSELECT film,sum(attendance) FROM movie WHERE pdate=*20210221 AND sum(attendance)>100 GROUP BY film
