with total_transactions as (select count(distinct TX_HASH) as tcount,to_date(block_timestamp) as tdate
from ethereum.core.fact_transactions
group by 2)
,success_transactions as (select count(distinct TX_HASH) as tsuccess,to_date(block_timestamp) as sdate
from ethereum.core.fact_transactions
where status='SUCCESS' and to_date(block_timestamp)>= '2022-06-15'
group by 2)
select (100 - tsuccess/tcount*100) as percent,tdate from total_transactions inner join success_transactions
on tdate=sdate