Using BigQuery from Third-Party Tools - Google BigQuery Analytics - page 572

comedyoferrors ,
SUM(IF (corpus == 'coriolanus', tfidf, 0)) AS
coriolanus ,
SUM(IF (corpus == 'cymbeline', tfidf, 0)) AS cymbeline ,
SUM(IF (corpus == 'hamlet', tfidf, 0)) AS hamlet ,
SUM(IF (corpus == 'juliuscaesar', tfidf, 0)) AS
juliuscaesar ,
SUM(IF (corpus == 'kinghenryv', tfidf, 0)) AS
kinghenryv ,
SUM(IF (corpus == 'kinghenryviii', tfidf, 0)) AS
kinghenryviii ,
SUM(IF (corpus == 'kingjohn', tfidf, 0)) AS kingjohn ,
SUM(IF (corpus == 'kinglear', tfidf, 0)) AS kinglear ,
SUM(IF (corpus == 'kingrichardii', tfidf, 0)) AS
kingrichardii ,
SUM(IF (corpus == 'kingrichardiii', tfidf, 0)) AS
kingrichardiii ,
SUM(IF (corpus == 'loverscomplaint', tfidf, 0)) AS
loverscomplaint ,
SUM(IF (corpus == 'loveslabourslost', tfidf, 0)) AS
loveslabourslost ,
SUM(IF (corpus == 'macbeth', tfidf, 0)) AS macbeth ,
SUM(IF (corpus == 'measureforemeasure', tfidf, 0))
AS measureforemeasure ,
SUM(IF (corpus == 'merchantofvenice', tfidf, 0)) AS
merchantofvenice ,
SUM(IF (corpus == 'merrywivesofwindsor', tfidf, 0))
AS merrywivesofwindsor ,
SUM(IF (corpus == 'midsummersnightsdream', tfidf, 0))
AS midsummersnightsdream ,
SUM(IF (corpus == 'muchadoaboutnothing', tfidf, 0))
AS muchadoaboutnothing ,
SUM(IF (corpus == 'othello', tfidf, 0)) AS othello ,
SUM(IF (corpus == 'periclesprinceoftyre', tfidf, 0))
AS periclesprinceoftyre ,
SUM(IF (corpus == 'romeoandjuliet', tfidf, 0)) AS
romeoandjuliet ,
SUM(IF (corpus == 'tamingoftheshrew', tfidf, 0)) AS