Chapter 5 CHALLENGE

Add three records.

INSERT INTO HumanResources.Employees VALUES
    (2,'Tim', 'Graupmann', 'IT', '20211028'),
    (3,'Linae', 'Graupmann', 'IT', '20211028'),
    (4,'Logan', 'Graupmann', 'IT', '20211028')
;

Promote an employee.

UPDATE HumanResources.Employees
SET Department = 'IT Admin'
WHERE EmployeeID = 1
;

Retire an employee.

DELETE FROM HumanResources.Employees
WHERE EmployeeID = 3
;