You can use the script below to see how many recurring lines are set to each cycle length
select bill_cycle as "Billing Cycle",
count(bill_cycle) as "Number of Recurring Lines in Billing Cycle"
from ar_customer_recurring
where Customer_Id > 1
group by bill_cycle
