Q&A for people interested in all aspects of producing and consuming coffee
select top 100 u.id as [User Link] , sum(p.score) [Total] , sum(case when p.posttypeid = 1 then p.score else null end) [Total Q] , sum(case when p.posttypeid = 2 then p.score else null end) [Total A] , count(*) [# posts] from users u inner join posts p on p.owneruserid = u.id inner join posts q on q.id = nullif(p.parentid, p.id) inner join posttags pt on pt.postid = q.id inner join tags t on t.id = pt.tagid where u.location like concat('%', ##country:string?Greece##, '%') and t.tagname = ##tag:string?node.js## group by u.id order by sum(p.score) desc