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;
;
SELECT 'Last_query_cost' AS "Variable_name", 0 AS "Value" FROM RDB$DATABASE;