How to count occurrences of item in bigquery

Vote count: 0

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):

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]
 )

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.

asked 34 secs ago

song0089

Let's block ads! (Why?)

How to count occurrences of item in bigquery