Advertisement
Pavel_Step

Untitled

Jul 6th, 2024
101
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT u.display_name,
  2.        COUNT(ps.user_id) AS cnt
  3. FROM stackoverflow.posts AS p
  4. LEFT OUTER JOIN stackoverflow.users AS u ON p.user_id = u.id
  5. LEFT OUTER JOIN stackoverflow.post_types AS pt ON p.post_type_id = pt.id
  6. LEFT OUTER JOIN stackoverflow.posts AS ps ON p.parent_id = ps.id
  7. WHERE pt.type = 'Answer'
  8.   AND p.creation_date <= u.creation_date + INTERVAL '1 months'
  9. GROUP BY u.display_name
  10. HAVING COUNT(p.id) > 100
  11. ORDER BY u.display_name ASC;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement