Create a view dept_kpis with one row per department (all 6, even with no staff): dept_name, headcount, avg_salary (rounded to 0 decimals) and max_salary. Departments with no staff show headcount 0.
Each hint gives a little more help. Try on your own first.
Run your code to see the output here.