1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

with Dates as (
select cast(DatePart(year, CreationDate) as float) 
     + cast(DatePart(dw, CreationDate) as float)/10 as YearDay
from Votes
)
select YearDay,
       Count(*) as Count
from Dates
group by YearDay
order by YearDay

fork query

edited jun 12 15

created jun 12 15 rolfl