select pln_products as "Products",round((sum(PLN_ANNUAL)/12),2) AS "Monthly Charges",count(pln_products) as "Count"where pln_start_date<=(SELECT LAST_DAY(:select_date) FROM dual)
and ((pln_end_date is null) or (pln_end_date >= (SELECT TRUNC(LAST_DAY(ADD_MONT