How to calculate last 5 weeks of data in Microsoft SQL server

Question

How to calculate last 5 weeks of data in Microsoft SQL server ,I have day table,week table aswell
in week table I have column weekcod having data 202001 ,202002,. 202053

Answer 1

Perhaps this could be helpful?

https://stackoverflow.com/questions/5903256/calculate-data-based-on-days-and-weeks-in-sql