date_trunc('week', block_timestamp) as "Day",

case when TX_SUCCEEDED=TRUE then 'Succeeded' else 'Faliled' end as "Status",

count(distinct TX_ID) as "Num transactions"

from terra.core.fact_transactions

group by 1,2

order by 2 desc