INSERT INTO

       "tbl_Employees"

       (
      "employee-ID"
    , "Last Name"
    , "First Name"
    , "Gender"
    , "Start Date"
    , "End Date"
    , "Address"
    , "City"
    , "State"
    , "Zip"
    , "Department-ID"
    , "Group-ID"
    , "Hourly Wage"
    , "Employee-Pics" 

       )

SELECT 
      "employee-ID"
    , "Last Name"
    , "First Name"
    , "Gender"
    , "Start Date"
    , "End Date"
    , "Address"
    , "City"
    , "State"
    , "Zip"
    , CASEWHEN(
	  "Department" = 'Accounting', '1'
		, CASEWHEN(
			"Department" = 'IT', '2'
			 , CASEWHEN( 
			  "Department" = 'Management', '3'
				, CASEWHEN( 
				  "Department" = 'Marketing', '4'
				  , CASEWHEN( 
					"Department" = 'Security', '5'
					, CASEWHEN( 
					  "Department" = 'Manufacturing', '6'
						, '0' 
					) 
				  ) 
				) 
			)
		) 
	  ) AS "NewDept" 
	, CASEWHEN(
	  "Group" = 'Group A', '1'
		, CASEWHEN(
			"Group" = 'Group B', '2'
			 , CASEWHEN( 
			  "Group" = 'Group C', '3'
				, CASEWHEN( 
				  "Group" = 'Group D', '4'
						, '0' 
				) 
			)
		) 
	  ) AS "NewGroup"
        , "Hourly Wage" 
        , "Employee-Pics" 

FROM 
	"tbl_Employees-Original"