project_name,

sum(total_addresses) total_users,

total_users/ sum(total_users) over() share

from(

select

project_name,

count(distinct address) total_addresses

from

avalanche.core.dim_labels

where label_type = 'cex'

and label_subtype = 'deposit_wallet'

group by project_name

order by total_addresses desc) x

group by x.project_name

order by total_users desc