title: List the the name of employee that worked on more than one projects
body: <p>There are two tables that would be relevant in this. Workon and Employee. The contents of these two tables are EMPID    NAME    SALARY  DID (department ID) for employee and PID    EMPID   HOURS from work on. The SQL I have written is </p>
  
  <pre><code>select e.name, w.pid
  from employee e, workon w
  where e.empid = w.empid
  group by e.name, w.pid, w.empid
  having count (e.name) &gt; 1
  order by w.pid
  </code></pre>
  
  <p>I have been trying to figure out why this code will not give me employees that work on more than one project. Please help me figure out what I am doing wrong.</p>