What is the purpose of this query?
SELECT Name,
CASE
WHEN Salary 10000 THEN 'High'
WHEN Salary BETWEEN 5000 AND 10000 THEN 'Medium'
ELSE 'Low'
END AS SalaryLevel
FROM Employees;

Question

What is the purpose of this query? 
 SELECT Name,   
   CASE   
     WHEN Salary > 10000 THEN 'High'   
     WHEN Salary BETWEEN 5000 AND 10000 THEN 'Medium'   
     ELSE 'Low'   
   END AS SalaryLevel   
 FROM Employees;

Accepted Answer

It groups employees into categories based on salary

Answer

It updates the salary levels of employees

Answer

It raises salary for some employees

Answer

It removes employees with low salary

Crowdly

What is the purpose of this query? SELECT Name, CASE WHEN Salary...

Want instant access to all verified answers on lms.musteducation.tn?