Tech for good

[Stratascratch/SQL] Daily Interactions By Users Count 본문

IT/Data Science

[Stratascratch/SQL] Daily Interactions By Users Count

Diana Kang 2025. 2. 26. 11:57

with cte as (
	select day, user1
    from facebook_user_interactions
    union all
    select day, user2 as user1
    from facebook_user_interactions)
  
select day, count(*)/2, count(distinct user1)
from cte
group by day;