Progress towards Curious, Inquisitive and Socratic badges

10

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.

Ukrainian Language Meta

Q&A about the site for linguists, teachers and students of the Ukrainian language

declare @epoch datetime = getdate();

with ask_days as (
  select OwnerUserId,
         dateadd(day, datediff(day, @epoch, CreationDate), @epoch) day,
         min(Score) worst,
         max(Score) best,
         count(ClosedDate) closed,
         count(*) N
  from Posts
  where PostTypeId = 1
        and OwnerUserId in (##UserId##)
        and ClosedDate is null
  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 N/100
         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 to main site
loading Hold tight while we fetch your results