title: Different value counts on same column
body: <p>I am new to Oracle. I have an Oracle table with three columns: <code>serialno</code>, <code>item_category</code> and <code>item_status</code>. In the third column the rows have values of <code>serviceable</code>, <code>under_repair</code> or  <code>condemned</code>.  </p>
  
  <p>I want to run the query using count to show how many are serviceable, how many are under repair, how many are condemned against each item category.</p>
  
  <p>I would like to run something like:</p>
  
  <pre><code>select item_category
    , count(......) "total"
    , count (.....) "serviceable"
    , count(.....)"under_repair"
    , count(....) "condemned"
  from my_table
  group by item_category ......
  </code></pre>
  
  <p>I am unable to run the inner query inside the count.</p>
  
  <p>Here's what I'd like the result set to look like:</p>
  
  <pre><code>item_category    total    serviceable      under repair      condemned
  =============    =====    ============     ============      ===========
  chair              18        10               5                3
  table              12        6                3                3 
  </code></pre>