select e.emp_no, e.first_name, e.last_name, e.hire_date, e.job_code
from employee e
INNER JOIN employee_project ep ON ep.emp_no = e.emp_no
INNER JOIN project pr ON pr.proj_Id = ep.proj_Id
WHERE pr.proj_name = 'Video Database'
ORDER BY e.last_name, e.job_code;