Finding a Table's Contents in Another Table using BigQuery -

I have two tables, Table A and Table B:

A data stored in this way Gone is: Data stored in such a way:

  word1 word4 word2 word3  

1 word 1 value 2 word 2 value 3 word 2 value4 word2 value5 word3 value6 word3 value7

What is the query that I can use to create a table in Google BigQuery such as

< Pre> word1 value1 + value2 word2 value3 + value4 + value5 word3 value6 + value7

where words 1, word 2, etc. are string, Su value1, value2, etc. integer?

It seems that you do not have to use Table A for this problem because the word Are also present in Table B And then this directly aggregation query

  SELECT term, SUM (value) from value B