One set of payments, four annual dividend totals

WITH
    payouts AS
    (
        SELECT
            ex_dividend_date            AS ex_date,
            max(toFloat64(cash_amount)) AS amt
        FROM global_markets.stocks_dividends
        WHERE ticker = 'AAPL'
          AND ex_dividend_date >= '2018-01-01'
          AND ex_dividend_date <  '2026-07-01'
        GROUP BY ex_dividend_date
    ),
    totals AS
    (
        SELECT
            round(sumIf(amt, ex_date > toDate('2026-06-30') - 365), 4)                                AS ttm,
            round(sumIf(amt, toYear(ex_date) = 2025), 4)                                              AS calendar_2025,
            round(sumIf(amt, ex_date >= toDate('2024-09-29') AND ex_date <= toDate('2025-09-27')), 4) AS fiscal_2025,
            round(4 * argMax(amt, ex_date), 4)                                                        AS indicated
        FROM payouts
    )
SELECT
    conv.1                                                       AS convention_label,
    conv.2                                                       AS annual_per_share,
    if(ttm > 0, round(100 * (conv.2 / ttm - 1), 2), 0.0)          AS vs_ttm_pct
FROM totals
ARRAY JOIN
[
    ('Trailing 12 months to Jun 30 2026', ttm),
    ('Calendar year 2025',                calendar_2025),
    ('Fiscal year 2025',                  fiscal_2025),
    ('Indicated forward rate',            indicated)
] AS conv