with zero_blocks as (select
count(*) as n_zero_tx_blocks
from avalanche.core.fact_blocks
where block_timestamp >= '2022-6-20'
and tx_count = 0),
total_blocks as (
select count(*) as n_blocks
from avalanche.core.fact_blocks
where block_timestamp >= '2022-6-20'
)
select
z.n_zero_tx_blocks,
(z.n_zero_tx_blocks/t.n_blocks) as percentage_zero_blocks
from zero_blocks z, total_blocks t