if I have follwing code:

select I.OID, I.segment,,

MAX(CASE WHEN S.SUBSCRIPTION_TYPE = '5' THEN 'Y' ELSE 'N' END ) PB_SUBS,

max(case when S.SUBSCRIPTION_TYPE ='12' then 'Y'...