Solutionunvalidated
select string_to_array(code, ',') as array_codes, total from raw_data — where array_codes && array ['5', '7'];. Outcome: select sum(total) as sum_total.
6cb03e26-578e-4312-999a-e32f7d111ceb
select string_to_array(code, ',') as array_codes, total from raw_data — where array_codes && array ['5', '7'];. Outcome: select sum(total) as sum_total.