79129643

Date: 2024-10-26 23:29:14
Score: 0.5
Natty:
Report link

You shall use GROUP BY clause.

SELECT 
    Fname AS EmployeeFirstName, 
    Lname AS EmployeeLastName, 
    AVG(Salary) AS Sal
FROM  Employee
GROUP BY employeeId; -- Replace this by the column id specific to the employees

Note: You'll need to set sql_mode to "only_full_group_by" or "" (empty)

Reasons:
  • Low length (0.5):
  • Has code block (-0.5):
  • Low reputation (0.5):
Posted by: Mike