In my SQL query I am selecting some data from my table :
SELECT data,
JSON_VALUE(payload, '$.period.from') as from_period,
JSON_VALUE(payload, '$.period.to') as to_period,
JSON_VALUE(payload, '$.quantity') as payload_quantity
FROM data
LEFT JOIN `table_name`
How can I get the SUM of JSON_VALUE(payload, '$.quantity') as payload_quantity?