Q&A for people interested in conceptual questions about life and challenges in a world where "cognitive" functions can be mimicked in purely digital environment
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 ;