SELECT fb.BLOCK_NUMBER, fb.BLOCK_TIMESTAMP, SUM(ft.FEE) AS TotalFees
FROM bitcoin.core.fact_transactions ft
JOIN bitcoin.core.fact_blocks fb ON ft.BLOCK_NUMBER = fb.BLOCK_NUMBER
GROUP BY fb.BLOCK_NUMBER, fb.BLOCK_TIMESTAMP
ORDER BY fb.BLOCK_TIMESTAMP;