Postgres JSONB SUM（）每月

Question

我想知道如何将（）每月利润（以下方式计算）计算总数。

select 
count(row_data->>'bankMovementAmount') AS "COUNTER",

我希望它能按当前

to_char((row_data->>'installmentBaseDate')::date, 'yyyy-mm') AS "MONTH",

( SUM( (row_data->>'bankMovementAmount')::float ) FILTER (WHERE row_data->>'bankMovementOperationType' = 'E')
- SUM( (row_data->>'bankMovementAmount')::float ) FILTER (WHERE row_data->>'bankMovementOperationType' = 'S')
) AS "VALUE"
from public.teste
WHERE abbreviation = 'BMO' AND row_data->>'companyName' = 'Nec Plus Ultra Gestão e Tecnologia LTDA' 
group by to_char((row_data->>'installmentBaseDate')::date, 'yyyy-mm') 
ORDER BY to_char((row_data->>'installmentBaseDate')::date, 'yyyy-mm')

输入图像描述