单选题某电影院某日电影入座情况如下表所示。为调整场次，要统计2021年2月21日到场人数总数大于100的电影，可满足要求的SQL语句是()

A、 SELECT film,sum(attendance) FROM movie WHERE pdate ='202 10221' HAVING sumattendance)> 100
B、 SELECT film,sum( attendance) FROM movie WHERE pdate = 20210221’AND attendance >100 GROUP BY film
C、 SELECT filmum(attenedance) FROM movie WHERE pdate = *20210221’ GROUP BY film HAVING sum(attendance)> 100
D、 SELECT film,sum(attendance) FROM movie WHERE pdate = *20210221 AND sum(attendance)> 100 GROUP BY flm

【正确答案】 C

【答案解析】