ROW_NUMBER() OVER(partition by pool_name ORDER BY day asc) as rank

from thorchain.daily_pool_stats

where year(day) = '2022'),

currents as (select pool_name, TVL, day

from today

where rank = 1),

maxrank as (select pool_name, max(rank) as maxx

from today

group by 1),

latest as (select a.pool_name, a.TVL, a.day, b.maxx

from today a

left join maxrank b on a.pool_name = b.pool_name

where a.rank = b.maxx)

select a.pool_name, a.day as First_Jan, a.TVL as First_TVL, b.day as Max_Day, b.TVL as Current_TVL,

datediff(day, First_Jan, Max_day) as pool_days_2022, round((((current_tvl-first_tvl)/first_tvl)*100),2) as Growth_Percentage

from currents a

left outer join latest b on a.pool_name = b.pool_name

order by 5 desc