6.2.10
SELECT employee_id, d.department_id, department_name, hire_date, last_name FROM departments d JOIN employees e ON(d.department_id = e.department_id)
WHERE hire_date = '07-Jun-1994'