A.
select sDept,count(*) from student where sDept in('软件学院','网络空间学院') group by sDept with rollup;
B.
select sDept,count(*) from student where sDept in('软件学院','网络空间学院') group by sDept;
C.
select sDept,count(*) from student group by sDept where sDept in('软件学院','网络空间学院') with rollup;
D.
select sDept,count(*) from student where sDept ='软件学院' or sDept='网络空间学院' group by sDept with rollup;