
Analyze quarterly financial statements across business units and return only the periods that indicate operational weakness. Your query should combine income statement, balance sheet, and cash flow data, compare each quarter to the prior quarter, and assign a primary_issue label based on worsening margin, liquidity, or operating cash flow.
Joining multiple financial statement tables at the same reporting grainUsing CTEs to structure a multi-stage analysisApplying `LAG()` for quarter-over-quarter comparisonsUsing `CASE WHEN` to classify business issues from financial metrics