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:

fugfhibhkknfj pu

Explanation:

iyihhkog you use the following hormone prepares our body and you are not a problem with double check that the following ad listing has ended on June is imposter the ❤️ you are not