title: Teradata - word frequency in a column
body: <p>Say I have the following column in a teradata table:</p>
  
  <pre><code>Red ball
  Purple ball
  Orange ball
  </code></pre>
  
  <p>I want my output to be </p>
  
  <pre><code>Word    Count
  Red     1
  Ball    3
  Purple  1
  Orange  1
  </code></pre>
  
  <p>Thanks.</p>