How I was introduced to SQL window function

I was called at my firm for having to create a analytics dashboard for a multiTenet CRM dashboard...