如何检索过去特定时间的标签数

Question

我可以在这里看到如何通过StackExchange API获取标签数量。是否可以获取过去某个时间的标签数量？

如何使用 BigQuery 运行 https://api.stackexchange.com/2.2/tags?order=desc&sort=popular&inname=java&site=stackoverflow？

Answer 1

可能众多选项之一 - 适用于 BigQuery Standard SQL

#standardSQL
SELECT tag, COUNT(1) AS popular
FROM `bigquery-public-data.stackoverflow.stackoverflow_posts`, 
UNNEST(SPLIT(tags, '|')) AS tag
WHERE DATE(creation_date) 
BETWEEN DATE_SUB(CURRENT_DATE(), INTERVAL 3 YEAR) 
AND DATE_SUB(CURRENT_DATE(), INTERVAL 2 YEAR)
GROUP BY tag
HAVING tag LIKE '%java%'
ORDER BY popular DESC
-- LIMIT 100