title: Decode in oracle, with multiple condition
body: <pre><code>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);
  </code></pre>
  
  <p>Now question is,</p>
  
  <p>I want to count those who has type 1 and other that in record
  Like </p>
  
  <pre><code>Column1        |  Column2 
  ---------------+----------
  One            |   10
  ONE                                        
  Other that ONE |   20
  </code></pre>