The following diagram shows the tables for the HR database: The objective of this project is to run through some SQL practice problems that ... E.dep_id FROM employees AS E LEFT OUTER JOIN departments ...