CREATE TABLE Employees (
EmployeeID INT PRIMARY KEY,
FirstName VARCHAR(50),
LastName VARCHAR(50),
Department VARCHAR(50),
ManagerID INT,
Salary DECIMAL(10, 2)
);
-- Inserting sample data
INSERT INTO Employees VALUES (1, 'John', 'Doe', 'IT', NULL, 70000.00);
INSERT INTO Employees VALUES (2, 'Jane', 'Smith', 'HR', 1, 60000.00);
INSERT INTO Employees VALUES (3, 'Bob', 'Johnson', 'IT', 1, 80000.00);
INSERT INTO Employees VALUES (4, 'Alice', 'Williams', 'Finance', 2, 75000.00);
INSERT INTO Employees VALUES (5, 'Charlie', 'Brown', 'HR', 1, 65000.00);
INSERT INTO Employees VALUES (6, 'Eva', 'Davis', 'Finance', 2, 90000.00);
INSERT INTO Employees VALUES (7, 'Frank', 'Miller', 'IT', 3, 72000.00);
INSERT INTO Employees VALUES (8, 'Grace', 'Jones', 'Finance', 2, 85000.00);
To embed this program on your website, copy the following code and paste it into your website's HTML: