Puzzles You May Have Missed

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 top(30) q.Id as [Post Link], q.OwnerUserId as [User Link],
(1.0 * q.Score * q.Score/q.ViewCount) as Rank,
q.Score, q.ViewCount, 
q.Tags, q.CreationDate,
q.AnswerCount, SUM(p.Score) as AScore
from Posts q
inner join Posts p
on p.ParentId = q.Id
where q.PostTypeId = 1
and q.AcceptedAnswerId is not null
and q.Score > 0
and q.ViewCount < 500
and q.CreationDate > DATEFROMPARTS(##year?2016##,##month?01##,01) 
and q.CreationDate < DATEADD(dd, -1, DATEADD(mm, 1, DATEFROMPARTS(##year?2016##,##month?01##,01)))
group by q.Id, q.OwnerUserId, q.CreationDate, q.Tags, q.Score, q.ViewCount, q.AnswerCount, p.ParentId
order by Rank desc

Enter Parameters

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