**Task**

Print all the employee numbers, name and salary. With the salary also print the category based on following criteria: LOW if salary is less than 900, MEDIUM if salary is less than 1500 and HIGH if greater than 1500.

**Attempted Query**

```
select ename ,sal , decode ( sign (sal - 900) , -1 , 'Low' ,
1 ,'Medium'   ) from emp;

```

My course teacher tell us using DECODE function write a query.

**Q )** How to achieve this by using decode function