SELECT EMP_NO, FIRST_NAME, LAST_NAME, HIRE_DATE, JOB_CODE FROM EMPLOYEE
JOIN EMPLOYEE_PROJECT
ON EMPLOYEE.EMP_NO = EMPLOYEE_PROJECT.EMP_NO
JOIN PROJECT
ON EMPLOYEE_PROJECT.PROJ_ID = PROJECT.PROJ_ID
WHERE PROJ_NAME = "Video Database"
ORDER BY LAST_NAME ASC;