Tech
Find Departments with an Average Salary Above the Company Average
SQL Challenge.
Find Departments with an Average Salary Above the Company Average
Here’s a practical SQL interview question. Can you find which departments have an average salary higher than the company-wide average?
Table 1: employees
emp_id
dept_id
salary
101
10
80000
102
10
100000
103
10
90000
104
20
50000
105
20
60000
106
20
70000
107
30
40000
108
30
50000
Table 2: departments
...
Read the full discussion on Dev.to
This article was aggregated from Dev.to. Click to join the conversation.
View on Dev.to