Employee ID Department Salary

$001$ HR $50000$

$002$ IT $45000$

$003$ HR $40000$

$004$ MKTG $45000$

$005$ IT $50000$

$006$ SALES $60000$

$007$ MKTG $50000$

Using the table shown above, write a query to classify employees into $4$ categories based on their salaries. For each category, find the number of employees. $($Hint: Use MAX$()$ and MIN$()$ to determine the range of the salary$)$