Q&A about the site for researchers and developers who explore the principles of a system through analysis of its structure, function, and operation
select DisplayName, AccountId, CommentCount, b.Name
from Users u
join Badges b on b.Id = u.Id
right join Votes v on v.Id = u.Id
right join Posts p on p.Id = u.Id
where DisplayName='Jon Snow'