Don't touch my junk.

0

Please login or register to vote for this query.

(click on this box to dismiss)

スタック・オーバーフローMeta

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

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

Enter Parameters

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