select count( distinct tx_from_address)::string as n_address_short, sum(n_short_opt_bought)::string as n_short_opt_bought
from (select tx_from_address, count(tx_id) as n_short_opt_bought from ethereum.events_emitted
where --x_id='0x122f2e39cf477f6cdefa71e9d8f94770bdddb058ce486d273a114fa1125d2d6d'and
tx_to_address='0xa653e22a963ff0026292cc8b67941c0ba7863a38' and event_name='Transfer'
--tx_id='0x6e765fec43e83768007c3969772c5b27a0613df9abaf0e4d91c4076562d3d0f4' and
--contract_address='0xf1b99e3e573a1a9c5e6b2ce818b617f0e664e86b' and
group by 1 order by 1)