with token as (

SELECT DISTINCT S.token0

from ethereum.dex_liquidity_pools S

where platform = 'sushiswap'

,

launch as (

SELECT T.token0 , min(creation_time::date) as launched_date_on_sushiswap

from ethereum.dex_liquidity_pools S , token T

where platform = 'sushiswap'

and T.token0 = S.token0

and creation_time is not NULL

group by 1

order by 2 desc

)

,

coin as (

SELECT launched_date_on_sushiswap , C.name as symbol, C.address as contract_address

from launch L , ethereum.contracts C

where L.token0 = C.address

order by 1 desc

)

,

sel as (

SELECT symbol, sum(AMOUNT_USD) as swap, count(tx_id)

from coin C , ethereum.dex_Swaps

where TOKEN_ADDRESS = contract_address

and platform = 'sushiswap'

and block_timestamp::date >='2022-01-01'

group by 1

)

SELECT launched_date_on_sushiswap , E.symbol, C.contract_address

from sel S , coin C

left outer join ethereum.erc20_balances E on E.contract_address = C.contract_address