Data Analysis, Business Intelligence, Power Bi, Sql, Data Analyst.
select company, avg_salary, rnk from ( select company, avg_salary, dense_rank() over(order by avg_salary desc) as rnk from cte )x where rnk<=5 Image designed by author Kamireddy Mahendra. 2. list the number of companies that come under different average pay scale ranges (<1L as low, 1L-3L as