A.
Select sdept,count(sno) From student Where sname like ‘%’ Group by ssex ,sdept Having ssex='女' Order by sdept Desc
B.
Select count(sno) From student Where sname like ‘%’
C.
Select count(sno) From student Having ssex='女'
D.
Select count(sno) From student