title: Average the sal then sort in descending order
body: <p>I want to list all the employees that make more than the average salary. I'm alittle lost on this one. I need to add up all the salary's then average them out and only display the ones that make more than the average. I need alot of help on this one.</p>
  
  <p>My query that doesnt work</p>
  
  <pre><code> SQL&gt; select empno, ename, job, hiredate, sal, deptno from emp where sal avg(sal);
   select empno, ename, job, hiredate, sal, deptno from emp where sal avg(sal)
                                                                 *
   ERROR at line 1:
   ORA-00920: invalid relational operator
   SQL&gt;
  </code></pre>
  
  <p>Table</p>
  
  <pre><code>SQL&gt; select empno, ename, job, hiredate, sal, deptno from emp;
  
   EMPNO ENAME      JOB       HIREDATE         SAL     DEPTNO
   ---------- ---------- --------- --------- ---------- ----------
    7839 KING       PRESIDENT 17-NOV-81       5000         10
    7698 BLAKE      MANAGER   01-MAY-81       2850         30
    7782 CLARK      MANAGER   09-JUN-81       2450         10
    7566 JONES      MANAGER   02-APR-81       2975         20
    7654 MARTIN     SALESMAN  28-SEP-81       1250         30
    7499 ALLEN      SALESMAN  20-FEB-81       1600         30
    7844 TURNER     SALESMAN  08-SEP-81       1500         30
    7900 JAMES      CLERK     03-DEC-81        950         30
    7521 WARD       SALESMAN  22-FEB-81       1250         30
    7902 FORD       ANALYST   03-DEC-81       3000         20
    7369 SMITH      CLERK     17-DEC-80        800         20
  
   EMPNO ENAME      JOB       HIREDATE         SAL     DEPTNO
   ---------- ---------- --------- --------- ---------- ----------
    7788 SCOTT      ANALYST   09-DEC-82       3000         20
    7876 ADAMS      CLERK     12-JAN-83       1100         20
    7934 MILLER     CLERK     23-JAN-82       1300         10
  
   14 rows selected.
  </code></pre>