miner ,

count(tx_count) as num_tx_count ,

sum(GAS_USED)

from ethereum.core.fact_blocks

where tx_count > 0

group by 1

order by 2 desc