date(block_timestamp) as "Date",

count( case when status = 'FAIL' then 1 else null end) as "Failed transactions",

count( case when status = 'SUCCESS' then 1 else null end) as "Successful transactions"

from ethereum.core.fact_transactions

where to_address = '0xdfb57b6e16ddb97aeb8847386989f4dca7202146'

group by 1