Modules
Data Analyst
Data Engineer
Product Data Scientist
AI Engineer
Machine Learning Engineer
Prompt Engineer
Based on the work you've already done on the previous practice, using the tweets table, your goal is to find the top 3 most used hashtags. In case of a tie, all hashtags in the top 3 will be included.
The function you will be using is:
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 |
| hashtag |
|---|
| #happy |
Based on the work you've already done on the previous practice, using the tweets table, your goal is to find the top 3 most used hashtags. In case of a tie, all hashtags in the top 3 will be included.
The function you will be using is:
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 |
| hashtag |
|---|
| #happy |
| #exciting |
| #funny |
| #exciting |
| #funny |