Dividend growth champions: 20+ straight years of raises, ranked by how many times over the payout grew

WITH annual AS (
    SELECT ticker,
           toYear(ex_dividend_date) AS y,
           round(sum(cash_amount), 4) AS div
    FROM global_markets.stocks_dividends
    WHERE frequency IN (1, 2, 4, 12)
      AND ex_dividend_date >= '2000-01-01'
      AND ex_dividend_date < toStartOfYear(today())
    GROUP BY ticker, y
),
f AS (
    SELECT ticker, y, div,
           lagInFrame(div) OVER w AS prev,
           lagInFrame(y) OVER w AS prev_y
    FROM annual
    WINDOW w AS (PARTITION BY ticker ORDER BY y ASC)
),
brk AS (
    SELECT ticker, y, div,
           (prev IS NULL OR div <= prev OR (y - prev_y) > 1) AS is_break
    FROM f
)
SELECT ticker,
       max(y) - maxIf(y, is_break) AS streak_years,
       round(argMax(div, y) / argMin(div, y), 1) AS dividend_multiple
FROM brk
GROUP BY ticker
HAVING streak_years >= 20 AND max(y) >= toYear(today()) - 2
ORDER BY dividend_multiple DESC
LIMIT 20