Q&A about the site for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry
select usercount, PostTypes.name from ( select Count(latest.OwnerUserID) as usercount, PostTypeId from ( select OwnerUserId, MIN(CreationDate) as firstdate from Posts group by OwnerUserID ) as latest inner join Posts on Posts.OwnerUserID = latest.OwnerUserId group by PostTypeId ) as counts inner join PostTypes on PostTypes.Id = PostTypeId order by usercount desc