1.      SELECT ename, sal, sal*1.1 AS NEW_SAL, sal*0.1 AS INCREASE <br>
        FROM emp <br>
        <br><br>
        
2.      SELECT ename, hiredate, NEXT_DAY(hiredate, 'SATURDAY')<br>
        FROM emp <br>
        WHERE UPPER(ename) = 'KING'<br>
        <br><br>
        
3.      SELECT ename, (SYSDATE-hiredate)/7 AS WEEKS <br>
        FROM emp <br>
        WHERE LOWER(job) = 'salesman' <br>
        <br><br>