WITH address_fees AS (

SELECT

from_address,

SUM(TX_FEE_PRECISE) AS total_fee

FROM

monad.testnet.fact_transactions

GROUP BY

from_address

),

ranked_fees AS (

SELECT

from_address,

total_fee,

RANK() OVER (ORDER BY total_fee DESC) AS fee_rank

FROM

address_fees

SELECT

fee_rank AS "Address Rank",

total_fee AS "Total Fee"

FROM

ranked_fees

WHERE

from_address = LOWER('{{Address}}');