CREATE TABLE Employee(
  ID INT PRIMARY KEY, 
    Name VARCHAR(50), 
    Salary DECIMAL(10,2), 
    Bonus DECIMAL(8,2),
    Department VARCHAR(100)
);

INSERT INTO(ID, Name, Salary, Bonus, Department)VALUES
('John Doe', 75000.00,5000, 'Engineering'),
('Jane Smith', 68000.00,3000, 'Marketing'),
('Michael Johnson', 60000.00,2500,'HR'),
('Emily Davis', 72000.00,1000, 'Finance'),
('David Brown', 69000.00,2500, 'Engineering');

UPDATE Employee 
Set Bonus + 200 
WHERE Salary < 70000;