select d.dname, e.ename, e.hiredate, rank() over (partition by e.deptno order by e.hiredate asc) Clasament from emp e, dept d where d.deptno=e.deptno;

select decode(deptno, null, 'DeptAvgSal',deptno ,deptno),
        decode(job, null, 'JobAvgSal',job ,job),
     rank() over (partition by deptno order by round(avg(sal),2) desc) Clasament, round(avg(sal),2) Salariu from emp group by rollup(deptno, job);


select decode(deptno, null, 'DeptAvgSal',deptno ,deptno),
        decode(job, null, 'JobAvgSal',job ,job),
     rank() over (partition by deptno order by round(avg(sal),2) desc) ClasamentDept, rank() over (partition by job order by round(avg(sal),2)) ClasamentJob, round(avg(sal),2) Salariu from emp group by rollup(deptno, job);

select ename, sal, nvl(comm,0) Comision, (sal+nvl(comm,0)) as Venit from emp;

select * from emp;

select * from dept;