Practice Interview Questions
| Question | Status |
|---|---|
Given a table of tweets with their respective hashtags, write a SQL query to find the top K (K=2) most frequently mentioned hashtags in the table.
tweets table:
| Column Name | Description |
|---|---|
| id | Unique identifier for each tweet |
| tweet_text | Text content of the tweet |
| hashtags | Hashtags associated with the tweet |
| hashtag | count |
|---|---|
| #foo |
Given a table of tweets with their respective hashtags, write a SQL query to find the top K (K=2) most frequently mentioned hashtags in the table.
tweets table:
| Column Name | Description |
|---|---|
| id | Unique identifier for each tweet |
| tweet_text | Text content of the tweet |
| hashtags | Hashtags associated with the tweet |
| hashtag | count |
|---|---|
| #foo |
| 3 |
| #bar | 2 |
| 3 |
| #bar | 2 |