WITH PostHistoryStatus as (
SELECT
ph.PostId,
last_value(ph.Comment) OVER (ORDER BY ph.CreationDate ASC) as Comment,
last_value(ph.PostHistoryTypeId) OVER (ORDER BY ph.CreationDate ASC) as PostHistoryTypeId
FROM
PostHistory ph
WHERE
ph.PostHistoryTypeId = 10
or ph.PostHistoryTypeId = 11
GROUP BY
ph.PostId, ph.Comment, ph.PostHistoryTypeId, ph.CreationDate
)
SELECT
p.PostId,
p.PostId as "Post Link"
FROM
PostHistoryStatus p