Query: select job, max(sal) "max-sal", min(sal) "min-sal" from emp group by job
Query:
select job, max(sal) "max-sal", min(sal) "min-sal" from emp group by job