Calculates the number of days a user has with questions that have upvotes and there are no downvoted questions and displays progress toward each of the badges
Q&A about the site for information security professionals
select 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