A.

SELECT film,sum(attendance) FROM movie WHERE pdate='20210221'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 film