address_name,

sum(tx_fee) as tx_fee

FROM avalanche.core.fact_transactions a

LEFT JOIN avalanche.core.dim_labels b

ON from_address = address

WHERE date_trunc('day',block_timestamp) = current_date-1

GROUP BY from_address,address_name

ORDER BY tx_fee DESC

LIMIT 10