Posted by Andrei, Jan. 19, 2022, 3:27 a.m.
99. Page recommendation possible bug
I fail to understand why the following query on question 99's environment does not return 1 on the count column for the following query.
In my opinion this is a bug, which also comes up if you are trying a different approach than the solution suggested.
select
u.user_id,
u.friend_id,
lp.page_id,
count(*)
from friends as u
join friends as f
on u.friend_id=f.user_id
join liked_page lp
on f.user_id=lp.user_id
and u.user_id!=lp.user_id
where u.user_id=1
group by 1,2,3
order by 4 desc
In my opinion this is a bug, which also comes up if you are trying a different approach than the solution suggested.
select
u.user_id,
u.friend_id,
lp.page_id,
count(*)
from friends as u
join friends as f
on u.friend_id=f.user_id
join liked_page lp
on f.user_id=lp.user_id
and u.user_id!=lp.user_id
where u.user_id=1
group by 1,2,3
order by 4 desc
