Hi,
I needed to print salary along with extended column which stating where EACH salary is below, above or on the average salary. Here is my code:
select salary,
case when salary < avg(salary) then 'Below Average'
when salary = avg(salary) then 'On Average'
when salary > avg(salary) then 'Above Average'
else 'NA'
end result_avg
from employees;
Thanks for your support in advance.