Question $1(5$ points$)$

Saved

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 MAXI$)$ and MINI$)$ to determine the range$$of$$the$$salary