Q&A for linguists, teachers, students and Spanish language enthusiasts in general wanting to discuss the finer points of the language
select *, 1.0*score/sqrt(posts) as s_p, score*posts as sp from (select tagname, sum(score) as score, count(*) as posts from --* from ((SELECT t.TagName, a.Score as Score FROM Posts a INNER JOIN Posts q ON q.Id=a.ParentId INNER JOIN PostTags pt ON q.Id = pt.PostId INNER JOIN Tags t ON pt.TagId = t.Id WHERE (a.OwnerUserId=##userid##) AND (a.CommunityOwnedDate IS NULL)) UNION all SELECT t.TagName, 0 as Score FROM Posts q INNER JOIN PostTags pt ON q.Id = pt.PostId INNER JOIN Tags t ON pt.TagId = t.Id WHERE (q.OwnerUserId=##userid##) AND (q.parentid is null) AND (q.CommunityOwnedDate IS NULL) ) bb GROUP BY Tagname )d ORDER BY Score DESC