So I’ll take these relationships and I’ll save them on an auxiliary table - plus a percentage of how frequently a relationship happens for each tag. Let’s find tags that usually go together: # Tags with >180 questions since 2018SELECT tag, COUNT(*) questionsFROM `fh-bigquery.stackoverflow_archive.201906_posts_questions`, UNNEST(SPLIT(tags, '|')) tagWHERE creation_date > ''GROUP BY 1HAVING questions>180ORDER BY 2 DESC Hint: Co-occurring tags
0 Comments
Leave a Reply. |