0

Please login or register to vote for this query.

(click on this box to dismiss)

All people who asked more than 20 questions ordered by avg score

Q&A about the site for serious players and enthusiasts of poker

-- The worst question askers
-- All people who asked more than 10 questions ordered by avg score

DECLARE @endDate datetime
SELECT @endDate = max(CreationDate) from Posts

select top 4000 OwnerUserId [User Link], 
  Reputation,
  count(*) [Total Questions],
  avg(CONVERT(int, @endDate - p.CreationDate)) [Avg question age],
  avg((Score + 0.0) / CONVERT(int, @endDate - p.CreationDate)) [Avg question score per day],
  sum(case when Score < 0 then 1 else 0 end) [Negative Scored Questions]
from Posts p
join Users u on u.Id = OwnerUserId 
where ParentId is null AND CONVERT(int, @endDate - p.CreationDate) > 0
group by OwnerUserId, Reputation
having count(*) > 10
order by [Avg question score per day] asc

fork query

edited nov 9 13 anonymous

created jul 13 10 sam.saffron