✅ The verified answer to this question is available below. Our community-reviewed solutions help you understand the material better.
SELECT e.employee_id, e.last_name, e.first_name, e.department_id, d.department_name
FROM employees e, departments d
WHERE e.department_id = d.department_id
ORDER BY department_id;
Which join algorithm is used?