Nested aggregates are not allowed.

UPSERT INTO default VALUES("k01", {"cid": "c01", "status":"active", "pid": "p01"});

CREATE INDEX ix11 ON default(cid, status, pid);

SELECT a.*

FROM default AS a

LEFT JOIN (SELECT b.pid, COUNT(1) AS cnt

           FROM default AS b

           WHERE b.cid > "c01" AND b.status IN ['active']

           GROUP BY b.pid) AS m USE NL

ON m.pid = a.cid

WHERE a.cid IS NOT NULL;

"errors": [

        {

            "code": 5370,

            "msg": "Unable to run subquery - cause: Nested aggregates are not allowed."

        },

        {

            "code": 5010,

            "msg": "Error evaluating ExpressionScan",

            "reason": {

                "_level": "exception",

                "caller": "context:1154",

                "code": 5370,

                "icause": "Nested aggregates are not allowed.",

                "key": "execution.subquery.build",

                "message": "Unable to run subquery"

            }

        }

    ],