employee table

CREATE TABLE emp(
  Empno INT(10) PRIMARY KEY NOT NULL,
  Ename VARCHAR(200),
  Job VARCHAR(20),
  Mgr INT(10),
  Hiredate DATE NOT NULL,
  Sal NUMBER(6,2),
  Comm NUMBER(6,2),
  Deptno NUMBER(2)
  )
 INSERT INTO emp (Empno, Ename, Job, Mgr, Hiredate, Sal, Comm, Deptno)
VALUES
    (369, 'Smith', 'Clerk', 7902, '1980-12-17', 800.00, NULL, 20),
    (7499, 'Allen', 'Salesman', 7698, '1981-02-20', 1600.00, NULL, 30),
    (7521, 'Ward', 'Salesman', 7698, '1981-02-22', 1250.00, 3000.00, 30),
    (7566, 'Jones', 'Manager', 7839, '1981-04-02', 2975.00, 500.00, 20),
    (7654, 'Marin', 'Salesman', 7698, '1981-09-28', 1250.00, NULL, 20),
    (7698, 'Blake', 'Manager', 7839, '1981-05-01', 2850.00, 1400.00, 30),
    (7782, 'Clark', 'Manager', 7839, '1981-06-09', 2450.00, NULL, 10),
    (7788, 'Scott', 'Analyst', 7566, '1982-12-09', 3000.00, NULL, 20),
    (7839, 'King', 'President', NULL, '1981-11-17', 5000.00, NULL, 10),
    (7844, 'Turner', 'Salesman', 7698, '1981-09-08', 1500.00, 0.000, 30),
    (7876, 'Adams', 'Clerk', 7788, '1983-01-12', 1100.00, NULL, 20),
    (7900, 'James', 'Clerk', 7698, '1981-12-03', 950.00, NULL, 30),
    (7902, 'Ford', 'Analyst', 7566, '1981-12-04', 3000.00, NULL, 20),
    (7934, 'Miller', 'Clerk', 7782, '1982-01-23', 1300.00, NULL, 10);

SELECT * FROM emp