SELECT CASE WHEN amount <= 10 THEN '0 - 10'
WHEN amount >10 AND amount <= 100 THEN '10+ - 100'
WHEN amount >100 AND amount <= 1000 THEN '100+ - 1000'
WHEN amount >1000 AND amount <= 10000 THEN '1000+ - 10000'
ELSE '10000+'
END AS asset_range, COUNT(DISTINCT tx_id) as tx_count
FROM algorand.payment_transaction
WHERE asset_id = 0 AND date(block_timestamp) >= '2022-01-01'
GROUP BY asset_range
ORDER BY asset_range