CREATE TABLE Employee5
(
EMPNO INT,
ENAME VARCHAR(50),
JOB VARCHAR(50),
MANAGER_NO INT,
SAL DECIMAL(10,2)
);
SELECT*FROM EMPLOYEE5;
 ALTER TABLE Employee5
 ADD COLUMN COMMISSION DECIMAL(10,2);
 
INSERT INTO Employee5(EMPNO,ENAME,JOB,MANAGER_NO,SAL,COMMISSION)
 VALUES(101,'John Doe','Manager',NULL,5000.00,500.00);
 
 INSERT INTO Employee5(EMPNO,ENAME,JOB,MANAGER_NO,SAL,COMMISSION)
 VALUES(102,'Jane Smith','Developer',101,4000.00,400.00);
 
 INSERT INTO Employee5(EMPNO,ENAME,JOB,MANAGER_NO,SAL,COMMISSION)
 VALUES(103,'Alice Johnson','Analyst',101,3500.00,500.00);

 INSERT INTO Employee5(EMPNO,ENAME,JOB,MANAGER_NO,SAL,COMMISSION)
 VALUES(104,'Bob Williams','Tester',102,3000.00,200.00);
 
 INSERT INTO Employee5(EMPNO,ENAME,JOB,MANAGER_NO,SAL,COMMISSION)
 VALUES(105,'Emily Davis','Designer',102,4500.00,700.00);
 
 UPDATE Employee5
 SET JOB='Senior Developer'
 WHERE EMPNO=102;
 ALTER TABLE Employee
 RENAME COLUMN MANAGER_NO TO MANAGEER_NO;
 
 DELETE FROM Employee5
 WHERE EMPNO=105;