SyntaxFix
Write A Post
Hire A Developer
Questions
Please try:
select count(*) as count,dept.DNAME from emp inner join dept on emp.DEPTNO = dept.DEPTNO group by dept.DNAME