I am trying to create a SELECT statement that displays ename, deptno, sal from the scott.emp table on people who earn more than the average sal in their department. NOT the total average of all the sal but the average from each departments. Please help