语法错误：预期输入结束，但在类项目的 [9：5] 处获得字符串文本'ynet.co.il'

Question

处理类项目。我们被要求找出以色列所有大新闻网站的提及次数。我对最后一部分(粗体(有意见。语法错误：应为输入结尾，但在[9:5]处得到字符串文本"ynet.co.il">

我将非常感谢你的帮助。

REATE OR REPLACE TABLE
`static-beach-312816.56146_2021_class_materials.israel_media` AS
SELECT
*
FROM
`gdelt-bq.gdeltv2.gkg_partitioned`
WHERE
SourceCommonName IN ('israelhayom.co.il',
'ynet.co.il',
'walla.co.il',
'haaretz.co.il')
AND LOWER(TranslationInfo) LIKE '%heb%';
CREATE OR REPLACE TABLE
`static-beach-312816.56146_2021_class_materials.israel_media_person` AS
SELECT
date,
SourceCommonName AS domain,
DocumentIdentifier AS url,
REGEXP_REPLACE(person, r',.*', " ") AS person
FROM
`static-beach-312816.56146_2021_class_materials.israel_media`,

UNNEST(SPLIT(V2Persons,';')) AS person ;
CREATE OR REPLACE TABLE
`static-beach-312816.56146_2021_class_materials.israel_media_person_sum` AS
SELECT
date,
domain,
url,
person,
COUNT(1) AS count_of_mentions
FROM
`static-beach-312816.56146_2021_class_materials.israel_media_person`
GROUP BY
date,
domain,
url,
person ;
SELECT
person,
SUM(count_of_mentions) AS all_mentions
FROM
`static-beach-312816.56146_2021_class_materials.israel_media_person_sum`
WHERE
domain=
'israelhayom.co.il'
'ynet.co.il'
'walla.co.il'
'haaretz.co.il'
GROUP BY
person`enter code here`
ORDER BY
all_mentions DESC
LIMIT
50;

Answer 1

试试这个：

CREATE OR REPLACE TABLE
`static-beach-312816.56146_2021_class_materials.israel_media` AS
SELECT
*
FROM
`gdelt-bq.gdeltv2.gkg_partitioned`
WHERE
SourceCommonName IN ('israelhayom.co.il',
'ynet.co.il',
'walla.co.il',
'haaretz.co.il')
AND LOWER(TranslationInfo) LIKE '%heb%';
CREATE OR REPLACE TABLE
`static-beach-312816.56146_2021_class_materials.israel_media_person` AS
SELECT
date,
SourceCommonName AS domain,
DocumentIdentifier AS url,
REGEXP_REPLACE(person, r',.*', " ") AS person
FROM
`static-beach-312816.56146_2021_class_materials.israel_media`,
UNNEST(SPLIT(V2Persons,';')) AS person ;
CREATE OR REPLACE TABLE
`static-beach-312816.56146_2021_class_materials.israel_media_person_sum` AS
SELECT
date,
domain,
url,
person,
COUNT(1) AS count_of_mentions
FROM
`static-beach-312816.56146_2021_class_materials.israel_media_person`
GROUP BY
date,
domain,
url,
person ;
SELECT
person,
domain,
SUM(count_of_mentions) AS all_mentions
FROM
`static-beach-312816.56146_2021_class_materials.israel_media_person_sum`
WHERE
domain IN ('israelhayom.co.il',
'ynet.co.il',
'walla.co.il',
'haaretz.co.il')
GROUP BY
person,
domain
ORDER BY
all_mentions DESC
LIMIT
50;