(with sixty as (with tab1 as (with miners as (select CASE when tx_count <= '123' then 'Lower Transaction Count' when '123' < tx_count then 'Higher Transaction Count' else 'Others' end as Block_Type, miner, tx_count from ethereum.core.fact_blocks where tx_count > '0'), miner_block as (select miner, count(block_number) as "Total Blocks" from ethereum.core.fact_blocks where tx_count > '0' group by 1), miner_type as (select miners.miner as "Miners", block_type as "Block Type", count(*) as "Blocks with Higher Txs Count", sum(tx_count) as "Total Txs", avg(tx_count) as "Average Txs per Block" from miners group by 1, 2 order by 1) select "Miners", "Block Type", "Blocks with Higher Txs Count", "Total Blocks", "Total Txs", "Average Txs per Block", ("Blocks with Higher Txs Count"/"Total Blocks"*100) as "% of Blocks" from miner_type inner Join miner_block on miner_type."Miners"=miner_block.miner order by 1) select '60 %' as "% of Blocks", count("Miners") as "Number of miners" from tab1 where "Block Type" = 'Higher Transaction Count' and "% of Blocks" >= '60' and "Total Blocks" >= '5'), sixty_five as (with tab1 as (with miners as (select CASE when tx_count <= '123' then 'Lower Transaction Count' when '123' < tx_count then 'Higher Transaction Count' else 'Others' end as Block_Type, miner, tx_count from ethereum.core.fact_blocks where tx_count > '0'), miner_block as (select miner, count(block_number) as "Total Blocks" from ethereum.core.fact_blocks where tx_count > '0' group by 1), miner_type as (select miners.miner as "Miners", block_type as "Block Type", count(*) as "Blocks with Higher Txs Count", sum(tx_count) as "Total Txs", avg(tx_count) as "Average Txs per Block" from miners group by 1, 2 order by 1) select "Miners", "Block Type", "Blocks with Higher Txs Count", "Total Blocks", "Total Txs", "Average Txs per Block", ("Blocks with Higher Txs Count"/"Total Blocks"*100) as "% of Blocks" from miner_type inner Join miner_block on miner_type."Miners"=miner_block.miner order by 1) select '65 %' as "% of Blocks", count("Miners") as "Number of miners" from tab1 where "Block Type" = 'Higher Transaction Count' and "% of Blocks" >= '65' and "Total Blocks" >= '5'), seventy as (with tab1 as (with miners as (select CASE when tx_count <= '123' then 'Lower Transaction Count' when '123' < tx_count then 'Higher Transaction Count' else 'Others' end as Block_Type, miner, tx_count from ethereum.core.fact_blocks where tx_count > '0'), miner_block as (select miner, count(block_number) as "Total Blocks" from ethereum.core.fact_blocks where tx_count > '0' group by 1), miner_type as (select miners.miner as "Miners", block_type as "Block Type", count(*) as "Blocks with Higher Txs Count", sum(tx_count) as "Total Txs", avg(tx_count) as "Average Txs per Block" from miners group by 1, 2 order by 1) select "Miners", "Block Type", "Blocks with Higher Txs Count", "Total Blocks", "Total Txs", "Average Txs per Block", ("Blocks with Higher Txs Count"/"Total Blocks"*100) as "% of Blocks" from miner_type inner Join miner_block on miner_type."Miners"=miner_block.miner order by 1) select '70 %' as "% of Blocks", count("Miners") as "Number of miners" from tab1 where "Block Type" = 'Higher Transaction Count' and "% of Blocks" >= '70' and "Total Blocks" >= '5'), seventy_five as (with tab1 as (with miners as (select CASE when tx_count <= '123' then 'Lower Transaction Count' when '123' < tx_count then 'Higher Transaction Count' else 'Others' end as Block_Type, miner, tx_count from ethereum.core.fact_blocks where tx_count > '0'), miner_block as (select miner, count(block_number) as "Total Blocks" from ethereum.core.fact_blocks where tx_count > '0' group by 1), miner_type as (select miners.miner as "Miners", block_type as "Block Type", count(*) as "Blocks with Higher Txs Count", sum(tx_count) as "Total Txs", avg(tx_count) as "Average Txs per Block" from miners group by 1, 2 order by 1) select "Miners", "Block Type", "Blocks with Higher Txs Count", "Total Blocks", "Total Txs", "Average Txs per Block", ("Blocks with Higher Txs Count"/"Total Blocks"*100) as "% of Blocks" from miner_type inner Join miner_block on miner_type."Miners"=miner_block.miner order by 1) select '75 %' as "% of Blocks", count("Miners") as "Number of miners" from tab1 where "Block Type" = 'Higher Transaction Count' and "% of Blocks" >= '75' and "Total Blocks" >= '5'), eighty as (with tab1 as (with miners as (select CASE when tx_count <= '123' then 'Lower Transaction Count' when '123' < tx_count then 'Higher Transaction Count' else 'Others' end as Block_Type, miner, tx_count from ethereum.core.fact_blocks where tx_count > '0'), miner_block as (select miner, count(block_number) as "Total Blocks" from ethereum.core.fact_blocks where tx_count > '0' group by 1), miner_type as (select miners.miner as "Miners", block_type as "Block Type", count(*) as "Blocks with Higher Txs Count", sum(tx_count) as "Total Txs", avg(tx_count) as "Average Txs per Block" from miners group by 1, 2 order by 1) select "Miners", "Block Type", "Blocks with Higher Txs Count", "Total Blocks", "Total Txs", "Average Txs per Block", ("Blocks with Higher Txs Count"/"Total Blocks"*100) as "% of Blocks" from miner_type inner Join miner_block on miner_type."Miners"=miner_block.miner order by 1) select '80 %' as "% of Blocks", count("Miners") as "Number of miners" from tab1 where "Block Type" = 'Higher Transaction Count' and "% of Blocks" >= '80' and "Total Blocks" >= '5'), eighty_five as (with tab1 as (with miners as (select CASE when tx_count <= '123' then 'Lower Transaction Count' when '123' < tx_count then 'Higher Transaction Count' else 'Others' end as Block_Type, miner, tx_count from ethereum.core.fact_blocks where tx_count > '0'), miner_block as (select miner, count(block_number) as "Total Blocks" from ethereum.core.fact_blocks where tx_count > '0' group by 1), miner_type as (select miners.miner as "Miners", block_type as "Block Type", count(*) as "Blocks with Higher Txs Count", sum(tx_count) as "Total Txs", avg(tx_count) as "Average Txs per Block" from miners group by 1, 2 order by 1) select "Miners", "Block Type", "Blocks with Higher Txs Count", "Total Blocks", "Total Txs", "Average Txs per Block", ("Blocks with Higher Txs Count"/"Total Blocks"*100) as "% of Blocks" from miner_type inner Join miner_block on miner_type."Miners"=miner_block.miner order by 1) select '85 %' as "% of Blocks", count("Miners") as "Number of miners" from tab1 where "Block Type" = 'Higher Transaction Count' and "% of Blocks" >= '85' and "Total Blocks" >= '5'), ninty as (with tab1 as (with miners as (select CASE when tx_count <= '123' then 'Lower Transaction Count' when '123' < tx_count then 'Higher Transaction Count' else 'Others' end as Block_Type, miner, tx_count from ethereum.core.fact_blocks where tx_count > '0'), miner_block as (select miner, count(block_number) as "Total Blocks" from ethereum.core.fact_blocks where tx_count > '0' group by 1), miner_type as (select miners.miner as "Miners", block_type as "Block Type", count(*) as "Blocks with Higher Txs Count", sum(tx_count) as "Total Txs", avg(tx_count) as "Average Txs per Block" from miners group by 1, 2 order by 1) select "Miners", "Block Type", "Blocks with Higher Txs Count", "Total Blocks", "Total Txs", "Average Txs per Block", ("Blocks with Higher Txs Count"/"Total Blocks"*100) as "% of Blocks" from miner_type inner Join miner_block on miner_type."Miners"=miner_block.miner order by 1) select '90 %' as "% of Blocks", count("Miners") as "Number of miners" from tab1 where "Block Type" = 'Higher Transaction Count' and "% of Blocks" >= '90' and "Total Blocks" >= '5'), ninty_five as (with tab1 as (with miners as (select CASE when tx_count <= '123' then 'Lower Transaction Count' when '123' < tx_count then 'Higher Transaction Count' else 'Others' end as Block_Type, miner, tx_count from ethereum.core.fact_blocks where tx_count > '0'), miner_block as (select miner, count(block_number) as "Total Blocks" from ethereum.core.fact_blocks where tx_count > '0' group by 1), miner_type as (select miners.miner as "Miners", block_type as "Block Type", count(*) as "Blocks with Higher Txs Count", sum(tx_count) as "Total Txs", avg(tx_count) as "Average Txs per Block" from miners group by 1, 2 order by 1) select "Miners", "Block Type", "Blocks with Higher Txs Count", "Total Blocks", "Total Txs", "Average Txs per Block", ("Blocks with Higher Txs Count"/"Total Blocks"*100) as "% of Blocks" from miner_type inner Join miner_block on miner_type."Miners"=miner_block.miner order by 1) select '95 %' as "% of Blocks", count("Miners") as "Number of miners" from tab1 where "Block Type" = 'Higher Transaction Count' and "% of Blocks" >= '95' and "Total Blocks" >= '5'), one_hundred as (with tab1 as (with miners as (select CASE when tx_count <= '123' then 'Lower Transaction Count' when '123' < tx_count then 'Higher Transaction Count' else 'Others' end as Block_Type, miner, tx_count from ethereum.core.fact_blocks where tx_count > '0'), miner_block as (select miner, count(block_number) as "Total Blocks" from ethereum.core.fact_blocks where tx_count > '0' group by 1), miner_type as (select miners.miner as "Miners", block_type as "Block Type", count(*) as "Blocks with Higher Txs Count", sum(tx_count) as "Total Txs", avg(tx_count) as "Average Txs per Block" from miners group by 1, 2 order by 1) select "Miners", "Block Type", "Blocks with Higher Txs Count", "Total Blocks", "Total Txs", "Average Txs per Block", ("Blocks with Higher Txs Count"/"Total Blocks"*100) as "% of Blocks" from miner_type inner Join miner_block on miner_type."Miners"=miner_block.miner order by 1) select 'Whole Blocks' as "% of Blocks", count("Miners") as "Number of miners" from tab1 where "Block Type" = 'Higher Transaction Count' and "% of Blocks" >= '100' and "Total Blocks" >= '5') select 'Higher Txs' as "Block Type", * from sixty union select 'Higher Txs' as "Block Type", * from sixty_five union select 'Higher Txs' as "Block Type", * from seventy union select 'Higher Txs' as "Block Type", * from seventy_five union select 'Higher Txs' as "Block Type", * from eighty union select 'Higher Txs' as "Block Type", * from eighty_five union select 'Higher Txs' as "Block Type", * from ninty union select 'Higher Txs' as "Block Type", * from ninty_five union select 'Higher Txs' as "Block Type", * from one_hundred order by 1) union all (with sixty as (with tab1 as (with miners as (select CASE when tx_count <= '123' then 'Lower Transaction Count' when '123' < tx_count then 'Higher Transaction Count' else 'Others' end as Block_Type, miner, tx_count from ethereum.core.fact_blocks where tx_count > '0'), miner_block as (select miner, count(block_number) as "Total Blocks" from ethereum.core.fact_blocks where tx_count > '0' group by 1), miner_type as (select miners.miner as "Miners", block_type as "Block Type", count(*) as "Blocks with Lower Txs Count", sum(tx_count) as "Total Txs", avg(tx_count) as "Average Txs per Block" from miners group by 1, 2 order by 1) select "Miners", "Block Type", "Blocks with Lower Txs Count", "Total Blocks", "Total Txs", "Average Txs per Block", ("Blocks with Lower Txs Count"/"Total Blocks"*100) as "% of Blocks" from miner_type inner Join miner_block on miner_type."Miners"=miner_block.miner order by 1) select '60 %' as "% of Blocks", count("Miners") as "Number of miners" from tab1 where "Block Type" = 'Lower Transaction Count' and "% of Blocks" >= '60' and "Total Blocks" >= '5'), sixty_five as (with tab1 as (with miners as (select CASE when tx_count <= '123' then 'Lower Transaction Count' when '123' < tx_count then 'Higher Transaction Count' else 'Others' end as Block_Type, miner, tx_count from ethereum.core.fact_blocks where tx_count > '0'), miner_block as (select miner, count(block_number) as "Total Blocks" from ethereum.core.fact_blocks where tx_count > '0' group by 1), miner_type as (select miners.miner as "Miners", block_type as "Block Type", count(*) as "Blocks with Lower Txs Count", sum(tx_count) as "Total Txs", avg(tx_count) as "Average Txs per Block" from miners group by 1, 2 order by 1) select "Miners", "Block Type", "Blocks with Lower Txs Count", "Total Blocks", "Total Txs", "Average Txs per Block", ("Blocks with Lower Txs Count"/"Total Blocks"*100) as "% of Blocks" from miner_type inner Join miner_block on miner_type."Miners"=miner_block.miner order by 1) select '65 %' as "% of Blocks", count("Miners") as "Number of miners" from tab1 where "Block Type" = 'Lower Transaction Count' and "% of Blocks" >= '65' and "Total Blocks" >= '5'), seventy as (with tab1 as (with miners as (select CASE when tx_count <= '123' then 'Lower Transaction Count' when '123' < tx_count then 'Higher Transaction Count' else 'Others' end as Block_Type, miner, tx_count from ethereum.core.fact_blocks where tx_count > '0'), miner_block as (select miner, count(block_number) as "Total Blocks" from ethereum.core.fact_blocks where tx_count > '0' group by 1), miner_type as (select miners.miner as "Miners", block_type as "Block Type", count(*) as "Blocks with Lower Txs Count", sum(tx_count) as "Total Txs", avg(tx_count) as "Average Txs per Block" from miners group by 1, 2 order by 1) select "Miners", "Block Type", "Blocks with Lower Txs Count", "Total Blocks", "Total Txs", "Average Txs per Block", ("Blocks with Lower Txs Count"/"Total Blocks"*100) as "% of Blocks" from miner_type inner Join miner_block on miner_type."Miners"=miner_block.miner order by 1) select '70 %' as "% of Blocks", count("Miners") as "Number of miners" from tab1 where "Block Type" = 'Lower Transaction Count' and "% of Blocks" >= '70' and "Total Blocks" >= '5'), seventy_five as (with tab1 as (with miners as (select CASE when tx_count <= '123' then 'Lower Transaction Count' when '123' < tx_count then 'Higher Transaction Count' else 'Others' end as Block_Type, miner, tx_count from ethereum.core.fact_blocks where tx_count > '0'), miner_block as (select miner, count(block_number) as "Total Blocks" from ethereum.core.fact_blocks where tx_count > '0' group by 1), miner_type as (select miners.miner as "Miners", block_type as "Block Type", count(*) as "Blocks with Lower Txs Count", sum(tx_count) as "Total Txs", avg(tx_count) as "Average Txs per Block" from miners group by 1, 2 order by 1) select "Miners", "Block Type", "Blocks with Lower Txs Count", "Total Blocks", "Total Txs", "Average Txs per Block", ("Blocks with Lower Txs Count"/"Total Blocks"*100) as "% of Blocks" from miner_type inner Join miner_block on miner_type."Miners"=miner_block.miner order by 1) select '75 %' as "% of Blocks", count("Miners") as "Number of miners" from tab1 where "Block Type" = 'Lower Transaction Count' and "% of Blocks" >= '75' and "Total Blocks" >= '5'), eighty as (with tab1 as (with miners as (select CASE when tx_count <= '123' then 'Lower Transaction Count' when '123' < tx_count then 'Higher Transaction Count' else 'Others' end as Block_Type, miner, tx_count from ethereum.core.fact_blocks where tx_count > '0'), miner_block as (select miner, count(block_number) as "Total Blocks" from ethereum.core.fact_blocks where tx_count > '0' group by 1), miner_type as (select miners.miner as "Miners", block_type as "Block Type", count(*) as "Blocks with Lower Txs Count", sum(tx_count) as "Total Txs", avg(tx_count) as "Average Txs per Block" from miners group by 1, 2 order by 1) select "Miners", "Block Type", "Blocks with Lower Txs Count", "Total Blocks", "Total Txs", "Average Txs per Block", ("Blocks with Lower Txs Count"/"Total Blocks"*100) as "% of Blocks" from miner_type inner Join miner_block on miner_type."Miners"=miner_block.miner order by 1) select '80 %' as "% of Blocks", count("Miners") as "Number of miners" from tab1 where "Block Type" = 'Lower Transaction Count' and "% of Blocks" >= '80' and "Total Blocks" >= '5'), eighty_five as (with tab1 as (with miners as (select CASE when tx_count <= '123' then 'Lower Transaction Count' when '123' < tx_count then 'Higher Transaction Count' else 'Others' end as Block_Type, miner, tx_count from ethereum.core.fact_blocks where tx_count > '0'), miner_block as (select miner, count(block_number) as "Total Blocks" from ethereum.core.fact_blocks where tx_count > '0' group by 1), miner_type as (select miners.miner as "Miners", block_type as "Block Type", count(*) as "Blocks with Lower Txs Count", sum(tx_count) as "Total Txs", avg(tx_count) as "Average Txs per Block" from miners group by 1, 2 order by 1) select "Miners", "Block Type", "Blocks with Lower Txs Count", "Total Blocks", "Total Txs", "Average Txs per Block", ("Blocks with Lower Txs Count"/"Total Blocks"*100) as "% of Blocks" from miner_type inner Join miner_block on miner_type."Miners"=miner_block.miner order by 1) select '85 %' as "% of Blocks", count("Miners") as "Number of miners" from tab1 where "Block Type" = 'Lower Transaction Count' and "% of Blocks" >= '85' and "Total Blocks" >= '5'), ninty as (with tab1 as (with miners as (select CASE when tx_count <= '123' then 'Lower Transaction Count' when '123' < tx_count then 'Higher Transaction Count' else 'Others' end as Block_Type, miner, tx_count from ethereum.core.fact_blocks where tx_count > '0'), miner_block as (select miner, count(block_number) as "Total Blocks" from ethereum.core.fact_blocks where tx_count > '0' group by 1), miner_type as (select miners.miner as "Miners", block_type as "Block Type", count(*) as "Blocks with Lower Txs Count", sum(tx_count) as "Total Txs", avg(tx_count) as "Average Txs per Block" from miners group by 1, 2 order by 1) select "Miners", "Block Type", "Blocks with Lower Txs Count", "Total Blocks", "Total Txs", "Average Txs per Block", ("Blocks with Lower Txs Count"/"Total Blocks"*100) as "% of Blocks" from miner_type inner Join miner_block on miner_type."Miners"=miner_block.miner order by 1) select '90 %' as "% of Blocks", count("Miners") as "Number of miners" from tab1 where "Block Type" = 'Lower Transaction Count' and "% of Blocks" >= '90' and "Total Blocks" >= '5'), ninty_five as (with tab1 as (with miners as (select CASE when tx_count <= '123' then 'Lower Transaction Count' when '123' < tx_count then 'Higher Transaction Count' else 'Others' end as Block_Type, miner, tx_count from ethereum.core.fact_blocks where tx_count > '0'), miner_block as (select miner, count(block_number) as "Total Blocks" from ethereum.core.fact_blocks where tx_count > '0' group by 1), miner_type as (select miners.miner as "Miners", block_type as "Block Type", count(*) as "Blocks with Lower Txs Count", sum(tx_count) as "Total Txs", avg(tx_count) as "Average Txs per Block" from miners group by 1, 2 order by 1) select "Miners", "Block Type", "Blocks with Lower Txs Count", "Total Blocks", "Total Txs", "Average Txs per Block", ("Blocks with Lower Txs Count"/"Total Blocks"*100) as "% of Blocks" from miner_type inner Join miner_block on miner_type."Miners"=miner_block.miner order by 1) select '95 %' as "% of Blocks", count("Miners") as "Number of miners" from tab1 where "Block Type" = 'Lower Transaction Count' and "% of Blocks" >= '95' and "Total Blocks" >= '5'), one_hundred as (with tab1 as (with miners as (select CASE when tx_count <= '123' then 'Lower Transaction Count' when '123' < tx_count then 'Higher Transaction Count' else 'Others' end as Block_Type, miner, tx_count from ethereum.core.fact_blocks where tx_count > '0'), miner_block as (select miner, count(block_number) as "Total Blocks" from ethereum.core.fact_blocks where tx_count > '0' group by 1), miner_type as (select miners.miner as "Miners", block_type as "Block Type", count(*) as "Blocks with Lower Txs Count", sum(tx_count) as "Total Txs", avg(tx_count) as "Average Txs per Block" from miners group by 1, 2 order by 1) select "Miners", "Block Type", "Blocks with Lower Txs Count", "Total Blocks", "Total Txs", "Average Txs per Block", ("Blocks with Lower Txs Count"/"Total Blocks"*100) as "% of Blocks" from miner_type inner Join miner_block on miner_type."Miners"=miner_block.miner order by 1) select 'Whole Blocks' as "% of Blocks", count("Miners") as "Number of miners" from tab1 where "Block Type" = 'Lower Transaction Count' and "% of Blocks" >= '100' and "Total Blocks" >= '5') select 'Lower Txs' as "Block Type", * from sixty union select 'Lower Txs' as "Block Type", * from sixty_five union select 'Lower Txs' as "Block Type", * from seventy union select 'Lower Txs' as "Block Type", * from seventy_five union select 'Lower Txs' as "Block Type", * from eighty union select 'Lower Txs' as "Block Type", * from eighty_five union select 'Lower Txs' as "Block Type", * from ninty union select 'Lower Txs' as "Block Type", * from ninty_five union select 'Lower Txs' as "Block Type", * from one_hundred order by 1) order by 2

[Ethereum] - Flash Bounty: Miners