title: How to create a categorical column from a single column using SQL?
body: <p>I have table with a single column &amp; I want to create a logic from below metrics using SQL</p>
  
  <p>Table:</p>
  
  <pre><code>Site Number | Categorical Column
  43  
  50  
  62  
  88  
  93  
  </code></pre>
  
  <p>My Metrics:</p>
  
  <ul>
  <li>for site number = 43 &amp; 93 then A</li>
  <li>for Site number = 50 &amp; 93 then B</li>
  <li>for Site number = 62 &amp; 93 then C</li>
  <li>for Site number = 50 &amp; 88 then D</li>
  </ul>