SELECT

CASE

WHEN decoded_log:assets::int / 1e18 < 100 THEN '0-100 LRON'

WHEN decoded_log:assets::int / 1e18 < 500 THEN '100-500 LRON'

WHEN decoded_log:assets::int / 1e18 < 1000 THEN '500-1000 LRON'

WHEN decoded_log:assets::int / 1e18 < 5000 THEN '1000-5000 LRON'

ELSE '5000+ LRON'

END as deposit_range,

origin_from_address as user_address

FROM ronin.core.ez_decoded_event_logs

WHERE

contract_address = LOWER('0xcad9e7aa2c3ef07bad0a7b69f97d059d8f36edd2')

AND event_name = 'Deposit'

deposit_range,

COUNT(DISTINCT user_address) as unique_users,

COUNT(*) as total_deposits

FROM deposits

GROUP BY 1

ORDER BY

CASE deposit_range

WHEN '0-100 LRON' THEN 1

WHEN '100-500 LRON' THEN 2

WHEN '500-1000 LRON' THEN 3

WHEN '1000-5000 LRON' THEN 4

ELSE 5

END