The HR director needs a current roster showing which department each employee is assigned to, to ensure all departmental records are accurate and up to date.
Return
name: the employee's name
name: the department's name
Include only employees who are assigned to a department. List the results in alphabetical order by employee name.
Expected output
name
name (2)
Ana Reyes
Engineering
Ben Cho
Engineering
Cara Diaz
Engineering
First 3 of 9 rows your query should return. Your column aliases don't need to match.