title: How to count occurrences of item in bigquery
body: <p>I am trying to find occurrences of certain phrases in reddit comment bigquery 2015. The phrases were also obtained through running a query. I saved the table results so that the phrases could be accessed (stored in column):</p>
  
  <pre><code>SELECT c
   FROM (
   SELECT title 
   FROM [lucid-bond-156818:bquijob_658cefdf_15a212b8aaf] #the phrases I want to search within reddit comment bigquery
   SELECT COUNT(title) as c in [fh-bigquery:reddit_comments.all_2015]
   )
  </code></pre>
  
  <p>I'm a beginner in SQL so I'm having trouble fixing it, in the last line I basically want to tell the query to count the titles in the reddit comments 2015 data.</p>