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 ) select id from posts p group by p.id having count(*) > 10