select datepart ( [dw] , [creationdate] ) as [alias_c_1] ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Audio-Video Production Meta

Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation

select datepart ( [dw] , [creationdate] ) as [alias_c_1] , datepart ( [hh] , [creationdate] ) as [alias_c_2] , count ( * ) as [alias_c_3] 
from [posts] 
where [creationdate] > '20170101' group by datepart ( [dw] , [creationdate] ) , datepart ( [hh] , [creationdate] ) 
order by [alias_c_1] , [alias_c_2]

Enter Parameters

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