get_days_users_have_met.sql

-- This SELECT statement counts how many days a pair of users have had at least 1 co-occurence and then bins them by day.
-- Used for visualization.

select s, sum(t.cou) from generate_series(0,10) as s left join
  (select user_a, user_b, count(*) as cou from derived_friend_list_days where nr_of_occurences > 0 group by user_a, user_b) as t
  on t.cou = s
  group by s;