Users who posted during private Beta

0

Please login or register to vote for this query.

(click on this box to dismiss)

Code Golf and Coding Challenges

Q&A for programming puzzle enthusiasts and code golfers

select
  U.Id as [User Link],
  U.Reputation as Reputation,
  Count(distinct P.Id) as [Posts During Beta]
from
  Users U
  join Posts P on P.OwnerUserId = U.Id
where
  U.Id between 1 and 258 and
  p.CreationDate between '2011-01-27' and '2011-02-03'
group by
  U.Id, U.Reputation
order by
  Reputation
  desc

Enter Parameters

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