create table emp(empid int, empname varchar(100), deptid int); 

emp 表数据插入如下： 

insert into emp(empid, empname, deptid) values(11,'张三', 1001);

insert into emp(empid, empname, deptid) values(12,'李嘉', 1001);

 insert into emp(empid, empname, deptid) values(13,'王五', 1002); 

insert into emp(empid, empname, deptid) values(14,'赵六', 1003);

 insert into emp(empid, empname, deptid) values(15,'李学光', 1005); 

insert into emp(empid, empname, deptid) values(16,'陈子李', 1005);

 insert into emp(empid, empname, deptid) values(17,'赵乾', 1005);

下列 sql 的查询结果是： select deptid, count(*) num from emp group by deptid order by num desc , depti