Create table based on conditions in the current table

Hi all,   I've an "Employee" table which contains all the employees from a company. In this table, in addition to the name, function, etc. there is one column with the employeeID, and another one w...