SELECT

transfer.tx_from,

transfer.tx_to,

tags.name,

SUM(transfer.amount) AS transfer_amount,

COUNT(DISTINCT transfer.tx_id) AS donate_count

FROM solana.core.fact_transfers AS transfer

LEFT JOIN (

SELECT

'2ZiQY2u9bNxLF3fDhUFmZCz1n1baNnx2jtu1asPYpMhR' AS address, '0xAA' AS name

UNION ALL

SELECT

'cvvhDhkZqq2x8NwkQkxWpnUCbJe63qK9ZVpKw9Syc4R', '八爷'

UNION ALL

SELECT

'E1ByeBwfWSJ6Y4DPtoh54zePXsxkWD9MNkTa9PhvF1eg', '猫博士'

UNION ALL

SELECT

'8Uy8iKXD6DunGWELyqMDn1ARZCpandy2NDb23MU6Phgf', '七爷'

UNION ALL

SELECT

'BRAtk5fLdRZdU581MzGUbWpd2jwPad9tpwTpZyG5kHuF', 'Dragon 龙哥'

UNION ALL

SELECT

'F34pqaCHZJNe5QBD7AuKADieYqTue6XyGPgaErAE9voB', '内盘哥'

UNION ALL

SELECT

'3RpA8nPsCNTGh2UReCoq9dwDhmXM5kXCjAMNZH1UKm43', '李屌毛大神'

UNION ALL

SELECT

'E9CXsf9L8VYTdxgccXXMQTvqeQbHuKmeY5kE5A34i7UH', '123olp'

UNION ALL

SELECT

'ECuQUe43rucFHLfyy2C2CoZ4BmHoqP2xmxCdVAaVoWEP', '0xES E神'

UNION ALL