SELECT 
    GET_INT_TUPLE_SKETCH_ESTIMATE(
        INT_SUM_TUPLE_SKETCH_INTERSECTION(
          DISTINCT_COUNT_RAW_INTEGER_SUM_TUPLE_SKETCH(metTupleSketchBytes) FILTER (WHERE id = 1 OR id = 2),
          DISTINCT_COUNT_RAW_INTEGER_SUM_TUPLE_SKETCH(metTupleSketchBytes) FILTER (WHERE id = 2 OR id = 3)
        )
    )
FROM myTable

SELECT 
    DISTINCT_COUNT_TUPLE_SKETCH(metTupleSketchBytes),
    DISTINCT_COUNT_RAW_INTEGER_SUM_TUPLE_SKETCH(metTupleSketchBytes),
    SUM_VALUES_INTEGER_SUM_TUPLE_SKETCH(metTupleSketchBytes), 
    AVG_VALUE_INTEGER_SUM_TUPLE_SKETCH(metTupleSketchBytes)
FROM (
    SELECT metTupleSketchBytes FROM myTable WHERE id = 4
    UNION ALL
    SELECT metTupleSketchBytes FROM myTable WHERE id = 5
    UNION ALL
    SELECT metTupleSketchBytes FROM myTable WHERE id = 6
    UNION ALL
    SELECT metTupleSketchBytes FROM myTable WHERE id = 7
)

SELECT a.dimValue, distinctCountThetaSketch(b.thetaSketchCol)
FROM
(SELECT dimName, dimValue, thetaSketchCol FROM myTable WHERE dimName = 'gender' AND dimValue = 'Female') a 
JOIN 
(SELECT dimName, dimValue, thetaSketchCol FROM myTable WHERE dimName = 'gender' AND dimValue = 'Male') b 
ON a.dimName = b.dimName
GROUP BY a.dimValue;

SELECT
    GET_INT_TUPLE_SKETCH_ESTIMATE(
        INT_SUM_TUPLE_SKETCH_INTERSECTION(
            DISTINCT_COUNT_RAW_INTEGER_SUM_TUPLE_SKETCH(a.metTupleSketchBytes),
            DISTINCT_COUNT_RAW_INTEGER_SUM_TUPLE_SKETCH(b.metTupleSketchBytes)
        )
    ),
    GET_INT_TUPLE_SKETCH_ESTIMATE(
        INT_SUM_TUPLE_SKETCH_UNION(
            DISTINCT_COUNT_RAW_INTEGER_SUM_TUPLE_SKETCH(a.metTupleSketchBytes),
            DISTINCT_COUNT_RAW_INTEGER_SUM_TUPLE_SKETCH(b.metTupleSketchBytes)
        )
    )
FROM
    (SELECT id, metTupleSketchBytes FROM myTable WHERE id < 8 ) a
JOIN
    (SELECT id, metTupleSketchBytes FROM myTable WHERE id > 3 ) b
ON
    a.id = b.id

SELECT 
    GET_THETA_SKETCH_ESTIMATE(
        THETA_SKETCH_INTERSECT(
            DISTINCT_COUNT_RAW_THETA_SKETCH(a.thetaSketchCol, ''),
            DISTINCT_COUNT_RAW_THETA_SKETCH(b.thetaSketchCol, '')
        )
    ),
    GET_THETA_SKETCH_ESTIMATE(
        THETA_SKETCH_UNION(
            DISTINCT_COUNT_RAW_THETA_SKETCH(a.thetaSketchCol, ''), 
            DISTINCT_COUNT_RAW_THETA_SKETCH(b.thetaSketchCol, '')
        )
    ) 
FROM 
    (SELECT dimName, dimValue, thetaSketchCol FROM myTable where dimName = 'gender' and dimValue = 'Female') a
JOIN 
    (SELECT dimName, dimValue, thetaSketchCol FROM myTable where dimName = 'gender' and dimValue = 'Male') b
ON
    a.dimName = b.dimName