This technical problem involves writing a SQL query to find the average salary of employees by department. The example input table includes columns for department, first name, last name, and salary. The expected output is a table with columns for department and average salary.
This solution is complete and solves the problem. The approach is straightforward and easy to follow.
Evaluated at: 2022-11-23 04:16:24