Topic: SQL 🔍 Quick look before the question: SELECT e.name, e.salary… — Data science/ML/AI — TG.ME

SELECT e.name, e.salary
FROM employees e
WHERE e.salary > (
  SELECT AVG(salary)
  FROM employees
  WHERE department = e.department
);