Select EMPLOYEE.EMP_NO, EMPLOYEE.FIRST_NAME, EMPLOYEE.LAST_NAME, EMPLOYEE.HIRE_DATE, EMPLOYEE.JOB_CODE, PROJECT.PROJ_ID, PROJECT.PROJ_NAME
from EMPLOYEE
join EMPLOYEE_PROJECT
on EMPLOYEE.EMP_NO=EMPLOYEE_PROJECT.EMP_NO
join PROJECT
on EMPLOYEE_PROJECT.PROJ_ID=PROJECT.PROJ_ID
where PROJECT.PROJ_NAME="Video Database"
order by EMPLOYEE.FIRST_NAME, JOB_CODE;