title: Get the total count of employees reporting to the Supervisor MYSQL
body: <p>I have a table called EMPLOYEE which has the following columns.</p>
  
  <pre><code>DESC EMPLOYEE;
  +-----------+-------------+------+-----+---------+-------+
  | Field     | Type        | Null | Key | Default | Extra |
  +-----------+-------------+------+-----+---------+-------+
  | Fname     | varchar(15) | NO   |     | NULL    |       |
  | Minit     | char(4)     | YES  |     | NULL    |       |
  | Lname     | varchar(15) | NO   |     | NULL    |       |
  | Ssn       | char(9)     | NO   | PRI | NULL    |       |
  | Bdate     | date        | YES  |     | NULL    |       |
  | Address   | varchar(50) | YES  |     | NULL    |       |
  | Sex       | char(4)     | YES  |     | NULL    |       |
  | Salary    | int(11)     | YES  |     | NULL    |       |
  | Super_ssn | char(9)     | YES  | MUL | NULL    |       |
  | Dno       | int(11)     | NO   | MUL | NULL    |       |
  +-----------+-------------+------+-----+---------+-------+
  </code></pre>
  
  <p>Super_ssn is the foreign_key which refers to Ssn in the same table. I have to get the first and last name of the employee who is also a supervisor. I am able to achieve this by the following query.</p>
  
  <pre><code>SELECT E.Fname, E.Lname FROM EMPLOYEE E, EMPLOYEE S WHERE S.Super_ssn = E.Ssn;
  </code></pre>
  
  <p>I want to get the total number of employees directly supervised by each supervisor. I'm having difficulty figuring out how to do that.</p>
  
  <pre><code>SELECT E.Fname, E.Lname, COUNT(*) 
  FROM EMPLOYEE E, EMPLOYEE S WHERE S.Super_ssn = E.Ssn GROUP_BY E.Ssn;
  </code></pre>
  
  <p>I am sure what I did above is wrong. Can someone help me?. Thanks in advance.</p>