select

Case

when Payer like '0x55ad22f01ef568a1' then 'Blocto'

end as program,

count(distinct AUTHORIZERS[0])

from flow.core.fact_transactions

left outer join flow.core.fact_events on flow.core.fact_transactions.tx_id = flow.core.fact_events.tx_id

where event_type like 'FeesDeducted'

and payer like '0x55ad22f01ef568a1'

group by 1