title: Count unique values from duplicates
body: <p>I have following data on the table.</p>
  
  <pre><code>Uid | comm | status
  -------------------
  12    23     eve
  15    23     eve
  20    23     mon
  12    23     mon
  20    23     eve
  17    23     mon
  </code></pre>
  
  <p>how do i query to get below result to avoid duplicates and make sure if i count uid for "eve" and same uid appears on "mon" then count only uid for "eve"?</p>
  
  <pre><code>count | status
  -------------------
  3         eve
  1         mon
  </code></pre>
  
  <p>Thanks for the help!</p>