Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select monthh,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,to_char( dil.Original_purchase_timestamp,'YYYY-MM') as monthh
- 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 monthh
- order by monthh
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement