Modules
Data Analyst
Data Engineer
Product Data Scientist
AI Engineer
Machine Learning Engineer
Prompt Engineer
Your goal is to analyze the usage of hashtags in tweets from the tweets table. The table contains data about various tweets, each potentially including multiple hashtags.
Write a SQL query to calculate the frequency (the number of times) of each hashtag.
Hint: The hashtags are delimited by 1 or more spaces
The function you will be using is: (I know it's hard to remember it)
regexp_split_to_table(column_name, pattern)
tweets table:
| Column Name | Description |
|---|---|
| tweet_id | Unique identifier for each tweet |
| content | Text of the tweet, containing hashtags |
Your goal is to analyze the usage of hashtags in tweets from the tweets table. The table contains data about various tweets, each potentially including multiple hashtags.
Write a SQL query to calculate the frequency (the number of times) of each hashtag.
Hint: The hashtags are delimited by 1 or more spaces
The function you will be using is: (I know it's hard to remember it)
regexp_split_to_table(column_name, pattern)
tweets table:
| Column Name | Description |
|---|---|
| tweet_id | Unique identifier for each tweet |
| content | Text of the tweet, containing hashtags |