slect id,name,country
sum(value1) as value1,
sum(value2) as value2,
sum(case when type1 = '01' and type2 = '02' then value3 else 0 ) as value3
from table where date='20210531' group by id,name,country
slect id,name,country
sum(value1) as value1,
sum(value2) as value2,
sum(case when type1 = '01' and type2 = '02' then value3 else 0 ) as value3
from table where date='20210531' group by id,name,country