A manager is seeking insights into salary disparaties and wants to identify departments with salaries above and below the average for each department.
Create a SQL query that identifies the average salary for each department as well as the standard deviation. Subsequently use the z-score metric to identify salary outliers for each department.
List from a SQL database with Department, Average Salary, and a way to score variation.
POL Department is suspected of having high amount of variation in salary.