title: How to get distinct count along with different conditions
body: <p>My data looks like this,
  <a href="https://i.stack.imgur.com/3T7x0.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/3T7x0.png" alt="enter image description here" /></a></p>
  <p>I've 4 distinct Result category: Normal, Mild, Moderate and Severe</p>
  <p>I want to get count of patients for each categories and
  in case of severe category, I want to further divide it into more categories based on its corresponding Result value (e.g., Severe_500_to_599,  Severe_600_to_699, Severe_700_to_799 and severe_&gt;800) and then get the count of these sub categories.</p>
  <p>So my Results should look like this,
  <a href="https://i.stack.imgur.com/ITySP.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ITySP.png" alt="enter image description here" /></a></p>
  <p>Currently I'm taking individual count by putting the specific condition,</p>
  <pre><code>select count(distinct SOURCE_PATIENT_ID)
  from Table1
  where RESULT_CATEGORY = 'SEVERE' and RESULT_VALUE_STANDARDIZED between '1100' and '1199' and RESULT_UNIT &lt;&gt; 'MG/DL';
  </code></pre>
  <p>Is there any way to get all the results in one single query?</p>
  <p>Thanks!</p>