5. The HR department needs a report with the following specifications:
Last name and department ID of all the employees from the EMPLOYEES table, regardless
of whether or not they belong to a department
Department ID and department name of all the departments from the DEPARTMENTS
table, regardless of whether or not they have employees working in them
Write a compound query to accomplish this.
Practice 8: Solutions
The HR department wants you to create SQL statements to insert, update, and delete employee
data. As a prototype, you use the MY_EMPLOYEE table, before giving the statements to the HR
Insert data into the MY_EMPLOYEE table.
1. Run the statement in the lab_08_01.sql script to build the MY_EMPLOYEE table to be used for
2. Describe the structure of the MY_EMPLOYEE table to identify the column names.
3. Create an INSERT statement to add the first row of data to the MY_EMPLOYEE table from the
following sample data. Do not list the columns in the INSERT clause.