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;
To embed this project on your website, copy the following code and paste it into your website's HTML: