多个表的group by异常_Oracle管理

多个表的group by错误
这是一个题目现在有两个表职工表 employee(ENO,ENAME,AGE,SEX,SALARY,DNO)
部门表 dept(dno,dname,ma_no)
现在需要查询每个部门男女职工的人数用一个select语句显示(dno,dname,sex,conut_eno)
我写了一个select语句
select dept.dno,dept.dname,employee.sex,count(*)as count_eno from employee,dept
where dept.dno=employee.dno group by employee.sex,dept.dno
显示是group by 表达式错误不能通过新手请大家指教

------解决方案--------------------

SQL code

select dept.dno,dept.dname,employee.sex,count(*)as count_eno from employee,deptwhere dept.dno=employee.dno group by employee.sex,dept.dno如果要这样写就应该是：select dept.dno,dept.dname,employee.sex,count(*)as count_eno from employee,deptwhere dept.dno=employee.dno group by dept.dno,dept.dname,employee.sex
------解决方案--------------------

select b.DNO,
      b.dname,
      t.SEX,
      count(distinct t.ENO) as count_eno
 from employee t ,
      dept b
 where t.DNO = b.DNO
 group by t.sex,b.dno,b.dname
 order by b.dno,t.sex ;