with fix_parameter as (

select

case

when '{{Days}}' = 'All time' then 2000

when '{{Days}}' = 'Last 30 days' then 30

when '{{Days}}' = 'Last 60 days' then 60

when '{{Days}}' = 'Last 90 days' then 90

when '{{Days}}' = 'Last 180 days' then 180

when '{{Days}}' = 'Last 360 days' then 360

else 30

end as time_frame,

case

when '{{Chain_Comparison}}' = 'All chains' then 'Ethereum,Algorand,Solana,Optimism,Osmosis,Axelar,Near,Flow'

when '{{Chain_Comparison}}' = 'Ethereum vs Algorand' then 'Ethereum,Algorand'

when '{{Chain_Comparison}}' = 'Ethereum vs Solana' then 'Ethereum,Solana'

when '{{Chain_Comparison}}' = 'Ethereum vs Optimism' then 'Ethereum,Optimism'

when '{{Chain_Comparison}}' = 'Ethereum vs Osmosis' then 'Ethereum,Osmosis'

when '{{Chain_Comparison}}' = 'Ethereum vs Axelar' then 'Ethereum,Axelar'

when '{{Chain_Comparison}}' = 'Ethereum vs Near' then 'Ethereum,Near'

when '{{Chain_Comparison}}' = 'Ethereum vs Flow' then 'Ethereum,Flow'

when '{{Chain_Comparison}}' = 'Algorand vs Solana' then 'Algorand,Solana'

when '{{Chain_Comparison}}' = 'Algorand vs Optimism' then 'Algorand,Optimism'

when '{{Chain_Comparison}}' = 'Algorand vs Osmosis' then 'Algorand,Osmosis'

when '{{Chain_Comparison}}' = 'Algorand vs Axelar' then 'Algorand,Axelar'

when '{{Chain_Comparison}}' = 'Algorand vs Near' then 'Algorand,Near'

when '{{Chain_Comparison}}' = 'Algorand vs Flow' then 'Algorand,Flow'

when '{{Chain_Comparison}}' = 'Solana vs Optimism' then 'Solana,Optimism'

when '{{Chain_Comparison}}' = 'Solana vs Osmosis' then 'Solana,Osmosis'

when '{{Chain_Comparison}}' = 'Solana vs Axelar' then 'Solana,Axelar'

when '{{Chain_Comparison}}' = 'Solana vs Near' then 'Solana,Near'

when '{{Chain_Comparison}}' = 'Solana vs Flow' then 'Solana,Flow'

when '{{Chain_Comparison}}' = 'Optimism vs Osmosis' then 'Optimism,Osmosis'

when '{{Chain_Comparison}}' = 'Optimism vs Axelar' then 'Optimism,Axelar'