select blockchain, count(distinct from_address) as number_of_users from (
--------------------Get unique users from upgrades--------------------------------
select distinct from_address, substr(burn_asset,1,3) as blockchain from thorchain.upgrades
union all
select distinct to_address as from_address, 'THOR' as blockchain from thorchain.upgrades
)
group by blockchain