Select: Who Makes The Big Bucks?

What's the largest monthly salary?

SQL> select max(sal) from emp;

  MAX(SAL)
----------
      5000

Who makes that salary?

SQL> select ename from emp where sal = (select max(sal) from emp);

ENAME
----------
KING

What's the difference between highest & lowest salaries?

SQL> select max(sal)/min(sal) from emp;

MAX(SAL)/MIN(SAL)
-----------------
	     6.25