Advertisement
Shayrma

Untitled

Feb 13th, 2023
16
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.45 KB | None | 0 0
  1. WITH l AS (SELECT u.id AS user_id,
  2. u.display_name
  3. FROM stackoverflow.posts AS p
  4. JOIN stackoverflow.users AS u ON p.user_id = u.id
  5. JOIN stackoverflow.post_types AS pt ON p.post_type_id = pt.id
  6. WHERE pt.type = 'Answer'
  7. AND CAST(p.creation_date as date ) BETWEEN CAST(u.creation_date as date) AND CAST(u.creation_date as date) + interval '1 month'
  8. )
  9.  
  10. SELECT display_name,
  11. COUNT(DISTINCT user_id)
  12. FROM l
  13. GROUP BY 1
  14. HAVING COUNT(*) > 100
  15. ORDER BY 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement