SELECT e.EMP_NO, e.FIRST_NAME, e.LAST_NAME, e.DEPT_NO, e.JOB_CODE
FROM EMPLOYEE e
JOIN DEPARTMENT d ON e.DEPT_NO = d.DEPT_NO
WHERE d.DEPARTMENT IN ('Marketing', 'Finance')
ORDER BY e.EMP_NO ASC;
;
SELECT 'Last_query_cost' AS "Variable_name", 0 AS "Value" FROM RDB$DATABASE;