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