Contributing Users by Month

0

Please login or register to vote for this query.

(click on this box to dismiss)

Christianity

Q&A for committed Christians, experts in Christianity and those interested in learning more

select
  count(distinct Id) as count,
  Location
from Users
where Id in(
  select OwnerUserId
  from Posts
  where CreationDate >= '2008-08-01' and CreationDate < '2019-06-01'
union
  select UserId
  from Comments
  where CreationDate >= '2008-08-01' and CreationDate < '2019-06-01'
)
group by Location
order by count desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results