SELECT `first_name`, `last_name`, `department_id`
FROM employees
WHERE `salary` >
(SELECT `department_id`, AVG(`salary`) AS 'avg_salary'
FROM `employees`
GROUP BY `department_id`) AS 'avg_salary'
ORDER BY `department_id`
LIMIT 10;