INSERT INTO HR.Tempest
    INSERT INTO HR.Tempest
    SELECT e.employee_id, e.first_name, j.job_title, d.department_name 
    FROM   HR.employees e
    JOIN   HR.jobs j        ON j.job_id = e.job_id
    JOIN   HR.departments d ON d.department_id = e.department_id
    WHERE  <criteria to select a subset of records>