I want to get an average salary of all employees. The query itself is rather simple:
I've been wondering: is it possible to move COUNT(salary) to selected column's title (after `AS` statement), so the name of the column will be "Average salary of 20 employees"?
I've been trying several approaches, but none of them worked. I would really appreciate any help. Thank you in advance.