Salary Less Than Twice The Average - Amazon Interview Question - SQL

Write a query to get the list of managers whose salary is less than twice the average salary of employees reporting to them. For these managers, output their ID, salary and the average salary of employees reporting to them.
Companies appeared in: Amazon, Walmart, BestBuy
Difficulty: Medium
Ideas: Window Function (AVG), Common Table Expresions
Problem: t.ly/gSS34

[@krishnayadav-rb2ei]

Nice explanation how much one will get 🙏

[@algometica8564]

So nice of you