Badge progress for Curious, Inquisitive, and Socratic


Please login or register to vote for this query.

(click on this box to dismiss)

For users interested in their badge progress.

Robotics Meta

Q&A about the site for professional robotic engineers, hobbyists, researchers and students

case when days >= 5 then 'Yes' else concat(days, '/', 5) end as Curious,
case when days >= 30 then 'Yes' else concat(days, '/', 30) end as Inquisitive,
case when days >= 100 then 'Yes' else concat(days, '/', 100) end as Socratic
from (select count(*) as days
from (select
datediff(d, creationdate, getdate()) as creationDay,
  sum(case when score > 0 and closeddate is  null  then 1 else 0 end) as up,
  sum(case when score < 1 or closeddate is not null then 1 else 0 end) as down
from Posts
where OwnerUserId = ##UserId##
and PostTypeId = 1
group by datediff(d, creationdate, getdate())
) x
where up > 0 and down = 0
) y

Enter Parameters

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