title: count of id on status coloumn with sum of particular rows count using GROUP BY IN MYSQL
body: <p>I am having the following mysql table </p>
  
  <pre><code>id  status
  ------------
  1   available
  2   hold
  3   available
  4   so-hold
  5   so-hold
  6   hold
  7   hold
  8   available
  </code></pre>
  
  <p>When I use <code>GROUP BY</code> on <code>STATUS</code> coloumn I got the following :</p>
  
  <pre><code>count(id)   status
  ---------------------
  3           available
  3           hold
  2           so-hold
  </code></pre>
  
  <p>Under <code>status</code> coloumn <strong>'hold'</strong> and <strong>'so-hold'</strong> belongs to the same category so I need count in the following manner : </p>
  
  <pre><code>count(id)   status
  ---------------------
  3           available
  5           hold
  </code></pre>
  
  <p>Following is the MySQL query that I am using currently :</p>
  
  <pre><code>SELECT count(id), status FROM `inventory_master` GROUP BY status
  </code></pre>