Salary Challenge

SELECT e.first_name,e.last_name,e.department_id
    FROM employees AS e , employees AS m
        WHERE e.department_id = m.department_id
        AND e.salary > (
                           SELECT avg(salary)  FROM employees
                           WHERE department_id = e.department_id
                            )
    GROUP BY e.first_name,e.last_name,e.department_id
    ORDER BY e.department_id
LIMIT 10