title: how to decode with multiple conditions with same condition with diff result
body: <p>I have a question, how can i evaluate a sql, when id=5 in the case of 'Directory Assistance' it should get the attr_1 as an output and with id=5 and 'Long Roaming' it should give attr_35/60.</p>
  
  <pre><code>sum(decode(id,1,attr_35 / 60,
          5,'Long Roaming',attr_35/60,
          5,'Directory Assistance',attr_1))total
  
  
  with ce as 
  (
  select case
      when id = 1 and attr_31 like 'Roam%' 
           then 'A1'
      when id = 5 and attr_30 like 'Dir%' and attr_31 like 'Standard%'
          then 'Directory Assistance'
      when id = 5 and attr_30 like 'Dir%' and attr_31 like 'Roam%'
           then 'Directory Assistance Roaming'
      when id = 5 and attr_30 like 'Long Distance%' and attr_31 like 'Roam%'
          then 'Long Roaming' 
      end usagetype
  
      , sum(decode(id,1,attr_35 / 60, 5,attr_35/60)) total
      from table
        where ce.account_num in ('A4','A5','A6')
  
      group by
      case
       when id = 1 and attr_31 like 'Roam%'
          then 'A1'
      when id = 5 and attr_30 like 'Dir%' and attr_31 like 'Standard%'
          then 'Directory Assistance'
      when id = 5 and attr_30 like 'Dir%' and attr_31 like 'Roam%'
          then 'Directory Assistance Roaming'
      when id = 5 and attr_30 like 'Long Distance%'and attr_31 like 'Roam%'
          then 'Long Roaming' 
      end
      )
  select usagetype,total from ce
  </code></pre>