this is what I have to do using SQL developer \"Display the employee number, nam

Question

this is what I have to do using SQL developer

"Display the employee number, name, salary, and salary increased by 15% expressed as a whole number. Label the column New Salary."

this is how I did it:

SELECT empno, ename, sal, round(sal*0.15+sal) "New Salary" FROM emp;

this is what my query looks like:

now, I am asked to

"Modify your query from 3 to add an additional column that will substract the old salary from the new salary. Label the column increase. Rerun your query."

the question is how can I do that?, is there is any way I can use the data from the "New Salary" column?
how?

EMPNO ENAME SAL Neu Salary 7369 SHITH 7499 ALLEN 7521 WARD 7566 TONES 800 1600 12 50 2975 1250 2850 2450 3000 5000 1500 1100 950 3000 1300 920 1840 1438 3421 1438 3278 2818 3450 5750 1725 1265 1093 3450 1495 7654 MARTIN 7698 BLAKE 7782 CLARK 7788 SCOTT 7839 KING 7844 TURNER 7876 ADAMS 7900 JAMES 7902 FORD 7934 HILLER 14 rous selected.

Explanation / Answer

select employee_id, last_name, salary, salary+(salary*15.5/100) "New Salary", (salary+(salary*15.5/100))-salary "Increses"

from employees;

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.