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_c...

I created a derived table that count the leads that we got in each day:Instead of that, I want to count the number of the leads we got each MONTH. For that I need to cast the dates to a different format (MM-YYYY).I tried to use the FORMAT function, b...