在PG 中有这么一个语法 sum (xx) filter(where xxxx) 如下:
select
sum(doris_sequence_version) filter(where address= '济南' ) as aaa,
sum(doris_sequence_version) filter(where address= '菏泽') as bbb
from test_a_001
where id >= 1
像这种语法,如果不使用 case when替换, Doris怎么能实现这种查询可以正常的替换 sum(xxx) filter (where)。