
use C21_DB1;

CREATE TABLE Employees2 (
    Name VARCHAR(50),
    Department VARCHAR(50),
    Salary INT,
    PerformanceRating INT
);

INSERT INTO Employees2 (Name, Department, Salary, PerformanceRating) VALUES ('Employee 1', 'Marketing', 90651, 81);
INSERT INTO Employees2 (Name, Department, Salary, PerformanceRating) VALUES ('Employee 2', 'Marketing', 62945, 75);
INSERT INTO Employees2 (Name, Department, Salary, PerformanceRating) VALUES ('Employee 3', 'HR', 59665, 80);
INSERT INTO Employees2 (Name, Department, Salary, PerformanceRating) VALUES ('Employee 4', 'HR', 93279, 64);
INSERT INTO Employees2 (Name, Department, Salary, PerformanceRating) VALUES ('Employee 5', 'IT', 111884, 72);
INSERT INTO Employees2 (Name, Department, Salary, PerformanceRating) VALUES ('Employee 6', 'HR', 63199, 96);
INSERT INTO Employees2 (Name, Department, Salary, PerformanceRating) VALUES ('Employee 7', 'Marketing', 96372, 74);
INSERT INTO Employees2 (Name, Department, Salary, PerformanceRating) VALUES ('Employee 8', 'HR', 106907, 75);
INSERT INTO Employees2 (Name, Department, Salary, PerformanceRating) VALUES ('Employee 9', 'HR', 91444, 69);
INSERT INTO Employees2 (Name, Department, Salary, PerformanceRating) VALUES ('Employee 10', 'IT', 76801, 94);
INSERT INTO Employees2 (Name, Department, Salary, PerformanceRating) VALUES ('Employee 11', 'Marketing', 112522, 88);
INSERT INTO Employees2 (Name, Department, Salary, PerformanceRating) VALUES ('Employee 12', 'IT', 108024, 65);
INSERT INTO Employees2 (Name, Department, Salary, PerformanceRating) VALUES ('Employee 13', 'HR', 118334, 65);
INSERT INTO Employees2 (Name, Department, Salary, PerformanceRating) VALUES ('Employee 14', 'Marketing', 84143, 80);
INSERT INTO Employees2 (Name, Department, Salary, PerformanceRating) VALUES ('Employee 15', 'IT', 58163, 92);
INSERT INTO Employees2 (Name, Department, Salary, PerformanceRating) VALUES ('Employee 16', 'HR', 51840, 91);
INSERT INTO Employees2 (Name, Department, Salary, PerformanceRating) VALUES ('Employee 17', 'Marketing', 62225, 66);
INSERT INTO Employees2 (Name, Department, Salary, PerformanceRating) VALUES ('Employee 18', 'Marketing', 102274, 79);
INSERT INTO Employees2 (Name, Department, Salary, PerformanceRating) VALUES ('Employee 19', 'Marketing', 50149, 95);
INSERT INTO Employees2 (Name, Department, Salary, PerformanceRating) VALUES ('Employee 20', 'Marketing', 114694, 78);
