How many US companies clear each yield floor, with payout ratio and loss-makers

WITH snapshot AS (
    SELECT ticker,
           toFloat64(dividend_yield) * 100 AS yield_pct,
           toFloat64(dividend_yield) * toFloat64(price) AS annual_dividend,
           toFloat64(earnings_per_share) AS eps
    FROM global_markets.stocks_ratios
    WHERE date = (SELECT max(date) FROM global_markets.stocks_ratios)
      AND price >= 5
      AND market_cap >= 2000000000
      AND dividend_yield > 0
      AND earnings_per_share IS NOT NULL
),
rungs AS (
    SELECT arrayJoin([2, 3, 4, 5, 6, 8, 10, 15]) AS min_yield_pct
)
SELECT concat(toString(r.min_yield_pct), '% and up') AS yield_floor,
       count() AS companies,
       round(quantileDeterministicIf(0.5)(s.annual_dividend / s.eps * 100,
                                          cityHash64(s.ticker), s.eps > 0), 0) AS median_payout_ratio,
       round(100 * countIf(s.eps <= 0) / count(), 1) AS pct_no_positive_eps
FROM rungs AS r, snapshot AS s
WHERE s.yield_pct >= r.min_yield_pct
GROUP BY r.min_yield_pct
HAVING countIf(s.eps > 0) > 0
ORDER BY r.min_yield_pct