SELECT a.emp_no, CONCAT(a.first_name, ' ', a.last_name) emp_name,
       c.dept_name
  FROM employees a,
       dept_emp b,
       departments c
 WHERE a.emp_no = b.emp_no
   AND b.dept_no = c.dept_no
 ORDER BY a.emp_no;