Django vs. Ruby-on-Rails

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

select 
cast(year(p.creationDate) as varchar(4)) + '-' + cast(month(p.creationDate) as varchar(2)), t.TagName, count(p.ID) as 'numPosts'
from POSTS as p, Tags as t, PostTags as pt
where pt.PostId = p.ID AND pt.TagId = t.id 
      AND t.TagName in ('python', 'nodejs', 'javascript', 'django')
group by t.TagName, year(p.creationDate), month(p.creationDate)
order by year(p.creationDate), month(p.creationDate)

Enter Parameters

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