Employee ID Department Salary 0 0 1 HR 5 0 0 0 0 0 0 2 IT
Fantastic news! We've Found the answer you've been seeking!
Question:
Employee ID Department Salary
HR
IT
HR
MKTG
IT
SALES
MKTG
Using the table shown above, write a query to classify employees into 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
Posted Date: