with sentonly as (
select * from
fb_friend_requests
where action = 'sent'
),

accepted as (
select
user_id_sender as uis,
user_id_receiver as uir,
action as goal
from fb_friend_requests
where action = 'accepted'
),

combined as (
select S.*, A.* from sentonly S
left join accepted A
on S.user_id_sender = A.uis
and S.user_id_receiver = A.uir
),

cased as (
select *,
case when goal = 'accepted' then 1 else 0 end as confirmed
, 1 as allrows
from combined
),

summed as (
select
date,
sum(confirmed) as collc,
sum(allrows) as coll_all
from cased
group by 1
order by 1 )

select date, collc / coll_all :: decimal
from summed