donation_data AS (

SELECT

tx_hash,

block_timestamp,

donor_address AS user_id,

service_id,

eth_amount AS eth_value,

eth_amount_usd AS usd_value

FROM

crosschain.olas.ez_service_donations

),

donation_category AS (

usd_value,

CASE

WHEN usd_value BETWEEN 1 AND 9 THEN 'beetween 1 AND 10 $'

WHEN usd_value BETWEEN 10 AND 99 THEN 'beetween 10 AND 100 $'

WHEN usd_value BETWEEN 100 AND 999 THEN 'beetween 100 AND 1K $'

WHEN usd_value BETWEEN 1000 AND 9999 THEN 'beetween 1K AND 10K $'

WHEN usd_value BETWEEN 10000 AND 99999 THEN 'beetween 10K AND 100K $'

ELSE 'More than 100K $'

END AS donation_type

FROM

donation_data

),

transaction_count AS (

SELECT

donation_type,

COUNT(DISTINCT tx_hash) AS txn_count

FROM

donation_category

JOIN