On what days were this user's comments posted this year?

0

Please login or register to vote for this query.

(click on this box to dismiss)

Sports

Q&A for participants in team and individual sport activities

SELECT 
  COUNT(*) AS "number",
  DATEPART(weekday, q.CreationDate) AS "day of week" -- 1 = Sunday
FROM Comments q
WHERE q.UserId = ##UserId:int##
  AND DATEPART(year, q.CreationDate) >= 2019
GROUP BY DATEPART(dw, q.CreationDate)

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results