How often listed payers distribute, trailing year

WITH payouts AS (
    SELECT
        ticker,
        any(frequency)        AS freq,
        any(ex_dividend_date) AS ex_date,
        any(pay_date)         AS paid_on
    FROM global_markets.stocks_dividends
    WHERE ex_dividend_date >= '2025-07-01'
      AND ex_dividend_date <  '2026-07-01'
      AND cash_amount > 0
      AND ticker NOT IN ('SPCX')
    GROUP BY id, ticker
)
SELECT
    multiIf(freq = 12, 'Monthly',
            freq = 4,  'Quarterly',
            freq = 2,  'Semiannual',
            freq = 1,  'Annual',
                       'Irregular')                  AS cadence,
    countDistinct(ticker)                            AS payer_count,
    round(avg(dateDiff('day', ex_date, paid_on)), 1) AS avg_days_ex_to_pay
FROM payouts
WHERE paid_on > ex_date
GROUP BY cadence
ORDER BY payer_count DESC