Do i have to use a subquery, if yes then how?
I have an emp table in scott schema and i have to find out the names of employees whose annual salary is lesser than the average salary in their department.
The structure of the table is as follows:
EMPNO NOT NULL NUMBER(4)
Life is an endless journey towards perfection