2,170 answered market questions

WITH payers AS (
    SELECT ticker,
           argMax(dividend_yield, date) * 100 AS yield_pct
    FROM global_markets.stocks_ratios
    WHERE date = (SELECT max(date) FROM global_markets.stocks_ratios)
      AND price >= 5
      AND market_cap >= 1000000000
      AND dividend_yield > 0
    GROUP BY ticker
),
banded AS (
    SELECT multiIf(yield_pct < 1, 'under 1%',
                   yield_pct < 2, '1 to 2%',
                   yield_pct < 3, '2 to 3%',
                   yield_pct < 4, '3 to 4%',
                   yield_pct < 6, '4 to 6%',
                   yield_pct < 8, '6 to 8%',
                   '8% and up') AS yield_band,
           min(yield_pct) AS band_floor,
           count() AS company_count
    FROM payers
    GROUP BY yield_band
)
SELECT yield_band,
       company_count,
       round(100 * company_count / sum(company_count) OVER (), 1) AS pct_of_payers,
       round(100 * sum(company_count) OVER (ORDER BY band_floor) / sum(company_count) OVER (), 1) AS cumulative_pct
FROM banded
ORDER BY band_floor