Using Aggregate Combinators in ClickHouse(clickhouse.com)

    SELECT avg(number) FILTER (WHERE number > 50) FROM numbers(100)

    SELECT avgIf(number, number > 50) FROM numbers(100)

    SELECT avg(DISTINCT number)
    SELECT avgDistinct(number)

    WITH Region = 'us' AS segment1, Browser = 'Chrome' AS segment2
    SELECT uniqIf(UserID, segment1), uniqIf(UserID, segment2)
    WHERE segment1 OR segment2