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
- Previous: Fill up the following protocol table by work at which layer? Protocol name Layer Carrier-Sense Multiple Access (CSMA) ? Open Shortest Path…
- Next: BPDB can provide service one customer at a time. BPDB want to provide service multiple customers at same time. If n number of customer at…
- All questions in BPDB Assistant Engineer (CSE) February 2023 – Written (BUET)