when error_msg like '%No token matching this ID for sale%' then 'No token matching this ID for sale'

when error_msg like '%storage which is over its capacity%' then 'out of storage'

when error_msg like '%Amount withdrawn must be less than or equal than the balance of the Vault%' then 'insufficient balance'

when error_msg like '%invalid proposal key%' then 'invalid proposal key'

when error_msg like '%underflow%' then 'underflow'

when error_msg like '%assertion failed: fail%' then 'fail'

when error_msg like '%Not enough Token2 in the pool%' then 'Not enough Token in the pool'

when error_msg like '%This person already claimed their FLOAT%' then 'This person already claimed their FLOAT'

when error_msg like '%You did not input the correct secret phrase%' then 'You did not input the correct secret phrase'

when error_msg like '%payer account does not have sufficient signatures%' then 'payer account does not have sufficient signatures'

when error_msg like '%missing NFT%' then 'missing NFT'

when error_msg like '%Could not borrow a reference to the receiver%' then 'Could not borrow a reference to the receiver'

when error_msg like '%This FLOAT is not transferrable%' then 'This FLOAT is not transferrable'

when error_msg like '%missing Listing%' then 'missing Listing'

when error_msg like '%You do not own this FLOAT in your collection%' then 'You do not own this FLOAT in your collection'

else 'others' end as type, count(*)

from flow.core.fact_transactions

where block_timestamp::date >= '2022-05-09' and tx_succeeded = false

group by 1

order by 2 desc