Skip to Main Content

Expression inside selected column name

User_Q7M0YApr 3 2022

I want to get an average salary of all employees. The query itself is rather simple:
image.pngI'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.

Comments
Post Details
Added on Apr 3 2022
2 comments
22 views