The Data Explorer does not have (enough) information about deleted posts, which do play a role in the badge determination. Most people qualifying for multiple Socratic badges won't have that much deleted questions to begin with; if you know you have one or more which influence the determination, just subtract that number from the # of days produced by this SEDE query.
This is my progress on Meta ...
... last Sunday (SEDE refreshes once a week on Sunday morning). It's a little bit outdated right now.
For reference, here is the complete query:
-- Note: SEDE doesn't include (enough) information about deleted posts
-- to take the full criteria described here:
-- https://meta.stackexchange.com/q/234259/295232
-- into account.
CREATE TABLE #questions (CreationDate DATETIME, Score INT, Closed BIT);
INSERT INTO #questions
SELECT DATEADD(DAY, DATEDIFF(DAY, 0, CreationDate), 0), Score,
CASE WHEN ClosedDate IS NULL THEN 0 ELSE 1 END
FROM Posts
WHERE OwnerUserId = ##UserId:int##
AND PostTypeId = 1
SELECT 'Question record score (needs to be >= 0.5)',
CASE WHEN (SELECT COUNT(*) FROM #questions) = 0 THEN NULL ELSE
ROUND(((SELECT COUNT(*) FROM #questions)
- (SELECT COUNT(*) FROM #questions WHERE Score < 0)
- (SELECT COUNT(*) FROM #questions WHERE Closed = 1))
/ CAST((SELECT COUNT(*) FROM #questions) AS FLOAT), 2)
END
UNION ALL
SELECT 'Days with well-received questions',
(SELECT COUNT(DISTINCT(p.CreationDate))
FROM #questions AS p
LEFT OUTER JOIN #questions AS n ON p.CreationDate = n.CreationDate
AND n.Score < 0
LEFT OUTER JOIN #questions AS c ON p.CreationDate = c.CreationDate
AND c.Closed = 1
WHERE p.Score > 0
AND p.Closed = 0
AND n.CreationDate IS NULL
AND c.CreationDate IS NULL)
(Community Wiki questions do count towards this badge, I've checked this on my Meta Stack Overflow account.)
JeffsBoolCounter
.