2,170 answered market questions

SELECT
    toString(toYear(execution_date))     AS year,
    toUInt32(countIf(to_val > from_val)) AS forward_splits,
    toUInt32(countIf(from_val > to_val)) AS reverse_splits
FROM
(
    SELECT
        ticker,
        execution_date,
        any(split_from) AS from_val,
        any(split_to)   AS to_val
    FROM global_markets.stocks_splits
    WHERE execution_date >= subtractYears(today(), 10)
      AND execution_date <= today()
      AND split_from > 0
      AND split_to > 0
    GROUP BY ticker, execution_date
)
GROUP BY year
ORDER BY year