3,256 answered market questions

WITH paid AS
(
    SELECT
        id,
        any(ex_dividend_date)       AS ex_date,
        any(toFloat64(cash_amount)) AS amount
    FROM global_markets.stocks_dividends
    WHERE ticker = 'T'
      AND cash_amount > 0
      AND ex_dividend_date >= toDate('2014-01-01')
    GROUP BY id
)
SELECT
    toString(min(ex_date))                AS level_start,
    formatDateTime(min(ex_date), '%b %Y') AS level_start_label,
    round(amount, 4)                      AS quarterly_dps,
    count()                               AS quarters_paid,
    formatDateTime(max(ex_date), '%b %Y') AS latest_ex_label
FROM paid
GROUP BY amount
ORDER BY min(ex_date)