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.
Tables
departments
dept_idinteger
dept_namevarchar
locationvarchar
emp_projects
emp_idinteger
project_idinteger
rolevarchar
hours_per_weekinteger
employees
emp_idinteger
first_namevarchar
last_namevarchar
emailvarchar
dept_idinteger
manager_idinteger
job_titlevarchar
salaryinteger
hire_datedate
cityvarchar
gendervarchar
projects
project_idinteger
project_namevarchar
dept_idinteger
budgetinteger
start_datedate
end_datedate
Hints(0/2)
Solution
Unlocks after you solve it or after 3 submissions
SQL (DuckDB)
Ctrl + Enter to runLog in to save progress and earn XP