select datee,count(Dlog.id_for_vendor),count(Usub.id_for_vendor)
,cast(count(Usub.id_for_vendor) as float)/cast(count(Dlog.id_for_vendor) as float) as Ratio
From
(select distinct dil.id_for_vendor,date(dil.Original_purchase_timestamp) as datee
FROM public.facetune2_device_info_log as dil
where dil.Original_purchase_timestamp is not null
order by dil.id_for_vendor) as Dlog left join public.Facetune2_usage_store_user_subscribed as Usub
on (Dlog.id_for_vendor=Usub.id_for_vendor)
group by datee
order by datee;