[SQL] Decode in oracle, with multiple condition

Select decode(a.Type,1,'ONE',2,'TWO',null ,'OTHER')||
Decode (b.Active, 1 ,'Yes',0,'NO', null ,'NO'),
count(*)
from TypeTable a,
Status b
where a.id=b.id
and a.type in(12,3,34,45,66);


Now question is,

I want to count those who has type 1 and other that in record Like

Column1 | Column2
---------------+----------
One | 10
ONE
Other that ONE | 20

Continue reading...