0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for gardeners and landscapers

select sum( case when posttypeid = 1 then 1 else null end)  [Questions]
     , sum( case when posttypeid = 2 then 1 else null end)  [Answers]
     , sum( case when posttypeid  in (1,2) then 1 else null end)  [Total]
     , sum( case when posttypeid = 1 then commentcount else 0 end)  [Q-cmts]
     , sum( case when posttypeid = 2 then commentcount else 0 end)  [A-cmts]
     , sum( case when posttypeid  in (1,2) then commentcount else 0 end)  [Tot-cmts]
     , sum( case when posttypeid = 1 then cast(Favoritecount as bigint) else null end)  [Tot-Bookmarked]
     , sum( case when posttypeid = 1 then cast(Viewcount as bigint) else null end)  [Tot-Views]
from posts p
inner join posttags pt on pt.postid = coalesce(p.parentid, p.id)
inner join tags t on t.id = pt.tagid
where t.tagname = ##tag:string?ironpython##

fork query

created mar 29 23 anonymous