well what I have is the following:

the code for retrieving the data:

SELECT e.employee_id, hire_date, e.manager_id, e.salary

FROM employees e JOIN departments d

ON e.department_id = d.department_id

WHERE d.department_name = 'IT'

AND e.manager_id IN (101, 102, 103, 108)

now the part I am stuck at is this:

If the salary is less than a certain AMOUNT (request the user to dynamically insert this value),

o insert the details of employee ID and salary into the SPECIAL_SAL table.

o Insert the details of employee ID, hire date and salary into the SAL_HISTORY table.

o Insert the details of employee ID, manager ID and salary into the MGR_HISTORY table.

if I run the part that I have it all works fine, but I don't know how to combine that to insert data in a table if my salary is say like less than 6000