title: SQL query to get the employee name and their manager name from the same table
body: <p>Employee table </p>
  
  <pre><code>Employee_id  Employee_name   Manager_id
  -------------------------------------
  Emp00001     Ram             Emp00005
  Emp00002     Sharath         Emp00003
  Emp00003     Nivas           Emp00005
  Emp00004     Praveen         Emp00002
  Emp00005     Maharaj         Emp00002
  </code></pre>
  
  <p>Output </p>
  
  <pre><code>Employee Name    Manager Name
  ------------------------------
  Ram              Maharaj
  Sharath          Nivas
  Nivas            Maharaj
  Praveen          Sharath
  Maharaj          Sharath
  </code></pre>
  
  <p>In the <code>employee</code> table, there are three columns <code>Employee_id</code>, <code>employee_name</code> and <code>manager_id</code>. From the table, how to fetch the employee name and their manager name?</p>