Creating a Staging Table

Problem

You need an exact replica of the employees table schema to dump nightly raw data into, before running your cleaning scripts. You don't want to manually type out all 15 columns in a CREATE statement. Write a DDL statement to create a table stg_employees with the exact same structure as employees, but entirely empty.

Database Schema

Table: employees

• employee_id (INT): Unique identifier for the employee.
• first_name (VARCHAR): First name of the employee.
• last_name (VARCHAR): Last name of the employee.
• salary (INT): Employee's salary.
• department_id (INT): Foreign key referencing the department.
• manager_id (INT): Foreign key referencing the manager (another employee).
• hire_date (DATE): Date the employee was hired.

Table: departments

• department_id (INT): Unique identifier for the department.
• department_name (VARCHAR): Name of the department.

Try It

Hint

Solution