with tt as( with t1 as(with a1 as(select distinct(POSTTOKENBALANCES[0]:owner) as wallet, POSTTOKENBALANCES[0]:uiTokenAmount:amount/1e9 as recieved from solana.transfers where block_timestamp::date >= '2022-03-15' and source = 'HhXAKYmRzBNi7BjkDs2fbwJ49mnpWUtzyXEf8PAMArs4' and authority = 'STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK' and POSTTOKENBALANCES[0]:owner !='STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK' and recieved<=100000 group by 1,2 order by 2 DESC), a2 as(select distinct(POSTTOKENBALANCES[2]:owner) as wallet, POSTTOKENBALANCES[2]:uiTokenAmount:amount/1e9 as recieved from solana.transfers where block_timestamp::date >= '2022-03-15' and source = 'HhXAKYmRzBNi7BjkDs2fbwJ49mnpWUtzyXEf8PAMArs4' and authority = 'STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK' and POSTTOKENBALANCES[0]:owner !='STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK' and recieved<=100000 group by 1,2 order by 2 DESC), a3 as(select distinct(POSTTOKENBALANCES[3]:owner) as wallet, POSTTOKENBALANCES[3]:uiTokenAmount:amount/1e9 as recieved from solana.transfers where block_timestamp::date >= '2022-03-15' and source = 'HhXAKYmRzBNi7BjkDs2fbwJ49mnpWUtzyXEf8PAMArs4' and authority = 'STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK' and POSTTOKENBALANCES[0]:owner !='STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK' and recieved<=100000 group by 1,2 order by 2 DESC), a4 as(select distinct(POSTTOKENBALANCES[4]:owner) as wallet, POSTTOKENBALANCES[4]:uiTokenAmount:amount/1e9 as recieved from solana.transfers where block_timestamp::date >= '2022-03-15' and source = 'HhXAKYmRzBNi7BjkDs2fbwJ49mnpWUtzyXEf8PAMArs4' and authority = 'STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK' and POSTTOKENBALANCES[0]:owner !='STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK' and recieved<=100000 group by 1,2 order by 2 DESC), a5 as(select distinct(POSTTOKENBALANCES[5]:owner) as wallet, POSTTOKENBALANCES[5]:uiTokenAmount:amount/1e9 as recieved from solana.transfers where block_timestamp::date >= '2022-03-15' and source = 'HhXAKYmRzBNi7BjkDs2fbwJ49mnpWUtzyXEf8PAMArs4' and authority = 'STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK' and POSTTOKENBALANCES[0]:owner !='STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK' and recieved<=100000 group by 1,2 order by 2 DESC), a6 as(select distinct(POSTTOKENBALANCES[6]:owner) as wallet, POSTTOKENBALANCES[6]:uiTokenAmount:amount/1e9 as recieved from solana.transfers where block_timestamp::date >= '2022-03-15' and source = 'HhXAKYmRzBNi7BjkDs2fbwJ49mnpWUtzyXEf8PAMArs4' and authority = 'STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK' and POSTTOKENBALANCES[0]:owner !='STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK' and recieved<=100000 group by 1,2 order by 2 DESC) select * from a1 union ALL select * from a2 union ALL select * from a3 union ALL select * from a4 union ALL select * from a5 union ALL select * from a6 where recieved<=100000 order by 2 desc) select 'All users behavior' as f1, count(wallet) as total_receivers, sum (recieved) as total_GMT from t1), tt2 as (with t1 as(with a1 as(select distinct(POSTTOKENBALANCES[0]:owner) as wallet, POSTTOKENBALANCES[0]:uiTokenAmount:amount/1e9 as recieved from solana.transfers where block_timestamp::date >= '2022-03-15' and source = 'HhXAKYmRzBNi7BjkDs2fbwJ49mnpWUtzyXEf8PAMArs4' and authority = 'STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK' and POSTTOKENBALANCES[0]:owner !='STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK' and recieved<=100000 group by 1,2 order by 2 DESC), a2 as(select distinct(POSTTOKENBALANCES[2]:owner) as wallet, POSTTOKENBALANCES[2]:uiTokenAmount:amount/1e9 as recieved from solana.transfers where block_timestamp::date >= '2022-03-15' and source = 'HhXAKYmRzBNi7BjkDs2fbwJ49mnpWUtzyXEf8PAMArs4' and authority = 'STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK' and POSTTOKENBALANCES[0]:owner !='STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK' and recieved<=100000 group by 1,2 order by 2 DESC), a3 as(select distinct(POSTTOKENBALANCES[3]:owner) as wallet, POSTTOKENBALANCES[3]:uiTokenAmount:amount/1e9 as recieved from solana.transfers where block_timestamp::date >= '2022-03-15' and source = 'HhXAKYmRzBNi7BjkDs2fbwJ49mnpWUtzyXEf8PAMArs4' and authority = 'STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK' and POSTTOKENBALANCES[0]:owner !='STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK' and recieved<=100000 group by 1,2 order by 2 DESC), a4 as(select distinct(POSTTOKENBALANCES[4]:owner) as wallet, POSTTOKENBALANCES[4]:uiTokenAmount:amount/1e9 as recieved from solana.transfers where block_timestamp::date >= '2022-03-15' and source = 'HhXAKYmRzBNi7BjkDs2fbwJ49mnpWUtzyXEf8PAMArs4' and authority = 'STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK' and POSTTOKENBALANCES[0]:owner !='STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK' and recieved<=100000 group by 1,2 order by 2 DESC), a5 as(select distinct(POSTTOKENBALANCES[5]:owner) as wallet, POSTTOKENBALANCES[5]:uiTokenAmount:amount/1e9 as recieved from solana.transfers where block_timestamp::date >= '2022-03-15' and source = 'HhXAKYmRzBNi7BjkDs2fbwJ49mnpWUtzyXEf8PAMArs4' and authority = 'STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK' and POSTTOKENBALANCES[0]:owner !='STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK' and recieved<=100000 group by 1,2 order by 2 DESC), a6 as(select distinct(POSTTOKENBALANCES[6]:owner) as wallet, POSTTOKENBALANCES[6]:uiTokenAmount:amount/1e9 as recieved from solana.transfers where block_timestamp::date >= '2022-03-15' and source = 'HhXAKYmRzBNi7BjkDs2fbwJ49mnpWUtzyXEf8PAMArs4' and authority = 'STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK' and POSTTOKENBALANCES[0]:owner !='STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK' and recieved<=100000 group by 1,2 order by 2 DESC) select * from a1 union ALL select * from a2 union ALL select * from a3 union ALL select * from a4 union ALL select * from a5 union ALL select * from a6 where recieved<=100000 order by 2 desc) select 'Sent user' as f1, count(distinct authority) as Tranfer_GMT_users, sum(amount/1e3) as amount_sent_GMT from solana.transfers where authority in (select wallet from t1) and block_timestamp::date >= '2022-03-15' group by 1) select * from tt union ALL select * from tt2

Solana_GMT_Airdrop