3,293 answered market questions

SELECT
    toString(toStartOfMonth(execution_date))               AS month,
    formatDateTime(toStartOfMonth(execution_date), '%b %Y') AS month_label,
    countIf(direction = 'forward')                         AS forward_splits,
    countIf(direction = 'reverse')                         AS reverse_splits
FROM
(
    SELECT
        execution_date,
        ticker,
        any(if(adjustment_type = 'forward_split', 'forward', 'reverse')) AS direction
    FROM global_markets.stocks_splits
    WHERE execution_date >= addMonths(toStartOfMonth(today()), -36)
      AND execution_date <  toStartOfMonth(today())
      AND split_from > 0
      AND split_to > 0
    GROUP BY execution_date, ticker
)
GROUP BY month, month_label
ORDER BY month