title: SQL Plus "case" keyword
body: <p>Can anyone help me with the proper syntax for a "case" statement using SQL Plus?</p>
  
  <pre><code>Select 
  sum(case "REQUEST AGE" when &gt;= 60 then 1 else 0) as "60+ Days",
  sum(case "REQUEST AGE"  when &gt;= 30 and case when "REQUEST AGE" &lt; 60 then 1 else 0) as "30-    60 Days",
  sum (case "REQUEST AGE" when &lt; 30 then 1 else 0) as "Less Than 30 Days",
  "SECTOR"
  FROM Schema.APPDATA
  Where Schema.APPDATA."SECTOR" like '%X%'
  </code></pre>
  
  <p>I'm relatively new to SQL and I have never written such a query. I would like a sum of a case when the column request age is greater than 60, between 30 and 60 and less than 30 as 3 columns grouped by column sector</p>