Problem Statement

For each job, compare the configured salary range (min_salary, max_salary) with the actual range of employees holding that job (actual_min, actual_max). Return job_id, job_title, employee_count, min_salary, max_salary, actual_min, actual_max — ordered by employee_count DESC, job_id.

Relevant Tables