b.label,

b.LABEL_SUBTYPE,

b.LABEL_TYPE,

sum(AMOUNT) as total_amount,

count(distinct TX_HASH) as use_no

from ethereum.core.ez_token_transfers s left outer join ethereum.core.dim_labels b on s.TO_ADDRESS=b.ADDRESS

where b.ADDRESS_NAME ilike '%stETH%'

and b.LABEL_SUBTYPE !='token_contract'

group by 1,2,3