Board declaration to ex-date to payment, eight household payers

SELECT
    dividend_ticker                                      AS ticker,
    count()                                              AS declaration_count,
    round(avg(dateDiff('day', declared_on, ex_date)), 1) AS avg_days_declared_to_ex,
    round(avg(dateDiff('day', ex_date, paid_on)), 1)     AS avg_days_ex_to_pay
FROM
(
    SELECT
        id,
        any(ticker)           AS dividend_ticker,
        any(declaration_date) AS declared_on,
        any(ex_dividend_date) AS ex_date,
        any(pay_date)         AS paid_on
    FROM global_markets.stocks_dividends
    WHERE ticker IN ('AAPL', 'MSFT', 'KO', 'JNJ', 'PG', 'XOM', 'CVX', 'CSCO')
      AND ex_dividend_date >= toDate('2023-01-01')
      AND ex_dividend_date <  today()
      AND declaration_date >= toDate('2000-01-01')
      AND pay_date         >= toDate('2000-01-01')
    GROUP BY id
)
GROUP BY dividend_ticker
ORDER BY avg_days_declared_to_ex DESC