Q&A about the site for information security professionals
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