Your question is Financial Statement Weakness Analysis. Start with the requirements and the four tables on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
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.
LAG() for quarter-over-quarter comparisonsCASE WHEN to classify business issues from financial metrics