title: display manager name and count of employees reporting him in employees table
body: <p>I want to display manager_name and count of employees reporting him in employees table.I want to sort the data based on count IE maximum employees reporting to a manager should come first.</p>
  
  <p>I tried to write self join but i could not get the out put .</p>
  
  <p>EMPLOYEE_ID FIRST_NAME           MANAGER_ID     SALARY HIRE_DATE</p>
  
  <hr>
  
  <pre><code>    198 Donald                      124       2600 21-JUN-99
      199 Douglas                     124       2600 13-JAN-00
      200 Jennifer                    101       4400 17-SEP-87
      201 Michael                     100      13000 17-FEB-96
      202 Pat                         201       6000 17-AUG-97
      203 Susan                       101       6500 07-JUN-94
      204 Hermann                     101      10000 07-JUN-94
      205 Shelley                     101      12000 07-JUN-94
      206 William                     205       8300 07-JUN-94
      100 Steven                               24000 17-JUN-87
      101 Neena                       100      17000 21-SEP-89
  </code></pre>
  
  <p>the table name is employees and i want to see names also</p>