Progress towards Curious, Inquisitive and Socratic badges

8

Please login or register to vote for this query.

(click on this box to dismiss)

How far are you towards the Curious, Inquisitive and Socratic badges? You need to count the days on which you had only positive questions, and no downvoted or closed questions. We cannot see deleted questions here so the count is going to be inaccurate, nor does it track your positive question record ratio.

Sports

Q&A for participants in team and individual sport activities

declare @epoch datetime = getdate();

with ask_days as (
  select OwnerUserId,
         dateadd(day, datediff(day, @epoch, CreationDate), @epoch) day,
         min(Score) worst,
         max(Score) best,
         -- only posts closed within 60 days count against qualification
         count(case when ClosedDate is not null and datediff(day, CreationDate, ClosedDate) <= 60 then 1 else null end) closed,
         count(*) N
  from Posts
  where PostTypeId = 1
        and OwnerUserId in (##UserId##)
  group by dateadd(day, datediff(day, @epoch, CreationDate), @epoch),
           OwnerUserId
),

good_days as (
  select OwnerUserId, count(*) N
  from ask_days
  where best >= 1
        and worst >= 0
        and closed = 0
  group by OwnerUserId
),
        
badges as (
  select OwnerUserId, N,
         case
           when N >= 5 then 1
         end curious,
         case
           when N >= 30 then 1
         end inquisitive,
         case
           when N >= 100 then 1
         end socratic
  from good_days
       join Users u on u.Id = OwnerUserId
)

select OwnerUserId as [User Link], N, curious, inquisitive, socratic
from badges
order by N desc;

Enter Parameters

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