number of question ask per monday

2

Please login or register to vote for this query.

(click on this box to dismiss)

Interpersonal Skills

Q&A for people looking to improve their interpersonal communication skills

Select 
  CAST(CreationDate as DATE) as DateField, count(p.Id)
FROM
  Posts p
WHERE 
  PostTypeId = 1 and DATENAME(WEEKDAY, CreationDate) = 'Monday'
GROUP BY 
  CAST(CreationDate as DATE)
ORDER BY
  CAST(CreationDate as DATE) desc
--LIMIT 50
;

Enter Parameters

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