with table_1 as (select event_inputs:"value"/pow(10,18) as ENS_Distributed from ethereum.events_emitted where event_name ilike 'claim' and contract_address ilike '0xC18360217D8F7Ab5e7c516566761Ea12Ce7F9D72') select count(ENS_Distributed) as "Distributed_ENS", CASE WHEN ENS_Distributed <= 100 THEN '<=100' WHEN 100 < ENS_Distributed AND ENS_Distributed <= 200 THEN '100 - 200' WHEN 200 < ENS_Distributed AND ENS_Distributed <= 300 THEN '200 - 300' WHEN 300 < ENS_Distributed AND ENS_Distributed <= 400 THEN '300 - 400' WHEN 400 < ENS_Distributed AND ENS_Distributed <= 500 THEN '400 - 500' WHEN 500 < ENS_Distributed AND ENS_Distributed <= 600 THEN '500 - 600' WHEN 600 < ENS_Distributed AND ENS_Distributed <= 700 THEN '600 - 700' WHEN 700 < ENS_Distributed AND ENS_Distributed <= 800 THEN '700 - 800' WHEN 800 < ENS_Distributed AND ENS_Distributed <= 900 THEN '800 - 900' WHEN 900 < ENS_Distributed AND ENS_Distributed <= 1000 THEN '900 - 1000' WHEN 1000 < ENS_Distributed AND ENS_Distributed <= 1100 THEN '1000 - 1100' WHEN 1100 < ENS_Distributed AND ENS_Distributed <= 1200 THEN '1100 - 1200' WHEN 1200 < ENS_Distributed THEN '>1200' END AS ENS_Distributed_List, CASE WHEN ENS_Distributed <= 100 THEN 1 WHEN 100 < ENS_Distributed AND ENS_Distributed <= 200 THEN 2 WHEN 200 < ENS_Distributed AND ENS_Distributed <= 300 THEN 3 WHEN 300 < ENS_Distributed AND ENS_Distributed <= 400 THEN 4 WHEN 400 < ENS_Distributed AND ENS_Distributed <= 500 THEN 5 WHEN 500 < ENS_Distributed AND ENS_Distributed <= 600 THEN 6 WHEN 600 < ENS_Distributed AND ENS_Distributed <= 700 THEN 7 WHEN 700 < ENS_Distributed AND ENS_Distributed <= 800 THEN 8 WHEN 800 < ENS_Distributed AND ENS_Distributed <= 900 THEN 9 WHEN 900 < ENS_Distributed AND ENS_Distributed <= 1000 THEN 10 WHEN 1000 < ENS_Distributed AND ENS_Distributed <= 1100 THEN 11 WHEN 1100 < ENS_Distributed AND ENS_Distributed <= 1200 THEN 12 WHEN 1200 < ENS_Distributed THEN 13 END AS ENS_Distributed_Ordering from table_1 group by ENS_Distributed_List, ENS_Distributed_Ordering order by ENS_Distributed_Ordering asc

ENS Airdrop Claimed Token Distribution