QIP_Q033. SQL: average department salary and second-highest salary
difficulty ·answer type: code·✓Not solved
Problem
Table: (Employee name, Department, Salary). (a) Add a column showing average department salary for each employee. (b) Query to return the second highest salary.
Submit answer
You must be signed in to submit answers.