title: Counts of words vs occurrences in snowflake
body: <p>How can I find the number of occurrences vs their counts in a string using snowflake?</p>
  <p>Eg: Hello Hello Hello how are you.</p>
  <p>The expected output should be</p>
  <pre><code>word count(*) 
  Hello 3 
  How 1 
  are 1 
  you 1 
  .   1
  </code></pre>