Closed Questions

0

Please login or register to vote for this query.

(click on this box to dismiss)

Puzzling

Q&A for those who create, solve, and study puzzles

select
/*  u.Id as [User Link],
  count(q.Id) as QCount*/
  Title, Id, ClosedDate, Tags, OwnerDisplayName
from Posts q
/*from Users u
inner join Posts q on q.OwnerUserId = u.Id
--inner join Posts a on q.AcceptedAnswerId = a.Id*/
where
/*  q.PostTypeId = 1*/
  ClosedDate IS NOT NULL
  and q.ClosedDate > ##from:string##
  and q.ClosedDate < ##to:string##
/*group by u.Id*/
order by q.ClosedDate

Enter Parameters

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