Write an SQL query on the EMPLOYEE table to find the employees who work in a department where the average salary is lower than the average salary of…

Write an SQL query on the EMPLOYEE table to find the employees who work in a department where the average salary is lower than the average salary of all departments.

From the BPDB Assistant Engineer (CSE) February 2023 – Written (BUET) exam, question 34 of 37.

More from this paper