1. CREATE TABLE Employee5
2. (
3. EMPNO INT,
4. ENAME VARCHAR(50),
5. JOB VARCHAR(50),
6. MANAGER_NO INT,
7. SAL DECIMAL(10,2)
8. );
9. SELECT*FROM EMPLOYEE5;
10.  ALTER TABLE Employee5
11.  ADD COLUMN COMMISSION DECIMAL(10,2);
12.  
13. INSERT INTO Employee5(EMPNO,ENAME,JOB,MANAGER_NO,SAL,COMMISSION)
14.  VALUES(101,'John Doe','Manager',NULL,5000.00,500.00);
15.  
16.  INSERT INTO Employee5(EMPNO,ENAME,JOB,MANAGER_NO,SAL,COMMISSION)
17.  VALUES(102,'Jane Smith','Developer',101,4000.00,400.00);
18.  
19.  INSERT INTO Employee5(EMPNO,ENAME,JOB,MANAGER_NO,SAL,COMMISSION)
20.  VALUES(103,'Alice Johnson','Analyst',101,3500.00,500.00);
21.  
22.  INSERT INTO Employee5(EMPNO,ENAME,JOB,MANAGER_NO,SAL,COMMISSION)
23.  VALUES(104,'Bob Williams','Tester',102,3000.00,200.00);
24.  
25.  INSERT INTO Employee5(EMPNO,ENAME,JOB,MANAGER_NO,SAL,COMMISSION)
26.  VALUES(105,'Emily Davis','Designer',102,4500.00,700.00);
27.  
28.  UPDATE Employee5
29.  SET JOB='Senior Developer'
30.  WHERE EMPNO=102;
31.  ALTER TABLE Employee
32.  RENAME COLUMN MANAGER_NO TO MANAGEER_NO;
33.  
34.  DELETE FROM Employee5
35.  WHERE EMPNO=105;
36.