Q&A for professional robotic engineers, hobbyists, researchers and students
select count(*) as more_than_10 from users u where exists(select id from posts p where u.id = p.owneruserid group by p.id having count(*) > 10 )