with tab1 as (select tx_id, case

when (amount/pow(10,6))<=1 then 'V<=1 AXL'

when (amount/pow(10,6))>1 and (amount/pow(10,6))<=10 then '1<V<=10 AXL'

when (amount/pow(10,6))>10 and (amount/pow(10,6))<=100 then '10<V<=100 AXL'

when (amount/pow(10,6))>100 and (amount/pow(10,6))<=500 then '100<V<=500 AXL'

when (amount/pow(10,6))>500 and (amount/pow(10,6))<=1000 then '500<V<=1k AXL'

when (amount/pow(10,6))>1000 and (amount/pow(10,6))<=1500 then '1k<V<=1.5k AXL'

when (amount/pow(10,6))>1500 and (amount/pow(10,6))<=3000 then '1.5k<V<=3k AXL'

else 'V>3k AXL' end as "Class"

from axelar.gov.fact_staking

where tx_succeeded='true' and currency='uaxl' and block_timestamp::date>='{{Start_Date}}' AND

block_timestamp::date<='{{End_Date}}' and action='delegate')

select "Class", count(distinct tx_id) as "TXs Count"

from tab1

group by 1