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
C.
Select count(sno) From student Where sname like ‘%’
D.
Select sdept,count(sno) From student Order by sdept Desc