Problem Statement

Produce a single result combining department-level and job-level aggregates. For each, return analysis_type ('Department Analysis' / 'Job Analysis'), category (department_name or job_title), total_count (# of employees), avg_value (rounded 2). Departments with zero employees still appear (count 0, avg 0). Order by analysis_type, category.

Relevant Tables