Only this week, get the SQL Complete Track of 9 courses in a special prize of $330 $89!
Exercises with artist, museums and their pieces of art
Exercises with the band members table
Exercises with employees, salaries and benefits
27. From rags to riches


Okay! Try to solve this one!


Show each employee's first name, last name, salary, and the first name and last name of their direct manager in the same row.

Prefix the employee's columns with employee_ and the manager's with manager_, e.g.: employee_first_name.