Пожалуйста, помогите разобраться в чем разница для получения выборки по заданным параметрам, на выходе имею разные результаты.

Вариант 1:

select name, surname from modern.users as u
left join (
select u.id, count(l.idUser) as likesss
from modern.users as u
join modern.likes as l on u.id=l.idUser
where year(l.timestamp) = 2025 and month(l.timestamp) = 3
group by u.id)
join1 ON join1.id = u.id
left join (
select u.id, count(f.User1) as friends
from modern.users as u
join modern.friendship as f on u.id=f.User1
group by u.id)
join2 ON join2.id = u.id
where friends > 70 and likesss > 3

Вариант 2:

select name, surname from modern.users as u
join modern.posts as p on p.idUser=u.id
join modern.likes as l on l.idUser=u.id and l.idPost=p.id
join modern.friendship as f on u.id=f.User1
where year(l.timestamp) = 2025 and month(l.timestamp) = 3
and (select count(f.User1) as friends from modern.friendship as f where f.User1=u.id) > 70
and (select count(l.idUser) as likesss from modern.likes as l where l.idUser=u.id) > 3
group by u.id