数据表与当前周和那些日期一年前

I'm trying to create one sql table with the current week's data (always changing) as well as those dates data from the previous year. I have multiple tables that I have to join but am not sure how to create it all into one table. Here is what I have so far: I'm trying to create one sql table with the cur