2,170 answered market questions

SELECT
    toString(toYear(execution_date))          AS year,
    countIf(ratio >= 1.25)                    AS large_distributions,
    countIf(ratio > 1 AND ratio < 1.25)       AS small_forward_splits,
    countIf(ratio < 1)                        AS reverse_splits
FROM
(
    SELECT
        ticker,
        execution_date,
        max(toFloat64(split_to) / greatest(toFloat64(split_from), 1.0)) AS ratio
    FROM global_markets.stocks_splits
    WHERE execution_date >= '2016-01-01'
      AND execution_date <  toStartOfYear(today())
      AND ticker NOT IN ('SPCX')
    GROUP BY ticker, execution_date
)
GROUP BY year
ORDER BY year