select PostId, count(*)
from PostTags
group by PostId

select avg(cnt) as average
from (select PostId, count(*) as cnt
from PostTags
group by PostId) as pp

SELECT [LastActivityDate], Posts.CreationDate, [LastEditDate]
FROM Posts RIGHT JOIN PostFeedback
ON [PostFeedback].[PostId] = [Posts].[Id]
WHERE [PostTypeId] = 1 AND [Score] <= 0 AND [AnswerCount] > 0
AND [LastEditorUserId] = [OwnerUserId] AND
(
[PostTypeId] = 2 and
Posts.ParentId = [PostFeedback].[PostId]
and Posts.CreationDate < [LastEditDate]
)

select q.id as [Post Link]
     , q.owneruserid as [User Linkl]
     , q.LastEditDate as [Last Edition]
     , a.creationdate as [Answered On]
from posts q
inner join posts a on a.id = q.AcceptedAnswerId
where q.posttypeid = 1 -- Q
and a.posttypeid = 2 -- A
and q.LastEditorUserId = ##userid##
and a.creationdate > q.LastEditDate

select a.ParentId as [Post Link]
from posts a
inner join posts q on q.id = a.ParentID
where q.posttypeid = 1 -- Q
and a.posttypeid = 2 -- A
and q.LastEditorUserId = ##userid##
and q.ClosedDate is null
and q.CommunityOwnedDate is null
and q.AnswerCount < 1