date_trunc('day', BLOCK_TIMESTAMP)::date AS day,

iff(BLOCK_TIMESTAMP::date ilike '2022%', '2022', '2023') as type,

count(*) AS TXs,

sum(case when TX_SUCCEEDED!='TRUE' then 1 else 0 end) AS "Failed TX",

("Failed TX"/TXs)*100 AS "Failed %",

sum(FEE) AS "Fee Amount"

from terra.core.fact_transactions

where BLOCK_TIMESTAMP::date >= '2022-01-01'

group by 1,2