...

spsanditems as 
(
select 
        done_date    as dt,
        key          as items, 
	    story_points as story_points
  from  ticket
 where  lower(status) in ('done', 'closed', 'resolved')
   and  (select y_n from include_sub_items) <> 1 or lower(type) not like 'sub%'
)

Example of the output:

...

Joining of generated weeks and filtered data

“done_date“ must be between the start and the end of its week for proper joining weeks and filtered data. The result set of this query is sorted descending by “start_of_the_week“ for proper calculation from last 4 weeks to last 52 weeks

...