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.CreationDate) as Last
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