I have been trying several approaches but I think I need your expertise in this matter.

I have a table with several columns, two of those are dates (year-month-day)(start-end). I need to create new columns year buckets, grabbing the year from start date and the year from end date and do a counting. if the year dates are the same the bucket column would have only 1 year.

Here is my desired output. Thank you