title: Issues finding common bi grams in Big Query
body: <p>I'm trying to apply a query to search down one column (Text) of a table, and to return the most common bi-grams within it.</p>
  
  <p>I came across this query but I'm struggling to manipulate it to fit my dataset:</p>
  
  <pre><code>SELECT word, nextword, COUNT(*) c 
  FROM (
  SELECT pos, title, word, LEAD(word) OVER(PARTITION BY created_utc,title ORDER BY pos) nextword FROM (
  SELECT created_utc, title, word, pos FROM FLATTEN(
    (SELECT created_utc, title, word, POSITION(word) pos FROM
     (SELECT created_utc, title, SPLIT(title, ' ') word FROM [bigquery-samples:reddit.full])
    ), word)
  ))
  WHERE nextword IS NOT null
  GROUP EACH BY 1, 2
  ORDER BY c DESC
  LIMIT 100
  </code></pre>
  
  <p>(The query was orginally written for the Reddit comments dump)</p>
  
  <p>How do I change this query to look down my 'Text' column and nothing else?</p>
  
  <p>I'm a little cofused as to what 'pos' and 'title' refer to - please be patient, I'm new to SQL! :)</p>
  
  <p>Many thanks in advance.</p>