Find Employees With Salary Lower Than Their Department Average

   Part - 13

Click below for you tube Answer

In the above query there are 3 parts:

Part 1: Deriving the average salary of the department

Part 2: Joining the tblEmployee table to the derived table on Department id

Part 3: Applying the filter condition to pick employees whose salary is less than average dept salary