title: SQL: List the employees who report to those employees who report to (____)
body: <p>from this table..
  <a href="https://i.stack.imgur.com/wdzO6.jpg" rel="nofollow noreferrer">Employees Table </a></p>
  
  <p>Question: List the employees who report to those employees who report to Diane Murphy. Use the CONCAT function to combine the employee's first name and last name into a single field for reporting.</p>
  
  <p>My non-working query..</p>
  
  <pre><code>SELECT employeeNumber, CONCAT(firstName, ' ', lastName), reportsTo
  FROM Employees 
  WHERE reportsto= 1002 
  AND WHERE (SELECT CONCAT(firstName, ' ', lastName), reportsTo
               FROM employees
               WHERE reportsTo= 1056 AND 1076);
  </code></pre>
  
  <p>I am really confused by this question to be honest.</p>
  
  <p>1002= Diane Murphy </p>
  
  <p>1056= Mary Patterson</p>
  
  <p>1076= Jeff Firrelli </p>
  
  <p>Based on my understanding, im trying to query this based on a hierarchal system. 
  I know that both Mary and Jeff report to Diane Murphy and i can look at the table to see who reports to Mary and Jeff, but im lost exactly i go about querying this. </p>
  
  <p>Any help would be appreciated!</p>
  
  <p>Thank you. </p>