https://meta.stackoverflow.com/q/316413
Q&A for students, teachers, polyglots, and anyone interested in the techniques of second-language acquisition
select u.DisplayName ,sum( case when posttypeid = 1 then 1 else null end) as Questions ,sum( case when posttypeid = 2 then 1 else null end) as Answers ,sum( case when posttypeid in (1,2) then 1 else null end) as Total ,sum(sum( case when posttypeid = 1 then 1 else null end)) over () as TotalQuestions ,sum(sum( case when posttypeid = 2 then 1 else null end) ) over () as TotalAnswers from posts p inner join posttags pt on pt.postid = coalesce(p.parentid, p.id) inner join tags t on t.id = pt.tagid inner join Users u on p.OwnerUserId = u.Id where t.TagName = 'machine-learning'and ( lower(u.Location) like '%saudi%' or lower(u.Location) like '%saudi arabia%' ) group by u.DisplayName