Manager vs Individual Contributor Pay

Problem

Return employment_type ('Manager' if they manage someone, else 'IC'), the average salary, and headcount for each group, ordered by employment_type.

Try It

Hint

Solution