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
  CONVERT(VARCHAR(10), creationDate, 111) as creationDay,
  sum(case when score > 0 then 1 else 0 end) as up,
  sum(case when score < 1 then 1 else 0 end) as down
from Posts
where OwnerUserId = ##UserId##
and PostTypeId = 1
group by CONVERT(VARCHAR(10), creationDate, 111) 
) x
where up > 0 and down = 0
) y

Enter Parameters

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