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.

History of Science and Math

Q&A for people interested in the history and origins of science and mathematics

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 meta site
loading Hold tight while we fetch your results