Advertisement
Guest User

Untitled

a guest
Aug 24th, 2019
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.55 KB | None | 0 0
  1. rockset> SELECT
  2. user.user.name
  3. FROM
  4. twitter_collection AS col,
  5. UNNEST(col.entities.user_mentions AS user) AS user
  6. WHERE
  7. typeof(user.user.name) = 'string'
  8. GROUP BY
  9. user.user.name
  10. ORDER BY
  11. COUNT(*) DESC
  12. LIMIT 5;
  13. +---------------------+
  14. | name |
  15. |---------------------|
  16. | 방탄소년단 |
  17. | Michelle Obama |
  18. | H.E.R. |
  19. | lego |
  20. | BT21 |
  21. +---------------------+
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement