📊 𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄𝗲𝗿: How do you find Employees Earning More Than the Average Salary in SQL?

🙋‍♂️ 𝗠𝗲: Use a subquery to calculate average salary first:

SELECT *
FROM employees
WHERE salary > (
  SELECT AVG(salary)
  FROM employees
);

🧠 Logic Breakdown:
- Inner query gets overall average salary
- Outer query filters employees earning more than that

✅ Use Case: Performance reviews, salary benchmarking, raise eligibility

💡 Pro Tip: Use ROUND(AVG(salary), 2) if you want clean decimal output.

💬 Tap ❤️ for more!