Adding other aggregation criteria

SELECT
    distance_type,
    COUNT(*)
FROM
    `tutorial-analytics`
GROUP BY                                -- CASE checks the list of conditions
    CASE                                -- and returns one of multiple possible
        WHEN trip_distance > 10         -- expressions or with any operator
        THEN "long"                     -- that supports this expression. For example, you can use
        ELSE "short"                    -- in a SELECT
    END AS distance_type                -- and with the IN, WHERE, and ORDER BY operators.
                                        -- You can run GROUP BY
                                        -- for an arbitrary expression.
                                        -- The result will be available in a SELECT
                                        -- via an alias specified using AS.