select

price_category,

count(*) as total

from

(

select

case

when price <= 0.01 then 'Trinket'

when price > 0.01 and price <= 0.1 then 'Souvenir'

when price > 0.1 and price <= 1 then 'Keepsake'

when price > 1 then 'Heirloom'

else 'null'

end as price_category

from

ethereum.core.ez_nft_sales

where

1 = 1

and event_type = 'sale'

and block_timestamp::date > '2021-12-18'

)

group by 1

order by 1 desc

select price_category, total,

round(100 * total / (select sum(total) from base), 1) as percent

from base

where price_category <> 'null'