case when to_label is null then 'others'

else to_label

end as Labels,

sum(amount) as Volume

from ethereum.udm_events

where lower(contract_address) = '0xd533a949740bb3306d119cc777fa900ba034cd52'

and origin_function_name = 'addLiquidity' and block_timestamp > '2021-01-01'

group by 1,2)

select labels, volume

from liq

order by 2 desc