79463843

Date: 2025-02-24 14:31:57
Score: 0.5
Natty:
Report link

If all entries are in the strict format 'M2 USD … BITC … MAD … LOSS …', where the BITC-value is always the fifth part, you can try using a simple split:

SELECT SUM(SPLIT_PART(value, ' ', 5)::float) AS bitc_sum
FROM TABLE(FLATTEN(INPUT => data))

Where data is your array with the values ​​from the question.

Reasons:
  • Low length (0.5):
  • Has code block (-0.5):
  • Low reputation (0.5):
Posted by: gzzz