title: SQL Distinct Values?
body: <p>I need your help with a query, I've looked around but can not find what I need.</p>
  
  <p>Here's my table.</p>
  
  <pre><code>items   status  range
  item1   A   1
  item1   A   2
  item1   A   15
  item1   A   38
  item1   A   451
  item1   A   110
  item1   A   112
  item2   A   38
  item2   A   451
  item3   A   1
  item3   A   2
  item3   A   110
  item3   A   112
  item3   A   120
  item4   A   451
  item5   A   451
  item5   A   110
  item5   A   112
  item6   A   110
  item6   A   111
  item6   A   115
  </code></pre>
  
  <p>Here is the intended result:</p>
  
  <pre><code>items   result
  item1   common
  item2   conv
  item3   common
  item4   conv
  item5   ms
  item6   ms
  </code></pre>
  
  <p>Here's the conditions:</p>
  
  <pre><code>range 38 or/and 451 - CONV
  range between 110 and 115 - MS
  others - Common
  </code></pre>
  
  <p>Thank you!!</p>