0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for amateur radio enthusiasts

select * from (select top 15
OwnerUserId as 'UserId',
count(*) as PostCount
from Posts
join Users on Users.Id = Posts.OwnerUserId
group by OwnerUserId
union all
select top 15
UserId,
count(*) as CommentCount
from Comments
join Users on Users.Id = Comments.UserId
group by UserId) as a

view current version

edited nov 3

created nov 3 jon.doe46177