19. **Salary Challenge

SELECT e.DepartmentID,AVG(e.Salary) AS AVGSalary
INTO #Employees2
FROM Employees e
GROUP BY e.DepartmentID
ORDER BY e.DepartmentID

SELECT top (10) e.FirstName, e.LastName, e.DepartmentID, e.Salary, em.AVGSalary
FROM Employees e
LEFT JOIN #Employees2 em
ON e.DepartmentID= em.DepartmentID
WHERE e.Salary> em.AVGSalary
ORDER BY e.DepartmentID