select cal_date, regexp_replace(cal_date,'-','') as PC_cal_date,
year_num*100+week_num as year_week_num,
case when year_num*100+pd_num in (min_year_pd_num, max_year_pd_num) then 'A' else 'B' end as yr_pd_ind,
year_num*100+pd_num as yr_pd_num,
dense_rank() over (order by year_num*100+week_num desc) as wk_index,
dense_rank() over (order by year_num*100+pd_num desc) as pd_index
from mstr_v.local_cal_date t1,
(select max(year_num*100+pd_num) max_year_pd_num, min(year_num*100+pd_num) min_year_pd_num from mstr_v.local_cal_date
where cal_date in (date(date_sub(current_date,cast(date_format(current_date,'u') as int)+105*7+1)),date(date_sub(current_date,cast(date_format(current_date,'u') as int))))
) t2
where cal_date between date(date_sub(current_date,cast(date_format(current_date,'u') as int)+105*7)) and date(date_sub(current_date,cast(date_format(current_date,'u') as int)+1))