TGTGInsighttelegram intelligenceLIVE / telegram public index
TGINSIGHT POST
Post #2344
@sqlspecialist
Data Analytics
Post content
Post content
πππ»ππ²πΏππΆπ²ππ²πΏ: 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!