Untitled

select distinct(entitlement_id) "entitlement_id", max(period_end_date) "billing_period_end_date" --, max(period_start_date)"period_start_date"
from mbd_presentation.fuse_fbts_open_subs_activation
where reseller_id = 'vodafoneindia'
and accounting_date_local >= '2024-01-01'
and test_subscription is null
group by entitlement_id