Question

Display name, salary and commission for all employees whose commission amount is greater than their salary increased by 15%.​

Answer 1

Answer:

How to display employee name and his salary whose salary is greater than highest average of department number? SELECT ename,deptno,sal FROM emp WHERE sal> (SELECT MAX(AVG(sal)) FROM emp GROUP BY deptno );