Select Code to Download

# Use ? as placeholders for the values

...
    # the first ?, $name for the second, etc.)
    $sth2->execute( $id, $name, $title, $dept );
}

$dbh->do("
    CREATE GLOBAL TEMPORARY TABLE HR.Tempest(
...
    AND    e.department_id =  d.department_id
");
$dbh->commit();

INSERT INTO HR.Tempest
    INSERT INTO HR.Tempest
...
    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>

---- We want to find employees making over $150K/yr in marketing or sa
+les.
---- However, the department_id of marketing and sales teams are split
+ into
...

WHERE boss.department_name IN ('MARKETING', 'SALES')
AND   emp.salary > 150000;