0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for anime and manga fans

select year(p.CreationDate), month(p.CreationDate), count(*)
from Tags t left join PostTags pt on t.Id = pt.TagId
            left join Posts p on pt.PostId = p.Id
where (Upper(t.TagName) like '%DELPHI%') or
      (Upper(t.TagName) like '%RAD STUDIO%') or
      (Upper(t.TagName) like '%PASCAL%')
group by year(p.CreationDate), month(p.CreationDate)
order by 1, 2

fork query

created oct 23 11 jon.doe6773