SELECT

block_timestamp,

tx_id,

msg:sender AS sender,

value:addr AS address,

(value:coins[0]:amount)/pow(10,6) AS amount,

value:coins[0]:denom AS token

FROM osmosis.core.fact_tx_body_msgs, LATERAL FLATTEN (input => msg:msg:transfer:recipients)

WHERE sender = 'osmo1qrwt8r63jks74ykgq7d28fvy6msd2dpgz8zxaj'

AND block_timestamp::date = '2023-12-20'

ORDER BY amount DESC

(CASE

WHEN amount < 500 THEN 'Less Than 500 Tokens'

WHEN amount >= 500 AND amount < 1000 THEN 'Between 500 and 1K Tokens'

WHEN amount >= 1000 AND amount < 5000 THEN 'Between 1K and 5K Tokens'

WHEN amount >= 5000 AND amount < 10000 THEN 'Between 5K and 10K Tokens'

WHEN amount >= 10000 THEN 'More Than 10K Tokens'

END) AS label,

COUNT(DISTINCT address) AS users

FROM airdrop

GROUP BY 1