Could please tell me how to join these two tables

Hi everyone,I need your help with a thorny problem.

My requirement is to join the two tables with the Month field for analysis,but one of them is by Week and the other is by Month,I found their source data and source code.

But I don't know how to solve my problem. Could you give me some help

you have to join them by month in a native query, so I would first do a CTE grouping the table which is by week and then join to the one which is by month

@jesse1 You're seeing this issue: - upvote by clicking :+1: on the first post