2,173 answered market questions

WITH payouts AS (
    SELECT
        ticker,
        any(ex_dividend_date) AS ex_date,
        any(pay_date)         AS paid_on
    FROM global_markets.stocks_dividends
    WHERE ticker IN ('AAPL', 'JNJ', 'KO', 'MSFT', 'O', 'PG')
      AND ex_dividend_date >= '2024-07-01'
      AND ex_dividend_date <  '2026-07-01'
      AND cash_amount > 0
    GROUP BY id, ticker
)
SELECT
    ticker,
    count()                                          AS payment_count,
    round(avg(dateDiff('day', ex_date, paid_on)), 1) AS avg_days_ex_to_pay,
    max(dateDiff('day', ex_date, paid_on))           AS max_days_ex_to_pay
FROM payouts
WHERE paid_on > ex_date
GROUP BY ticker
ORDER BY avg_days_ex_to_pay DESC