Question

Use sql to Create table EMP with the following description :
Name Type
EMPNO NOT NULL NUMBER(4)
ENAME VARCHAR2(10)
JOB VARCHAR2(9)
MGR NUMBER(4)
HIREDATE DATE
SAL NUMBER(7,2)
COMM NUMBER(7,2)
DEPTNO NUMBER(3)
AGE NUMBER(3)
ESAL NUMBER
a. List all employee names , salary and 15% rise in salary.

b. List ename whose manager is not NULL.

c. Find no.of dept in employee table.

d. List ename whose commission is NULL.

e. Display ename of the dept. with deptno 20.

Answer 1

Answer:

not available

Explanation:

please tell the full question

unable to understand

please MARK as the BRAINLIEST