Problem Statement

For each department compute salary_range = MAX(salary) − MIN(salary), then keep only those over $20,000 (and only departments that actually have employees). Return department_id, department_name, salary_range — ordered by salary_range DESC, department_id.

Relevant Tables