,t1 as (select sum(balance) as am1 , date from datas where balance_type='liquid' group by date)

,t2 as (select sum(balance) as am2 , date from datas where balance_type='staked' group by date)

,q1 as (select am1/am2 , t1.date from t1 inner join t2 on t1.date=t2.date)

, t3 as (select max(date) as maxdate,address from datas group by address )

, t4 as (select max(date) as maxdate,address from datas where year(date)<2022 group by address )

, q2p1 as (select sum(balance/1e6) , datas.address from datas inner join t3 on datas.date= maxdate and datas.address=t3.address

group by datas.address

order by 1 DESC

limit 100)

, q2p2 as (select sum(balance/1e6) , datas.address from datas inner join t4 on datas.date= maxdate and datas.address=t4.address

group by datas.address

order by 1 DESC

limit 100)

, q3p1 as (select sum(balance/1e6) / count(distinct address) from datas)

, q3p2 as (select sum(balance/1e6) / count(distinct address) , date from datas group by date)

, q3p3 as (select sum(balance/1e6) / count(distinct address) ,count(distinct address) , date from datas group by date)

select * from q1