When I tried to select employee fname,lname, salary and the average of the salary it returned the same number for all employee.
here what I typed to query:
SELECT
Fname AS EmployeeFirstName,
Lname AS EmployeeLastName,
Salary AS Sal,
(SELECT AVG(Salary) FROM Employee) AS AverageSalary,
FROM
Employee;
And this is the screenshot of the result:
I want the average be counted for each employee salary, any idea?
You need to sign in to view this answers