0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for those interested in the geology, meteorology, oceanography, and environmental sciences

with user_list as (
select
  Id
from
  Users a
where
    CreationDate < dateadd(month, -6, getdate())
)

, comment as (
select distinct
  PostId
  ,UserId
from 
  comments
where
  UserId in (select * from user_list)
)


select 
  UserId
  ,count(PostId) count_posts
from 
  comments
group by
  UserId
having
  count(PostId) >= 10
order by
  count(PostId) desc

fork query

created oct 29 anonymous