0

Please login or register to vote for this query.

(click on this box to dismiss)

プログラマーと熱狂的なプログラマーのためのサイトに関する質問と回答

select u.Id as [User Link], Count (p.Id)
from Users u, Posts p
where p.OwnerUserId = u.id
and u.CreationDate >= '1 Nov 2013' and u.CreationDate < '1 Dec 2013'
  and p.CreationDate > '1 Feb 2014'
group by u.id
order by count (*) desc

view current version

edited apr 19 14

created jan 17 14 rolfl