When ask a question to maximize view?

1

Please login or register to vote for this query.

(click on this box to dismiss)

Meta Stack Exchange

Q&A for meta-discussion of the Stack Exchange family of Q&A websites

SELECT
  AVG(CAST(viewCount as Float)) as avgView,
  DATENAME(WEEKDAY, CreationDate) AS DayInWeek
FROM
  Posts p
WHERE 
  PostTypeId = 1
GROUP BY 
  DATENAME(WEEKDAY, CreationDate)
ORDER BY
  avgView desc
;

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results