NIT.SQL

CREATE Table EMP(
    EMPNO  NUMERIC(4) NOT NULL,
    ENAME VARCHAR(10),
    JOB VARCHAR(19),
    MGR NUMERIC(4),
    HIREDATE DATE,
    SAL NUMERIC(7,2),
    COMM NUMERIC(7,2),
    DEPTNO NUMERIC(3),
    AGE NUMERIC(3),
    ESAL NUMERIC
);

INSERT INTO EMP VALUES (5765,"KILLY","HOD",7902,"1980-03-23",800,0,20,25,0),
                       (5762,"MILLY","PION",7698,"1999-09-25",1800,300,10,25,0),
                       (5763,"JAMES","PRINCIPAL",7698,"1981-07-29",2800,700,20,25,0),
                       (5760,"ANKY","MANAGER",7839,"1987-03-13",1600,900,90,10,0),
                       (5768,"COLLER","HEAD",7645,"1998-03-29",2200,600,10,25,0);

SELECT ENAME,SAL,(0.15*SAL) AS "RAISE IN SAL" FROM EMP;
SELECT ENAME FROM EMP WHERE MGR IS NOT NULL;
SELECT DEPTNO, COUNT(*) FROM EMP GROUP BY DEPTNO;
SELECT ENAME FROM EMP WHERE COMM IS NULL;
SELECT ENAME FROM EMP WHERE DEPTNO = 20;
drop table EMP;