下面子查询语句正确的是哪两项()
A.select*fromemployeeswheresalary>(selectmin(salary)fromemployeesgroupbydepartment.id)
B.select*fromemployeeswheresalary=(selectavg(salary)fromemployeesgroupbydepartment_id)
C.selectdepartment_idfromemployeeswheresalary>all(selectavg(salary)fromemployeesgroupbydepartment_id)
D.selectlast_namefromemployeeswheresalary>any(selectmax(salary)fromemployeesgroupbydepartment_id)