case

when ORIGIN_FUNCTION_SIGNATURE = '0x9cd19996' then 'Mint to Treasury'

when ORIGIN_FUNCTION_SIGNATURE = '0x2dad97d4' then 'Repay with ATokens'

when ORIGIN_FUNCTION_SIGNATURE = '0x42b0b77c' then 'Flash Loan Simple'

when ORIGIN_FUNCTION_SIGNATURE = '0xe8eda9df' then 'Deposit'

when ORIGIN_FUNCTION_SIGNATURE = '0x28530a47' then 'Set User E Mode'

when ORIGIN_FUNCTION_SIGNATURE = '0x5a3b74b9' then 'Set User Use Reserve as Collateral'

when ORIGIN_FUNCTION_SIGNATURE = '0x66514c97' then 'Borrow'

when ORIGIN_FUNCTION_SIGNATURE = '0x02c5fcf8' then 'Repay'

when ORIGIN_FUNCTION_SIGNATURE = '0x69328dec' then 'Withdraw'

when ORIGIN_FUNCTION_SIGNATURE = '0x573ade81' then 'Repay'

when ORIGIN_FUNCTION_SIGNATURE = '0x617ba037' then 'Deposit'

when ORIGIN_FUNCTION_SIGNATURE = '0xa415bcad' then 'Borrow'

when ORIGIN_FUNCTION_SIGNATURE = '0x80500d20' then 'Withdraw'

when ORIGIN_FUNCTION_SIGNATURE = '0x474cf53d' then 'Deposit'

end as "Methods",

count(distinct tx_hash) as "Actions",

count(distinct from_address) as "Unique Users"

from base.core.fact_transactions

where TO_ADDRESS in ('0xa238dd80c259a72e81d7e4664a9801593f98d1c5','0x18cd499e3d7ed42feba981ac9236a278e4cdc2ee')

and STATUS = 'SUCCESS'

group by 1

order by 2 desc