[Question] Average Salary for a Manager's Direct Reports

Question: Inspect the table employee_data attached to this community post. Write a query that shows the average salary of each manager’s direct reports.

Original Table:

 

Desired Output:

 


Ready for the solution? Click here!

Reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
Like Follow
  • 11 mths agoLast active
  • 253Views
  • 1 Following