There is a ‘company’ table. This view joins to a ‘content’ dt that includes the number of content that a company created each week from the day the company created. I used the ‘date_diff’ function to calculate the week duration between the ‘company_create_date’ to the ‘content_create_date’:
The ‘company’ table is also joined to a ‘view’ table that includes all the number of views that a company has in the contents they created, each week from the day the company created. I used the ‘duration’ function to calculate the week duration between the ‘company_create_date’ to the ‘view_ts’:
I want to create one table including these 2 tables. When I tried to do that, this is what happened:
The week numbers are not synched.
Please help me to think of another way to create this table