Exercise

Department analysis

Your initial analysis impressed the HR team! Now they want to dive deeper into departmental insights. The leadership team is considering budget allocations for next year and needs to understand how salaries are distributed across different departments. They're particularly interested in departments with both high average salaries and a good number of senior employees (age 40+).

The Table, Selection, and aggregate functions (mean, count, max) have been imported for you.

Instructions

100 XP

Summarize "Salary" with mean, count, and max.
Filter for employees aged 40+.
Sort by "Department", then "Salary" descending.

.css-6su6fj{-webkit-flex-shrink:0;-ms-flex-negative:0;flex-shrink:0;}Exercise

Instructions

Exercise