JavaScript is required for SkillDojo AI to work properly. Please enable JavaScript and refresh the page.

Employee Department List | Algorithm

EasyjoinsSQL

Employee Department List

The HR department is updating the company directory and needs to verify which employees are assigned to which departments. They require a list showing every employee who is currently assigned to a department, along with the name of that department.

Return

name : the employee's name name : the name of the department the employee belongs to Include only employees who are assigned to a department. Order the results alphabetically by employee name.

Expected output

First 3 of 9 rows your query should return. Your column aliases don't need to match.

SQLite · Ctrl+Enter to run

Run your query to see results here.