0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for scientists using computers to solve scientific problems

select distinct u.Id,
       u.DisplayName,
       u.Location,
	   count(b.ID)
from Users u
join Badges b on u.Id=b.UserID and u.Location like '%Latvia%' 
join Posts p on u.Id=p.OwnerUserId 
		and p.CreationDate >= '2021-01-01 00:00:00' 
		and p.CreationDate < '2022-01-01 00:00:00'  
group by u.ID, u.DisplayName,u.Location, p.CreationDate
having count(b.ID) > 100
order by count(b.ID) desc

view current version

edited jun 3 23

created jun 3 23 anonymous