title: Display each department’s number and name and the number of employees employed in each department
body: <p>This is what I tried and cant get it to work</p>
  
  <pre><code>SELECT d.deptno,d.dname
  COUNT('e.empno') "number of employees"
  FROM dept,emp
  WHERE d.deptno = e.deptno
  GROUP BY d.deptno,d.dname
  </code></pre>
  
  <p>any help is much appreciated thanks</p>