Problem Statement

For every job title, return employee_count, min_salary, max_salary across employees in that job. INCLUDE jobs with zero employees (their counts should be 0 and salary columns NULL). Sort by employee_count descending, then job_title ascending.

Relevant Tables