2,170 answered market questions

SELECT
    sym                        AS ticker,
    round(avg(days_to_pay), 1) AS days_record_to_pay,
    count()                    AS payments
FROM
(
    SELECT
        any(ticker)                                 AS sym,
        max(dateDiff('day', record_date, pay_date)) AS days_to_pay
    FROM global_markets.stocks_dividends
    WHERE ticker IN ('AAPL', 'MSFT', 'KO', 'JNJ', 'PG', 'XOM', 'CVX', 'CSCO')
      AND ex_dividend_date >= '2024-06-01'
      AND ex_dividend_date <  today()
      AND cash_amount > 0
      AND pay_date > record_date
      AND dateDiff('day', record_date, pay_date) <= 90
    GROUP BY id
)
GROUP BY sym
ORDER BY days_record_to_pay DESC