select year(creationdate) as yr, month(creationdate) as m...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Computer Science Educators

Q&A for those involved in the field of teaching Computer Science

select year(creationdate) as yr, month(creationdate) as mth, coalesce(count(*), 0)
from posts as curr
group by year(curr.creationdate), month(curr.creationdate)
order by year(curr.creationdate), month(curr.creationdate)


--join 
--     (select year(creationdate) as yr, month(creationdate) as mth, coalesce(count(*), 0) as count
--      from posts
--     group by year(creationdate), month(creationdate)) as prev
--      on curr.yr = prev.yr and
--      curr.mth = prev.mth + 1

Enter Parameters

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