CREATE TABLE Employee (
    EmployeeID INT AUTO_INCREMENT PRIMARY KEY,
    FirstName VARCHAR(50),
    LastName VARCHAR(50),
    Email VARCHAR(100),
    DepartmentID INT,
    Salary DECIMAL(10, 2),
    
);


INSERT INTO Employee VALUES
(1, 'John', 'Smith', 'john.smith@example.com', 1, 65000.00),
(2, 'Lisa', 'Johnson', 'lisa.johnson@example.com', 2, 72000.00),
(3, 'Michael', 'Williams', 'michael.williams@example.com', 3, 60000.00),
(4, 'Susan', 'Davis', 'susan.davis@example.com', 1, 55000.00),
(5, 'David', 'Miller', 'david.miller@example.com', 2, 68000.00),
(6, 'Laura', 'Anderson', 'laura.anderson@example.com', 3, 62000.00),
(7, 'James', 'Jones', 'james.jones@example.com', 1, 58000.00),
(8, 'Emily', 'Brown', 'emily.brown@example.com', 2, 70000.00),
(9, 'William', 'Wilson', 'william.wilson@example.com', 3, 63000.00),
(10, 'Sarah', 'Taylor', 'sarah.taylor@example.com', 1, 59000.00);

UPDATE Employee SET Salary = Salary * 0.19 WHERE Age > 35;
UPDATE Employee SET Salary = Salary * 1.1 WHERE Age <- 35;

-- DELETE FROM Employee WHERE Age >35;
SELECT SUM(Salary) AS total_salary_old FROM Employee WHERE Age>35;
SELECT SUM(Salary) AS total_salary_young FROM Employee WHERE Age<-35;
SELECT * FROM Employee