title: project to which maximum number of employees have been allocated
body: <p>I have these tables with the following columns :</p>
  
  <pre><code>Employee24 (EMPLOYEEID, FIRSTNAME, LASTNAME, GENDER);
  
  PROJECT24   (PROJECTID  PROJECTNAME EMPLOYEEID);
  </code></pre>
  
  <p>I want to write a query to find project to which maximum number of employees are alocated.</p>
  
  <pre><code>SELECT FIRSTNAME, LASTNAME
   FROM EMPLOYEE24 E
    WHERE E.EMPLOYEEID IN ( SELECT L2.EMPLOYEEID 
                              FROM PROJECT24 L2 group by l2.employeeid)\\ 
  </code></pre>