Test Query

0

Please login or register to vote for this query.

(click on this box to dismiss)

Meta Stack Exchange

Q&A for meta-discussion of the Stack Exchange family of Q&A websites

select avg(Views) as Viewavg, count(UpVotes) as number, count(Score) as score, PostType, OwnerUserId from users as u 

join ( 
  select score as Score, PostTypeId as PostType ,OwnerUserId from Posts
  where OwnerUserId in (34487, 34588, 34989)
 ) as g 
 on g.OwnerUserId = u.Id
 
group by OwnerUserId, PostType

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results