calc_continuously_paid_months.sql

select sum(coalesce(least(valid_to::date, now()::date) - valid_from::date, 0))/30.0 as diff_sum, company_id from company_packet_history where packet_id <> 0 and company_id in (select company_id from company_billings where ind_packet <> 0) group by company_id order by company_id desc limit 10;