WITH main AS (
SELECT
tx_hash,
block_timestamp,
from_address AS user,
tx_fee
FROM
mezo.testnet.fact_transactions
WHERE
tx_succeeded
)
SELECT
user,
count(distinct tx_hash) as transactions,
SUM(tx_fee) AS total_fees
FROM main
GROUP BY user
ORDER BY total_fees DESC
limit 10