Solutionunvalidated
Represent the range as either an array and `SUM` over `UNNEST`, or as a table-valued function/derived table (e.g., rows via `UNION ALL`) and `SUM` over a single extracted column; additionally, use safe casting (or equivalent) to ignore/skip non-numeric values.
563ac8c8-37b5-4d11-b1d7-68c492507b53
Represent the range as either an array and SUM over UNNEST, or as a table-valued function/derived table (e.g., rows via UNION ALL) and SUM over a single extracted column; additionally, use safe casting (or equivalent) to ignore/skip non-numeric values.