SQL QUERY

Question

Display employee name,salary and a remark as alias for (HIGH in case salary greater than 1.5 lac,AVERAGE for salary between 1 to 1.5 lac,and LOW for others).....thanks in advance ....plz help me

Answer 1

SELECT Name, Salary
CASE WHEN salary between 100000 and 150000 THEN 'Avg'
WHEN salary<150000 THEN 'High'
ELSE 'Low' END
FROM customers;