• 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

点击查看

文字解析 视频解析

暂无