Progress towards Curious, Inquisitive and Socratic badges


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.

Drupal Answers

Q&A for Drupal developers and administrators

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),

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,
           when N >= 5 then 1
         end curious,
           when N >= 30 then 1
         end inquisitive,
           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

Switch to meta site
loading Hold tight while we fetch your results