Q&A for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry
--select count (Badges.UserId), Users.Id, Users.DisplayName, Users.Location --from Badges, Users --where Badges.UserId=Users.Id --and Users.Location='Latvia' --group by count (Badges.UserId) --having count (Badges.UserId)>100 SELECT Users.Id, Users.DisplayName, Users.Location, Badges.UserId, Posts.CreationDate, count(*) FROM Users, Badges, Posts WHERE Users.Id=Badges.UserId AND Users.Id=Posts.OwnerUserId AND Users.Location='Latvia' AND Posts.CreationDate LIKE '%2021%' GROUP BY Users.Id, Users.DisplayName, Users.Location, Badges.UserId, Posts.CreationDate HAVING COUNT(*)>100