Q&A for meta-discussion of the Stack Exchange family of Q&A websites
SELECT DATEPART(weekday, p.CreationDate) FROM Users u JOIN Posts p ON p.OwnerUserId = u.Id WHERE p.CreationDate > DATEADD(day, -364, GETUTCDATE()) AND ABS(DATEDIFF(day, u.CreationDate, p.CreationDate)) < 7 GROUP BY DATEPART(weekday, p.CreationDate)