proposer,

count(*) as n

from flow.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 (proposer) from b group by 1