我有很多专利的申请号，但没有出版物编号 . 出版号对于计算正向引用次数至关重要 . 谁可以帮我一个忙？
SELECT
c.publication_number AS Pub,
COUNT(DISTINCT REGEXP_EXTRACT(p.publication_number, r'(.+-.+)-')) AS CitedByCount
FROM `patents-public-data.patents.publications` AS p,
UNNEST(citation) AS c
WHERE c.publication_number IN (
SELECT publication_number
FROM `patents-public-data.patents.publications`
WHERE application_number IN ('CN-201510747352-A')
)
GROUP BY c.publication_number
我可以使用应用程序编号来获取CitedBy，但结果是Pub和CitedBy . 如何实现结果包含应用程序编号和CitedBy的目的 .