case when DATE_PART('week', DATE '$etl_date') = '1' then substr('$etl_date',1,4)||'-'||DATE_PART('week', DATE '$etl_date')
else (case when substr('$etl_date',5,4)='0101' then substr(substr('$etl_date',1,4)-1,1,4)||'-'||DATE_PART('week', DATE '$etl_date')
else substr('$etl_date',1,4)||'-'||DATE_PART('week', DATE '$etl_date') end) end
else (case when substr('$etl_date',5,4)='0101' then substr(substr('$etl_date',1,4)-1,1,4)||'-'||DATE_PART('week', DATE '$etl_date')
else substr('$etl_date',1,4)||'-'||DATE_PART('week', DATE '$etl_date') end) end