0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry

select Users.Id , Users.Reputation as rep from Users
left join  Comments on Users.Id = Comments.Id
left join Posts on Users.Id = Posts.id 
group by Users.Id , Users.Reputation
having count(Posts.Id) = 0 and count(Comments.Id) = 10 ;

fork query

edited dec 14

created dec 14 anonymous