Recurring cash dividends by declared schedule: every payer on file, July 2025 through June 2026

SELECT multiIf(freq = 4, 'Quarterly',
               freq = 2, 'Twice a year',
               freq = 1, 'Once a year',
               freq = 12, 'Monthly',
               'Other schedule') AS schedule,
       uniqExact(ticker) AS tickers,
       count() AS payments,
       round(count() / uniqExact(ticker), 1) AS payments_per_ticker,
       round(100 * uniqExact(ticker) / (SELECT uniqExact(ticker)
                                        FROM global_markets.stocks_dividends
                                        WHERE ex_dividend_date >= '2025-07-01'
                                          AND ex_dividend_date <= '2026-06-30'
                                          AND cash_amount > 0
                                          AND distribution_type = 'recurring'), 1) AS share_of_payers_pct
FROM (
    SELECT ticker,
           ex_dividend_date,
           argMax(frequency, ex_dividend_date) OVER (PARTITION BY ticker) AS freq
    FROM global_markets.stocks_dividends
    WHERE ex_dividend_date >= '2025-07-01'
      AND ex_dividend_date <= '2026-06-30'
      AND cash_amount > 0
      AND distribution_type = 'recurring'
)
GROUP BY schedule
ORDER BY tickers DESC