The post provides a step-by-step solution to an SQL interview problem where the task is to determine the second highest employee-manager pair average salary. It details how to observe the expected output, identify conditions like the Employee-Manager pair, use self-join to fetch necessary data, calculate average salaries, and assign rankings to filter for the needed result.
Table of contents
Data Analyst / Data Engineer Interview Preparation — SQLQ) Given Input table as Employee Table and also given Expected Output. Then, Guess the problem and Write a Solution using SQL Query.Solution Steps in Detail:2 Comments
Sort: