3,293 answered market questions

SELECT
    toString(toYear(execution_date)) AS year,
    countIf(ratio > 1)               AS forward_splits,
    countIf(ratio < 1)               AS reverse_splits
FROM
(
    SELECT
        ticker,
        execution_date,
        any(toFloat64(split_to)) / any(toFloat64(split_from)) AS ratio
    FROM global_markets.stocks_splits
    WHERE execution_date >= '2015-01-01'
      AND execution_date <  toStartOfYear(today())
      AND split_from > 0
      AND split_to > 0
      AND ticker NOT IN ('SPCX')
    GROUP BY ticker, execution_date
)
GROUP BY year
ORDER BY year