select datepart(year, posts.creationdate) as year, datep...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

-- Enter Query Title
-- Enter Query Description

select datepart(year, posts.creationdate) as year,
       datepart(month, posts.creationdate) as month, 
       count(*) as questions,
       count(posttags.tagid) as sc
from posts
  left outer join posttags 
    on posttags.postid = posts.id and 
       posttags.tagid = (select id 
                         from tags 
                         where tagname = 'scala')
where posts.posttypeid = 1
group by datepart(month, posts.creationdate), 
         datepart(year, posts.creationdate)
order by datepart(year, posts.creationdate), 
         datepart(month, posts.creationdate)

Enter Parameters

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