Employee Salary Bands — Solution & ExplanationProblems / Employee Salary Bands / EditorialApproachThis problem combines conditional logic with aggregation.

Classify: Use CASE WHEN (SQL) or F.when().otherwise() (PySpark) to map each salary to a band label.

Aggregate: Group by the band label and compute COUNT, AVG (rounded), MIN, MAX.

Order: Sort alphabetically by band name.

Why This Is HardIt requires combining two concepts — conditional column creation and grouped aggregation — in a single query. The PySpark version specifically requires chaining .when() calls correctly.Hints

Use CASE WHEN in SQL or F.when().when().otherwise() in PySpark to create the salary_band column.

Group by the computed salary_band column, then aggregate.

The bands are mutually exclusive: Low < 80k, Mid 80k-120k, High > 120k.

Solve Employee Salary Bands yourself →