Count by User

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select u.DisplayName, a.OwnerUserId, count(distinct a.Id) as AnswerCount from posts a, posts q, users u
where a.ParentId = q.Id
and a.OwnerUserId = u.Id 
and q.Tags like '%<##tag?amazon-sagemaker##>%'
and a.CreationDate >= '2023-01-01' 
and a.CreationDate < '2023-09-26'
and a.PostTypeId = 2
group by a.OwnerUserId, u.DisplayName order by AnswerCount desc;

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results