Problema ejercicio sql

[flaviovich]

Asi?

Código SQL:

SELECT E.*
FROM temple E
INNER JOIN (SELECT numde, AVG(salar) salar FROM temple GROUP BY numde) T
ON E.numde = T.numde AND E.salar > T.salar