JSON_AVG(json, jsonpath)

Computes the average value of a JSON array within a JSON object.

• json: The column containing JSON data.
• jsonpath: The path to the json array.

JSON_COUNT(json, jsonpath)

Returns the number of elements in a JSON array within a JSON object.

• json: The column containing JSON data.
• jsonpath: The path to the json array.

JSON_MAX(json, jsonpath)

Gets the maximum value in a JSON array within a JSON object.

• json: The column containing JSON data.
• jsonpath: The path to the json array.

JSON_MIN(json, jsonpath)

Gets the minimum value in a JSON array within a JSON object.

• json: The column containing JSON data.
• jsonpath: The path to the json array.

JSON_SUM(json, jsonpath)

Computes the sum of the elements in a JSON within a JSON object.

• json: The column containing JSON data.
• jsonpath: The path to the json array.