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... Weiterlesen: Find Departments with an Average Salary Above the Company Average