CREATE TABLE Employee (
    id INT PRIMARY KEY,
    name VARCHAR(100),
    salary DECIMAL(10,2),
    bonus DECIMAL(10,2),
    department VARCHAR(50)
);

INSERT INTO Employee (id, name, salary, bonus, department)
VALUES
(1, 'Alice Johnson', 68000.00, 3000.00, 'Finance'),
(2, 'Bob Smith', 72000.00, 4000.00, 'Marketing'),
(3, 'Carlos Mendes', 95000.00, 6000.00, 'Finance'),
(4, 'Diana Lee', 64000.00, 2500.00, 'HR'),
(5, 'Ethan Patel', 50000.00, 1500.00, 'Finance'),
(6, 'Fatima Al-Farsi', 87000.00, 5200.00, 'Engineering'),
(7, 'George Smith', 48000.00, 1800.00, 'Finance'),
(8, 'Hannah Kim', 66000.00, 2200.00, 'Finance'),
(9, 'Ivan Petrov', 71000.00, 4100.00, 'Legal'),
(10, 'Julia Chen', 69000.00, 3300.00, 'Finance');

SELECT name 
FROM Employee 
WHERE department = 'Finance';

SELECT name, salary 
FROM Employee 
WHERE Bonus < 3000; 

Embed on website

To embed this project on your website, copy the following code and paste it into your website's HTML: