Pregunta de entrevista de Gaana

SQL - Joins, Aggregate functions and Windows functions Case study - Profits have declined. How do you find the root cause