Q&A about the site for the craft of professional writing, including fiction, non-fiction, technical, scholarly, and commercial writing
--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.Location, Badges.UserId, Badges.Name FROM Users, Badges WHERE Users.Id=Badges.UserId AND Users.Location='Latvia' AND Badges.Name='Editor'