TX_SENDER,

count(*) as n

from terra.core.fact_transactions group by 1

select

case

when n = 1 then 'never came back'

when n >1 then ' came back' end as type, count (TX_SENDER) from b group by 1