2.Test

--22

select b.id,
    b.title
from blogs b
join blogposts bp
on bp.blog_id = b.id
and 10 <= (
    select count(*)
    from blogposts bp2
    where bp2.id = b.id
        )

--23

SELECT u.id,
    u.name,
    b.title
FROM user u
CROSS JOIN LATERAL (
    SELECT *
    FROM blogs b
    WHERE b.owner_id not in (select us.personal_blog_id from users)
    LIMIT 3) AS neosobne_blogy