List the details of the emps in asc order of the Dptnos and desc of Jobs?

Answer:

select * from emp order by deptno asc,job desc;