count(distinct name) as user_cnt

(select Rank,

LEADERBOARD_TYPE as "Leaderboard Type",

Name,

case

when GOLD_AMOUNT between 0 and 100000 then '0 - 100K Gold'

when GOLD_AMOUNT between 100001 and 200000 then '100K - 200K Gold'

when GOLD_AMOUNT between 200001 and 400000 then '200K - 400K Gold'

when GOLD_AMOUNT between 400001 and 600000 then '400K - 600K Gold'

when GOLD_AMOUNT between 600001 and 800000 then '600K - 800K Gold'

when GOLD_AMOUNT > 800000 then '>800K Gold'

end as label

from

(select date,

LEADERBOARD_TYPE,

NAME,

GOLD_AMOUNT,

-- GOLD_AMOUNT,

rank

from external.blast.fact_leaderboard)

where date = current_date() - 1

and

LEADERBOARD_TYPE = 'gold'

order by rank asc )

group by 1