$($Note: solve it with SQL Plus application, please$)$Display the following output. Column heading also should be same.

WHO WHAT AND WHEN

SMITH HELD THE POSITION OF CLERK IN DEPT. NO $20$

ALLEN HELD THE POSITION OF SALESMAN IN DEPT. NO $30$

WARD HELD THE POSITION OF SALESMAN IN DEPT. NO $30$

JONES HELD THE POSITION OF MANAGER IN DEPT. NO $20$

$...14$ rows selected.

Display all the employees who were hired in the year $87.$

Display all those employees from emp table who have two A$\text{'}$s in

their name.

ENAME

ADAMS

Display the Net salary of all those employees whose monthly salary

is between $1000$ and $3000$ and they are working as SALESMAN. Net

salary is calculated based on following formula. $($SAL $+$ COMM $-$

zakat $(2\mathrm{.}5\%$ of SAL$)+$ House rent $(5\%$ of SAL$))$

Display the $10$ days salary for all those persons who don't have

manager. Consider current salary for $30$ days salary.