Skip to content

3087. Find Trending Hashtags 👎

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
SELECT
  CONCAT(
    '#',
    SUBSTRING_INDEX(SUBSTRING_INDEX(tweet, '#', -1), ' ', 1)
  ) AS hashtag,
  COUNT(*) AS hashtag_count
FROM Tweets
WHERE MONTH(tweet_date) = 2
GROUP BY hashtag
ORDER BY hashtag_count DESC, hashtag DESC
LIMIT 3;