0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for members of the workforce navigating the professional setting

select 
  u.Reputation
  ,u.CreationDate
  ,u.Views
  ,u.UpVotes
  ,u.DownVotes
  ,Comments = count(c.Id)
  ,Posts = COUNT(p.Id)
  ,Answers = ( 
                SELECT p.AnswerCount
                FROM Posts p
                WHERE p.AnswerCount = u.Id)
  ,Badges = STUFF((
                    select ' | ', b.Name
                    from Badges b
                    where b.UserId = u.Id and TagBased = 0
                    for XML PATH(''), Type).value('.', 'NVARCHAR(MAX)'), 1, 1, '')
                    
from Users u
left join Comments c ON c.UserId = u.Id
LEFT JOIN Posts p ON p.Id = u.Id
where DisplayName = 'scsimon'
group by
   u.Reputation
  ,u.CreationDate
  ,u.Views
  ,u.UpVotes
  ,u.DownVotes
  ,u.Id

fork query

edited apr 23 19

created apr 23 19 anonymous