0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for serious players and enthusiasts of chess

SELECT
Posts.PostTypeId as PostTypeId,
min(PostTypes.Name) as Name,
COUNT(*) as Count,
min(Posts.CreationDate) as First,
min(Posts.Id) as [Post Link],
max(Posts.CreationDate) as Last,
max(Posts.Id) as [Post Link]
from Posts
LEFT JOIN PostTypes on Posts.PostTypeId = PostTypes.Id
GROUP BY Posts.PostTypeId
ORDER BY Posts.PostTypeId

fork query

edited dec 6

created dec 6 anonymous