https://meta.stackoverflow.com/q/316413
Q&A about the site for users of Wolfram Mathematica
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(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##