CASE

WHEN total_price BETWEEN 0 AND 1 THEN '0-1 APT'

WHEN total_price BETWEEN 1 AND 5 THEN '1-5 APT'

WHEN total_price BETWEEN 5 AND 10 THEN '5-10 APT'

WHEN total_price BETWEEN 10 AND 15 THEN '10-15 APT'

WHEN total_price BETWEEN 15 AND 20 THEN '15-20 APT'

WHEN total_price BETWEEN 20 AND 25 THEN '20-25 APT'

WHEN total_price BETWEEN 25 AND 30 THEN '25-30 APT'

WHEN total_price BETWEEN 30 AND 50 THEN '30-50 APT'

WHEN total_price BETWEEN 50 AND 70 THEN '50-70 APT'

ELSE 'More than 70 APT'

END AS price_range,

COUNT(tx_hash) AS number_of_sales

aptos.nft.ez_nft_sales

project_name ILIKE '%Aptomingos%'

GROUP BY

price_range

ORDER BY

price_range ASC